Application Management Pack and Application Change Management Pack 3.1 Now Available

a new version of of Application Management Pack 3.1 and Application Change Management Pack 3.1 for Oracle E-Business Suite had been released earlier this year.
Application Management Pack (AMP) and Application Change Management Pack (ACMP) extend Oracle Enterprise Manager Grid Control 10g to monitor and manage Oracle E-Business Suite components and the changes the system
read more..

EBS 12.1.1 Test Starter Kit now Available for Oracle Application Testing Suite

Ever discussed automated testing tools for the E-Business Suite several times on this blog, since testing is such a key part of everyone’s implementation lifecycle. An important part of our testing arsenal in E-Business Suite Development is the Oracle Application Testing Suite. The Oracle Application Testing Suite (OATS) is built on the foundation
read more..

Use the functional administrator responsibility for clearing application cache

Every needed a memory cleanup but no sysadmin or dba available or willing . You can do it through the application
1- Navigate to Functional Administrator Responsibility
2- Choose the “ Core Services” Tab
3- Choose “Caching Framework”
4- Click on “Global Configuration”
5- Click on “Clear All Cache”
6- The Click on yes on the display which will appear.

Change Sysadmin Password from backend

As you very much aware that you can change SYSADMIN password using FNDCPASS utility
FNDCPASS apps/appspwd 0 Y system/manager USER SYSADMIN sysadminpwd
Here I am giving another way to change the SYSADMIN password and Application User Login passwords using fnd_user_pkg from backend. Here is the procedure
sql> declare
var_l boolean;
begin
var_l=fnd_user_pkg.change_password(’sysadmin’,’sysadminpwd’);
end;
sql> PL/SQL Procedure Successfully Compiled.
You can verify from backend that
read more..

Display Oracle background processes in Windows

Question: I knows how to use the “ps -ef” command in UNIX to see my Oracle background processes but I don’t know how to see the background processes in Windows. When I view Oracle processes on Windows, all I see is one background process called oracle.exe. How do you see details on
read more..

De voordelen van Ubunto (dat ik dat ga zeggen :-(

U heeft misschien nog nooit van Ubuntu gehoord, maar toch is het echt de moeite waard om er iets over te weten te komen. Ubuntu is een besturingssysteem, net zoals Windows 7 of Macintosh. Het is een vorm van Linux. Toch zijn er grote verschillen. Het grootste verschil is dat Ubuntu OpenSource is. dit brengt
read more..

Pricelist and Pricing Context

In order to automatically determine the price applicable for a certain customer, products are setup on a pricelist.
Oracle Pricing Manager > Price Lists > Price List Setup
The following Pricelists are currently defined in our example :

Name

Description

Currency

Round to

Payment Term

Standard Customer  (incl. VAT)

Standard Customers (including VAT)

EUR

-2

B1

This pricelist is used for the regular process. So all Quotes, Orders derive
read more..

Advanced Pricing Retrieve overview of modifiers.

Working with Oracle Advanced Pricing, keeps you alert en quickly lose overview. I have developed a query where you receive a list of modifiers which you can export to Excel for more analyse or easier reading.

select (select par.value  from v$parameter par
     where par.name = ‘mts_service’)||’, ‘||to_char(sysdate,’DD-MON-YYYY HH24:MI’)           Environment
,    decode(mh.list_type_code
    , ‘PRO’,’Promotion’
    ,
read more..

Retrieve Incomplete Invoices before month end

Below you find a script to retrieve all incomplete invoices for the month closing procedure. Just get the extra turnover in .

CREATE TABLE  XXTMP_EP_INCOMPLETE_INVOICES
AS
SELECT /*+RULE */
       hca.account_number                  klant_nr
,      ctx.trx_number                      factuur_nr
,      TO_CHAR(ctx.trx_date,’DD-MM-YYYY’)  factuur_datum
,      ctt.NAME                            factuur_type
,      ctx.customer_trx_id
,      ctx.bill_to_customer_id
,      ctx.cust_trx_type_id
FROM   apps.ra_cust_trx_types_all  ctt
,      apps.hz_cust_accounts     hca
,      apps.ra_customer_trx_all  ctx
WHERE  NVL(ctx.complete_flag,’N’) = ‘N’
AND    ctx.bill_to_customer_id    = hca.cust_account_id
AND    ctx.cust_trx_type_id       = ctt.cust_trx_type_id

Reverse Receipts / Receiptbatch

So now and then things go wrong . In our case we have created a receiptbatch and sent the file to the bank. The status of the cash receipt is SENT. But something is wrong and whole receipt batch or some receipts have to be reversed. In our case we have always batches with
read more..