DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Friday, January 8, 2016

UPGRADE FROM R12.1.1 to R12.1.3

APPS Upgrade

Required patches: (Optional)

Post update patches are :

The following information will provide upgradation process for Oracle Applications R12.1.1 to R12.1.3.

Step 1: Run adadmin and put Maintenance Mode

Step 2: Apply Prerequisite R12.AD.B.DELTA.3 Patch 9239089
Do the following Tasks before going to apply the Patch R12.AD.B.DELTA.3 Patch 9239089
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profile objects.


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:

$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>

Step 3: Apply Patch 10349415

Step 4: Apply Oracle E-Business Suite Release 12.1.3 Patch 9239090

Step 5:. Apply Oracle E-Business Suite Online Help for 12.1.3 Release Update Pack patch 9239095

Step 6:.Apply Patch 9822544 for Advanced Supply Chain Planning. (Optional).This patch fixes the issue of collecting resource requirements of OPM batches WIP warehouse does not belong to resource warehouse.

Step 7: Apply post Update Patches:

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

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

[notice]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[/notice]

Step 8: Run Application and Database Environment files.

@Application Tier:
·         Run AutoConfig on the APPL_TOP.

·         Run the utility to create the file in the <INST_TOP>/admin/out directory.

perl <AD_TOP>/bin/

@Database Tier:

Copy or FTP the file to the <RDBMS ORACLE_HOME>. Uncompress under the <RDBMS ORACLE_HOME>.
·         cd <ORACLE_HOME>
·         unzip -o
·         Run AutoConfig on the <RDBMS ORACLE_HOME>.

Step 9:. Run on the database tier and the application tier
·         perl dbTier
·         perl appsTier

Step 10: Disable Maintenance Mode using adadmin and check the version using following sql statement.

SQL> select release_name from fnd_product_groups;

No comments: