Upgrade R12.1.3 to R12.2

[satish]

Dear Erman,

Application version and database version 11.2.0.4

We have completed running ugrade driver.We are about to apply online enablement patch. Before we apply this patch,we verified invalid object and we tried to compile which errored out.

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.

SQL> sho errors;
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
301/6    PL/SQL: Statement ignored
301/6    PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
         declared

467/3    PL/SQL: SQL Statement ignored
467/19   PL/SQL: ORA-00942: table or view does not exist
471/5    PL/SQL: SQL Statement ignored
471/21   PL/SQL: ORA-00942: table or view does not exist
491/5    PL/SQL: Statement ignored
491/5    PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared
505/5    PL/SQL: SQL Statement ignored
505/21   PL/SQL: ORA-00942: table or view does not exist
676/4    PL/SQL: Statement ignored
676/4    PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
         declared

758/6    PL/SQL: Statement ignored
758/6    PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
         declared

1124/4   PL/SQL: Statement ignored
1124/17  PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
         declared



We found note id APPS.AD_ZD_PREP Is Invalid, and Has Error "PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be declared" (Doc ID 1681051.1)

Since we are on R12.2.0,looks like it is not applicable.

Can you please help us.

Thanks,
Satish

[ErmanArslansOracleBlog]

That patch given in the MOS note -> "Patch 17693770: MERGE REQUEST ON TOP OF 11.2.0.3.0 FOR BUGS 17502060 17487358" is for 11.2.0.3.. But your db version is 11.2.0.4

However; if you have that (bugs given above) already resolved in your db, then you may try the following MOS note ->

Online Enablement Patch 13543062 Fails With ORA-04063 And ORA-06508 On APPS.AD_ZD_PREP (Doc ID 1944606.1)

You may also try running adgrants..

[satish]

Dear erman,

Thanks a lot for the reply.


Patch 17693770 is not applied and also as you said,it is not available for 11.2.0.4.
We have verified the bugs..one is applied and the other is not applied.

[oracrp@sssterpdev1 21249127]$ $ORACLE_HOME/OPatch/opatch  lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc|grep 17502060

[oracrp@sssterpdev1 21249127]$ $ORACLE_HOME/OPatch/opatch  lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc|grep 17487358
     17421340, 17487358
[oracrp@sssterpdev1 21249127]$


Can we just run post steps from the patch which you have suggested.

Thanks,
Satish