Pre 12.1.3 fixes and Check
1.Check wether CS_KB_F_CTX_PKG PACKAGE exist
select owner,object_name,object_type,last_ddl_time,status from dba_objects
where object_name like upper('%cs_kb_f_ctx_pkg%');
2. Run the following sql to create the missing objects
sqlplus apps/apps @$CS_TOP/patch/115/sql/cskfctxs.pls APPS
sqlplus apps/apps @$CS_TOP/patch/115/sql/cskfctxb.pls APPS
3. Then verify the objects have been created
select owner,object_name,object_type,last_ddl_time,status from dba_objects
where object_name like upper('%cs_kb_f_ctx_pkg%');
####################NOTE ID 603633.1##############################
2. Patch 9239090 will fail at
"APPS.AP_ACCTG_DATA_FIX_PKG"
ORA-06512: at line 289
ORA-04063: package body "APPS.AP_ACCTG_DATA_FIX_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.AP_ACCTG_DATA_FIX_PKG"
When trying to recompile AP_ACCTG_DATA_FIX_PKG this fails:
SQL> alter package AP_ACCTG_DATA_FIX_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors;
Errors for PACKAGE BODY AP_ACCTG_DATA_FIX_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2300/3 PL/SQL: Item ignored
2300/76 PLS-00302: component 'PADDED_CONCATENATED_SEGMENTS' must be
declared
2658/6 PL/SQL: SQL Statement ignored
2670/44 PLS-00597: expression
'UNDO_JOURNAL_DTLS_L.PADDED_CONCATENATED_SEGMENTS_L' in the INTO
list is of wrong type
2681/10 PL/SQL: Statement ignored
2682/12 PLS-00306: wrong number or types of arguments in call to '||'
Solution
Verify the view definition and compare it to the actual view in the database.
If they do not match then recreate the view:
1. This view is created by $GL_TOP/patch/115/odf/glkfv.odf
2. Use the following syntax to check the view definition (enter correct passwords):
adodfcmp userid=apps/<appspw> mode=VIEWS odffile=$GL_TOP/patch/115/odf/glkfv.odf \
touser=apps/<appspw> priv_schema=system/<systempw> changedb=no logfile=/tmp/glkfv-check.log
3. Then check the log file /tmp/glkfv-check.log to see the definition output
4. If the view within the environment does NOT match the definition of the view, rerun the same command with "changedb=YES":
adodfcmp userid=apps/<appspw> mode=VIEWS
odffile=$GL_TOP/patch/115/odf/glkfv.odf \
touser=apps/<appspw> priv_schema=system/<systempw> changedb=yes logfile=/tmp/glkfv-change.log
5. Then recompile the package AP_ACCTG_DATA_FIX_PKG.
6. Once AP_ACCTG_DATA_FIX_PKG is compiled successfully, restart the patch.
##############################################NOTE 1292298.1###################################
In the 12.1.3 Patch directory modify the following files
Modify artax.odf to make index AR_LOCATION_RATES_U2 non unique
Modify csd.odf as per 372945.1
Modify csfvoi.odf to make index CSF_PHONETIC_VALUES_U3 non unique
Modify invirev.odf to make index MTL_ITEM_REVISIONS_TL_U2 non unique
Apply R12.1.3 Patch
1.Apply R12.AD.B.DELTA.3 Patch 9239089
a.Copy adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
From DB Server run
b. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>
c.Apply the patch using adpatch ###Time 15 Mins
2.Apply the 12.1.3 patch 9239090
a) Set INBOUND_CONNECT_TIMEOUT_<LISTENER_NAME> = 0 in listener.ora and
b) Set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora
c) Restart the DB and listener.
d)Apply patch using adpatch
3.Apply patch 9817770 using adpatch
4. Apply patch 9966055 using adpatch
5.Apply HR Legislative patch 11077701
6.Run DataInstall:
$ Command is: java oracle.apps.per.DataInstall apps <apps_pw> thin <oraung13>:<1551>:<IMGUPG3>
7.Apply the HR Global Driver located under $PER_TOP/patch/115/driver named as hrglobal.drv using adpatch
8.At this point:
1. Run adadmin for grants and synonyms à 4 à 2
2. Run adadmin to compile apps schema à 3 à 1
Post Upgrade to 12.1.3 Tasks and Patching
Apply Patch
12533942
Apply Patch
10040337
Apply Patch
9543619:R12.INV.B
Apply Patch
12345554
Apply Patch
10201039
Apply Patch
10149735
Apply Patch
9653541
Apply Patch
10050696
Apply Patch
9707056
Apply Patch
10374671
Apply Patch
10192008
Apply Patch
11900380
Apply Patch
9044638
Apply Patch
12846515
Apply Patch
9707155
Apply Patch
9940925
Apply Patch
12814343
Apply Patch
10252186
Apply Patch
13033940:R12.ZX.B