Upgrade of Oracle Applications Version R12.1.1 to R12.1.3

Upgrade of Oracle Applications Version R12.1.1 to R12.1.3

After Installation of Oracle Applications R12.1.1,I have upgraded to R12.1.3 Successfully in my Servers.
The following patches are required and download from the Oracle Support as per their environment.
In this Note I have added some more patches for avoiding the feature errors and for avoiding  invalid objects.
Before going to proceed please check the metal ink Note Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1].



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 Ooracle Applications R12.1.1 to R12.1.3.


Step1: Run adadmin and put Maintenance Mode


Step2: 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 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>


Step3: Apply R12.AD.B_R12_GENERIC.zip Patch 10349415


Step4: Apply Oracle E-Business Suite Release 12.1.3 Patch 9239090


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


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


Step7: 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].)


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.



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


Step9:. Run adpreclone.pl on the database tier and the application tier


    perl adpreclone.pl dbTier
    perl adpreclone.pl appsTier


Step10: 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