Upgrading Oracle Application 11i to E-Business Suite R12

This post covers overview steps to upgrade Oracle Applications (E-Business Suite) 11i (11.5.8,11.5.9,11.5.10) to R12/12i (12.0.4).

Key points with regard to upgrade

- You can upgrade to R12/12i (12.0.4) ONLY from release 11.5.8, 11.5.9.X or 11.5.10.X (For any previous release like 11.5.7 , upgrade them to 11.5.10.2 first)
- You can upgrade database to version 10.2.X during upgrade (11.5.8, 11.5.9.X, 11.5.10.X) or BEFORE R12 upgrade (only for 11.5.9.X and 11.5.10.X)

Upgrade is broadly divided in to three steps

–Preupgrade Step (lay down file system for R12 using rapidwiz/RapidInstall)
–Upgrade Step (Upgrade database to 10gR2 (if not already upgraded), apply R12.AD.A on R12 APPL_TOP and apply 12.0.4 patch database portion only)
–Post Upgrade step (Run rapidwiz/RapidInstall one more time to configure and start services on R12).
A. Pre-Upgrade Process
1.Layout file system for R12 using rapidwiz with option as upgrade.
Run rapidwiz from R12 software >> Select option “Upgrade to Oracle Applications Release 12“ .

2.In Select Upgrade Action screen select “Create Upgrade File System”

Follow further screens and installer will install R12 file system (This step will NOT configure and start services in R12, It will only install R12 files)

Note There are other preupgrade steps as well like migrate backup, TUMS (optional), OATM, convert to multi org, gather stats and functional preupgrade steps

B. Upgrade Process2.Migrate database to 10gR2 - This step is required if you have not upgraded your database with 11i itself. Use ORACLE_HOME (10.2 on database tier) which came as part of R12 upgrade (Create Upgrade file system above in preupgrade step)

Also check following Metalink Notes

403339.1 - Oracle 10g R2 Database preperation Guidelines for Oracle E-Business Suite R12 Upgrade396009.1 - Database initialization parameters for Oracle apps R12

3. Put your Apps into database in to maintenance mode

4.Run adpatch 6604842 (on R12 appl_top, environment variable at this stage should point to R12 APPL_TOP and ORACLE_HOME in application tier should point to FORMS (10.1.2) in R12) to upgrade AD product of R12 to 12.0.4 (Patch 6604842 is available as R12.AD.A)

5. Run 12.0.4 patch 6394500(u6394500.drv ) which is under $AU_TOP/patch/115/driver (on R12/12.0.4 APPL_TOP).

Note You have to apply this patch on 12.0.4 APPL_TOP.

Apply this with nocopyportion and nogenerateportionas copy and generate portion is already available as part of R12 install done above in preupgarde step.
Apply/Upgrade to 12.0.4 using
adpatch options=nocopyportion,nogenerateportion

6. Disable maintenance mode

C. Post Upgrade ProcessDatabase and database listener should be up at this stage.

7. Run Rapid Install one more time to configure and start services on R12/12i.
Run rapidwiz one more timeSelect option “Upgrade to Oracle Applications Release 12“

In Select Upgrade Action screen select “Configure Upgraded Release 12 Instance” (This select is different from selection in Pre-Upgrade Step)

Change file name as shown in figure to your new $APPL_TOP/admin/$CONTEXT_NAME.xml (R12)
There are other finishing tasks which are out of scope of this post like backup, reset password, setup client machines (java plugin), printers, workflow notification mailer and various functional steps