Tuesday, July 14, 2009

Useful Metalink Notes

246105.1 - Upgrading to J2SE 1.4.2 with Oracle Applications 11i
125767.1 - Upgrading Developer 6i with Oracle Applications 11i
124606.1 - Upgrading Oracle JInitiator with Oracle E-Business Suite 11i
216550.1 - Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0 Upgrade)
362203.1 - Oracle E-Business Suite Release 11i
with Oracle Database 10g Release 2 (10.2.0 Upgrade)
782224.1 - Interoperability Notes Oracle E-Business Suite Release 12 with 11gR1 (
467778.1 - Oracle 10gR2 ( Database Preparation Guidelines for an E-Business Suite Release 12.0 Upgrade
316889.1 - Complete Checklist for Manual Upgrades to 10gR2
1617458.1 - Oracle E-Business Suite Release 12.2.4 Readme
1926201.1 - Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1

169706.1 - Oracle Database on Operating Systems Installation and Configuration Requirements
287453.1 - Oracle Applications 11.5.10 - Installation Update Notes for all Operating Systems
402310.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)
316365.1 - Oracle Applications Release Maintenance Pack Installation Instructions ( Upgrade)
402312.1 - Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Solaris Operating System (SPARC)

135792.1 - Cloning Oracle Applications Release 11i
230672.1 - Cloning Oracle Applications Release 11i with Rapid Clone
218089.1 - Autoconfig FAQ
165195.1 - Using AutoConfig to Manage System Configurations with Oracle Applications 11i

244040.1 - Oracle E-Business Suite Recommended Performance Patches

249669.1 - How To Collect Apache and Jserv Debugging Details For Applications 11i
230688.1 - Basic ApacheJServ Troubleshooting with IsItWorking.class With Applications 11i
753845.1 - How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java Mailer Issues
317307.1 - How to Test IMAP, POP, SMTP
469822.1 - Oracle Workflow Release 12 Diagnostics

216205.1 - Database Initialization Parameters for Oracle Applications Release 11i
396009.1 - Database Initialization Parameter Settings for Oracle Applications Release 12
380482.1 - Oracle E-Business Suite Release 12 Technology Stack Documentation Roadmap
287176.1 - DMZ Configuration with Oracle E-Business Suite 11i
380490.1 - Oracle E-Business Suite R12 Configuration in a DMZ

238276.1 - Migrating to Linux with Oracle Applications Release 11i
230627.1 - 9i Export/Import Process for Oracle Applications Release 11i
331221.1 - 10g Export/Import Process for Oracle Applications Release 11i
362205.1 - 10g Release 2 Export/Import Process for Oracle Applications Release 11i
1133355.1 - Migrating an Oracle E-Business Suite Database to Oracle Exadata Database Machine

277650.1 - How to Use Export and Import when Transferring Data Across Platforms or Across 32-bit and 64-bit Servers
243304.1 - 10g: Transportable Tablespaces Across Different Platforms
341733.1 - Export/Import DataPump Parameters INCLUDE and EXCLUDE - How to Load and Unload Specific Objects

Real Application Cluster(RAC)
270512.1 - Adding a Node to a 10g RAC Cluster
269320.1 - Removing a Node from a 10gR1 RAC Cluster

Data Guard
180031.1 - Creating a Data Guard Configuration
214071.1 - Creating a configuration using Data Guard Manager
232240.1 - Performing Switchover in a Data Guard Configuration without the Data Guard Broker
215020.1 - Troubleshooting Logical Standby

139516.1 - Discoverer 4i with Oracle Applications 11i
362851.1 - Guidelines to setup the JVM in Apps 11i
304099.1 - Using J2SE Version 5.0 with Oracle E-Business Suite 11i
201340.1 - Using Forms Listener Servlet with Oracle Applications 11i
169768.1 - Configuring Wallet Manager to enable HTTPS connections via UTL_HTTP.REQUEST
209870.1 - How to Reload the JVM in 9.2.0.X
403537.1 - Best Practices for Securing Oracle E-Business Suite Release 12

Wednesday, April 8, 2009

How to find Apache Version in Oracle Apps 11i

Login to Web tier as applmgr user
cd $IAS_ORACLE_HOME/Apache/Apache/bin
Run the following command
./httpd -version
You will see the output like below

Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Dec 6 2005 14:59:13 (iAS rollup 5)
Which means you are on iAS Version with patchset rollup 5 with Apache Version 1.3.19

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'