Tuesday, March 10, 2009

Find your ATG Rollup Patch Level in R12

Please use the following query to find the ATG rollup Patch level in your application.

column BUG format a8;
column PATCH format a60;

set linesize 100;
set pagesize 200;
select b.bug_number BUG, b.LAST_UPDATE_DATE LDATE, decode(bug_number,
4440000, 'Oracle Applications Release 12 Maintenance Pack',
5082400, '12.0.1 Release Update Pack (RUP1)',
5484000, '12.0.2 Release Update Pack (RUP2)',
6141000, '12.0.3 Release Update Pack (RUP3)',
6435000, '12.0.4 RELEASE UPDATE PACK (RUP4)',
5907545, 'R12.ATG_PF.A.DELTA.1',
5917344, 'R12.ATG_PF.A.DELTA.2',
6077669, 'R12.ATG_PF.A.DELTA.3',
6272680, 'R12.ATG_PF.A.DELTA.4',
7237006, 'R12.ATG_PF.A.DELTA.6',
6728000, '12.0.6 RELEASE UPDATE PACK (RUP6)'
from AD_BUGS b
where b.BUG_NUMBER in ('4440000','5082400','5484000','6141000','6435000',
order by patch;

How To Determine the Products Installed and Patchset level in EBS

There are are several ways to find out which products are installed, shared or inactive. Please use any of the options listed below.

1. Run Licence Manager

2. Run the following script in Sqlplus as apps user:
cd $AD_TOP/sql/adutconf.sql
Sqlplus> @adutconf.sql
This creates a text file adutconf.lst in the current working directory.

3. Run the following query in Sqlplus as apps user:
select a.application_short_name,a.APPLICATION_NAME,decode(fpi.status,'I','Installed','S','Shared','N','Inactive',fpi.status) status
from apps.fnd_application_vl a, apps.fnd_product_installations fpi where
fpi.application_id = a.application_id and
fpi.status in ('I','S')
order by 3,1

where Status:
I = Installed
S = Shared
N = Not Installed

4. Run patchsets.sh to determine the current family pack level and patchset level, get patchsets.sh from


How to License a product in Oracle E-Business Suite

The following are the steps to License a product through Oracle Application Manager

1. Login to Oracle Applications Manager

2. Click on Site Map

3. Click on License Manager

4. Under License heading, click Products

5. Click on blue plus icon of show More options

6. Click on the radio button: License Applications Product

7. Click on continue button

8. You'll get a list of all the individual products

9. Check the box on the left of the product you want to license

10. Click on Next button

11. Click on Submit button

12. You'll get a message: Sucessfully licensed the selected product(s). Click OK

How to find the Oracle XML Publisher version

You can find out the XML Publisher version either from the output of the report or from the MetaInfo.class in both 11i & R12.

strings $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class|grep -i 'XML Publisher'