Oracle Applications Upgrade from R12.1.1 to R12.1.3

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

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.

Instructions For Applying Patch 9239089

Execute the following command to generate your instance specific installation

instructions

1.      Source the Applications environment file

2.      Run the Patch Application Assistant by entering "admsi.pl".

You must shut down all Application tier services before performing the tasks in this section.

Instructions for running AD Grants

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

  Usage:

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

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

     $ORACLE_HOME/appsutil/admin.

     Or, copy adgrants_nt.sql (Windows) 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 schema name>

Apply The Patch

Apply patch

This patch contains the following unified driver file to be applied with

AutoPatch:

    u9239089.drv (This is the unified driver).

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

Instructions For Applying Patch 9239090

Execute the following command to generate your instance specific installation

instructions

1.      Source the Applications environment file

2.      Run the Patch Application Assistant by entering "admsi.pl".

You must shut down all Application tier services before performing the tasks in this section.

Instructions for running AD Grants

Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.

  Usage:

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

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

     $ORACLE_HOME/appsutil/admin.

     Or, copy adgrants_nt.sql (Windows) 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 schema name>

Apply The Patch

Apply patch

This patch contains the following unified driver file to be applied with

AutoPatch:

    u9239089.drv (This is the unified driver)

3)Use AutoPatch to apply the latest consolidated online help Patch 9239095

Post-Update Steps

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

o    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].)
1. 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 <INST_TOP>/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>.

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