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

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

  • January 8, 2016 | 16 views
  • Comments