Upgrading R12.1.1 to 12.3.3

To apply Oracle E-Business Suite Release 12.1.3, follow these steps:

Download all the patches

p9239095_R12_GENERIC.zip

p9817770_R12.ATG_PF.B_R12_LINUX.zip

p9239089_R12.AD.B_R12_LINUX.zip

p9239090_R12_LINUX_1of6.zip

p9239090_R12_LINUX_2of6.zip

p9239090_R12_LINUX_3of6.zip

p9239090_R12_LINUX_4of6.zip

p9239090_R12_LINUX_5of6.zip

p9239090_R12_LINUX_6of6.zip

p9966055_R12.FND.B_R12_GENERIC.zip

Unzip the patches

9239089

9239090

9817770

9966055

9239095

a) Enable maintenance mode

b) Stop all application Services

1) Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089, before you complete any of the other steps in this section. Do not merge this patch with any other patch. R12.AD.B.Delta.3 must be applied separately.

-- Pre install steps

                                   1. Create $ORACLE_HOME/appsutil/admin on the database server.

                                        mkdir -p $ORACLE_HOME/appsutil/admin

                                  2. Copy adgrants.sql (UNIX) from this patch directory to

                                      $ORACLE_HOME/appsutil/admin.

                                  3. Set the environment to point to ORACLE_HOME on the database server.

                                  4. Use SQL*Plus to run the script:

                                      UNIX:

                                     $ sqlplus /nolog

                            SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
     Apply the Patch
     No Post Installation Steps.

 2)   Use AutoPatch to apply Oracle E-Business Suite Release 12.1.3 Patch 9239090 and follow the

        instructions in the patch readme file.

• Prereq patch - R12.AD.B.delta.3 (9239089)- already applied above.

 3)   Use AutoPatch to apply the latest consolidated online help Patch 9239095 and follow the instructions in

        the patch readme file.

Post-Update Steps:-

Apply post-install Oracle E-Business Suite Applications Technology patches. (Required)

Apply mandatory Patch 9817770 (9817770:R12.ATG_PF.B [POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH].)

Apply mandatory Patch 9966055 (9966055:R12.FND.B [TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED].)

Update database tier nodes with the Oracle E-Business Suite Release 12.1.3 code level.

After you have upgraded to Oracle E-Business Suite Release 12.1.3, perform the following post-update

 

Steps to update all database tier nodes with the code level, provided by Oracle E-Business Suite Release 12.1.3:

Application tier:
               • As the APPLMGR user, run the environment (UNIX) or the command (WINDOWS) file for the
                  current APPL_TOP.

                         UNIX
                         . ./$APPL_TOP/APPS CONTEXT_NAME.env

              • Run AutoConfig on the APPL_TOP.

              • Run the admkappsutil.pl utility to create the file appsutil.zip in the /admin/out 

                 directory.

                           perl $AD_TOP/bin/admkappsutil.pl

Database tier:
 

               • As the ORACLE user, run the environment (UNIX) or the command (WINDOWS) file for the current

                  ORACLE_HOME.

                UNIX
                     cd $RDBMS ORACLE_HOME
                     . ./$RDBMS ORACLE_HOME/CONTEXT_NAME.env

             • Copy or FTP the appsutil.zip file to the RDBMS ORACLE_HOME.

             • Uncompress appsutil.zip under the RDBMS ORACLE_HOME.

                   cd $ORACLE_HOME
                   unzip -o appsutil.zip

            • Run AutoConfig on the $RDBMS ORACLE_HOME.

                 perl $ORACLE_HOME/appsutil/bin/adbldxml.pl
                cd $ORACLE_HOME/appsutil/bin/
                sh adconfig.sh

Database tier and application tier:
                         • Re-run adpreclone.pl on the database tier and the application tier. Since updates included in
                            Oracle E-Business Suite Release 12.1.3 were applied to the system, adpreclone must be run
                            again to apply the updates to the clone directory structures that were used during cloning.
 

                                        perl adpreclone.pl dbTier
                                        perl adpreclone.pl appsTier

c) Disable Maintenance Mode

d) Start all Application Services

SQL> select release_name from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.1.3

***********************************************************************************

For instructions on applying Oracle E-Business Suite 12.1.3 Release Update Pack (12.1.3), features and other information, please refer to My Oracle Support Knowledge Document - 1080973.1

***********************************************************************************************