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:

p9239089_R12.AD.B_R12_LINUX.zip
p10349415_R12.AD.B_R12_GENERIC.zip (Optional)
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
p9239095_R12_GENERIC.zip
p9822544_R12.MSC.B_R12_GENERIC.zip(Optional)

Post update patches are :

p9966055_R12.FND.B_R12_GENERIC.zip
p9817770_R12.ATG_PF.B_R12_LINUX.zip

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.

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>

Step 3: Apply R12.AD.B_R12_GENERIC.zip 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 admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.

perl <AD_TOP>/bin/admkappsutil.pl

@Database Tier:

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>.

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

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

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


No comments: