DBA Arena

Symptoms:

On Oracle Applications 12.2 version, online enablement patch 13543062 fails with:


begin
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_PREP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
ORA-06512: at line 4

 
Try to compile the package:

SQL> alter package apps.AD_ZD_PREP compile body;

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


Solution:


cd $ORACLE_HOME
sqlplus / as sysdba

alter session set current_schema=SYS;
@?/rdbms/admin/dbmsobj.sql
@?/rdbms/admin/dbmsxdbschmig.sql
@?/rdbms/admin/prvtxdbschmig.plb


Run adgrants.sql from patch 22200487 (EBUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT)
 
Copy adgrants.sql from patch directory to $ORACLE_HOME/appsutil/admin


$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

 
Try to compile the package again.

SQL> alter package apps.AD_ZD_PREP compile body;

Package body altered.
 
SQL> show error
No errors.

 

Check the status of all the AD_ZD objects:
 

SQL> col OWNER for a12;
col OBJECT_NAME for a25;
col STATUS for a15;
set pages 500;
select owner,object_name,status from dba_objects where object_name like 'AD_ZD%';