Oracle EBS R12 - Steps and Issues/Resolutions during R12.1.1 to R12.1.3 Upgration

This essay is based on Oracle Linux 5.7 x64 and Oracle E-Business suite R12.1.1 x64

0.
Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)
admsi.pl -patch_top="`pwd`" -appspass=apps -cli

1.
Document 761570.1
add _disable_fast_validate=TRUE

2.
--enable maintenance
create table invalids_b_9239089 as select * from dba_objects where status='INVALID';
Required Code levels
R12.AD.B.delta.3
(R12.AD.B.DELTA.3, Patch 9239089) (Doc ID 1077769.1)
create table invalids_a_9239089 as select * from dba_objects where status='INVALID';
select bug_number,last_update_date from ad_bugs where bug_number = 9239089;
select object_name,object_type,status from invalids_a_9239089 where object_id not in (select object_id from invalids_b_9239089);

3.
create table invalids_b_9239090 as select * from dba_objects where status='INVALID';
Doc.DI 1080973.1
Patch 9239090
create table invalids_a_9239090 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9239090 where object_id not in (select object_id from invalids_b_9239090);
select object_name,object_type,status from dba_objects where object_id not in (select object_id from invalids_b_9239090);

=================================================
Doc ID 1303269.1
During the relink phase of the installation of EBS Release 12 (12.1.1) on SLES
10 or Oracle Linux/RHEL 5.4 (Update 4 or higher), failures will result while
relinking the Advanced Supply Chain Planning (ASCP) executables MSO, MSC, MSR
and FEM.

 To fix this problem, users are required to replace the following line under
the Linux section of the $AD_TOP/bin/adrelinknew.sh:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

with

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh
-Wl,--noinhibit-exec'

=================================================
adpatch.log
...
The following Oracle Reports objects did not generate successfully:

au      plsql   FABAL.pll
au      plsql   FARSV.pll
au      plsql   fadolif.pll
...
-------------------------------------------------
adwork001.log
Generating Oracle Reports files...


Generating report "FASUOPHI.rdf" with command:

/u01/apps/tech_st/10.1.2/bin/rwconverter userid=APPS/***** source=/u01/apps/apps
_st/appl/fa/12.0.0/reports/US/FASUOPHI.rdf dest=/u01/apps/apps_st/appl/admin/PRO
D/out/tmp001.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all
=yes
/u01/apps/tech_st/10.1.2/bin/rwconverter: error while loading shared libraries:
libXm.so.2: cannot open shared object file: No such file or directory

ERROR [code=127] generating report "FASUOPHI.rdf" from input file
/u01/apps/apps_st/appl/fa/12.0.0/reports/US/FASUOPHI.rdf


Generated    0 files successfully.
Generated    0 files with non-fatal warnings.
Generated    1 files with fatal errors.

adrepgen is exiting with status 1
...
rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm

=================================================
Invalid FFP Objects (Doc ID 1331911.1)

Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal)
(Doc ID 145837.1)
java oracle.apps.per.DataInstall apps apps thin oel57vis.example.com:1521:VIS
cd  $PER_TOP/patch/115/driver
adpatch hrglobal.drv

How To Compile Oracle Fast Formulas (Doc ID 155737.1)
$FF_TOP/bin/FFXBCP apps/apps 0 Y %% %%

=================================================

4.
create table invalids_b_9239095 as select * from dba_objects where status='INVALID';
Patch 9239095
create table invalids_a_9239095 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9239095 where object_id not in (select object_id from invalids_b_9239095);

5.
create table invalids_b_9817770 as select * from dba_objects where status='INVALID';
Patch 9817770
create table invalids_a_9817770 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9817770 where object_id not in (select object_id from invalids_b_9817770);

create table invalids_b_9966055 as select * from dba_objects where status='INVALID';
Patch 9966055
create table invalids_a_9966055 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9966055 where object_id not in (select object_id from invalids_b_9966055);

6.
. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env
Run AutoConfig on the APPL_TOP
adautocfg.sh

Run the admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.
perl <AD_TOP>/bin/admkappsutil.pl
perl $AD_TOP/bin/admkappsutil.pl

cd <RDBMS ORACLE_HOME>
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env

cd <ORACLE_HOME>
unzip -o appsutil.zip

perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

7.
remove add _disable_fast_validate=TRUE
--disable maintenance


Reference:

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)