How to Upgrade Oracle Application Server 10g R2 (10.1.2) forms/reports in R12/12i – 5983622

Posted: June 9, 2013 in Forms

This post covers overview of Forms and Reports Upgrade in Oracle Apps R12 (12.0.X) to

Key Points for 10.1.2 upgrade in R12/12i (12.0.X)

1.There are two ORACLE_HOMEs on Application Tier
10.1.2.X for Forms & Reports
10.1.3.X for Web Server & J2EE application

2. By default, R12 uses Forms Servlet Architecturefor forms requests (to know more about Forms Servlet click here ); which uses J2EE container (JVM) in 10.1.3 ORACLE_HOME .
This means one HTTP Server (Apache) in 10.1.3 ORACLE_HOME serves all HTTP, Forms and Reports requests. (HTTP Server in 10.1.2 Oracle Home is not used)

You need to deploy new Forms Servlet (formsapp.ear) to 10.1.3 Oracle Home after 10.1.2 Oracle Home upgrade.

3.Deploying new Forms Servlet to 10.1.3 Oracle HOme means deployingformsapp.ear file to 10.1.3 ORACLE_HOME. Use -script=CfgOC4JAppto deploy new forms servlet in 10.1.3 Home (Metalink Note 397174.1)

4.oc4jadmin password (for 10.1.3 HOME) is stored in xml file $INST_TOP/ ora/ 10.1.3/ j2ee/ forms/ config/ system-jazn-data.xml , If you don’t know oc4jadminpassword or wish to change it use steps mentioned here

5. To check forms/reports current version in R12 use
$ $ORACLE_HOME/bin/frmcmp help=y
Forms 10.1 (Form Compiler) Version (Production)

6. You need ias_admin password during forms and reports upgrade (default password is secret). Test that you can login as ias_admin/secret

emctl authenticate secret
Oracle Enterprise Manager 10g Application Server Control Release
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.


If you get error like 
$ORACLE_HOME/bin/emctl: /d2/ R12/ ab/ apps/ RUP4XB6/ apps/ tech_st/ 10.1.2: does not exist


Open $ORACLE_HOME/bin/ emctlemagentdeploy.plemdctl and change ORACLE_HOME to correct value

If you get error like /d2/ R12/ ab/ apps/ RUP4XB6/ apps/ tech_st/ 10.1.2/ sysman/ j2ee/ config/ jazn-data.xml (No such file or directory)

Copy $ORACLE_HOME/sysman/j2ee/config/jazn-data.xml to /d2/R12/ab/apps/RUP4XB6/apps/tech_st/10.1.2/sysman/j2ee/config



Forms & Reports Upgrade steps in R12

 Stop Middle Tier Services

2.Download & install pre-req patch (conditional)

 Ensure that Inventory is pointing to right location

Install (5983622 – This is latest Forms & Report Patchset) usingrunInstaller from Disk1 (inside patch)
4.1 Select “Oracle Application Server and Developer Suite 10g Rel 2 Software Update” on Select a Product to Install screen
4.2 When prompted for ias_admin password on Application Server Instance Password screen enter secret

5. Shutdown OPMN from 10.1.2 Home (Installer starts OPMN after upgrade)

6. Apply additional interoperability patches

7. Rebuild Forms & Regenerate Jar files

8. Deploy new Forms Servlet to 10.1.3 Oracle Home

9. Start Application

For Step 1-7 follow metalink note 437878.1
For Step 8 follow metalink note 397174.1

For Step 4 follow readme of patch 5983622


  • 437878.1  Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
  • 397174.1  Deploying a New Forms .ear File in Oracle Applications Release 12
  • 387106.1  Unable to Apply OracleAS 10g Rel 2 Patchset: ias_admin – “Password Entered .. Is Incorrect”
  • 761995.1  Error when following Note 437878.1 : “password you have entered is incorrect. Please enter the ias_admin password that is assigned for this instance
  • 420649.1  DBUA from 10Gr2 Oracle Home comes with R12 RapidInstall is not working
  • Read Me of Patch – 5983622
  • Deploying J2EE Application on OC4J

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s