Forms and Reports Upgrade in Oracle Apps R12 (12.0.X) to 10.1.2.3

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

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 deploying formsapp.ear file to 10.1.3 ORACLE_HOME. Use txkrun.pl -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 oc4jadmin password 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 10.1.2.2.0 (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 10.1.2.2.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
success

__________

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

Fix

Open $ORACLE_HOME/bin/ emctl, emagentdeploy.pl, emdctl and change ORACLE_HOME to correct value

If you get error like
oracle.security.jazn.JAZNInitException: /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

1. Stop Middle Tier Services

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

3. Ensure that Inventory is pointing to right location

4.Install 10.1.2.3 (5983622 - This is latest Forms & Report Patchset) using runInstaller 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

References

* 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
* 821253.1 Forms And Reports Standalone Upgrade To 10.1.2.3 Fails on Relinking ins_reports.mk