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;
Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY APPS.AD_ZD_PREP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
308/6 PL/SQL: Statement ignored
308/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared
670/4 PL/SQL: Statement ignored
670/4 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared
753/6 PL/SQL: Statement ignored
753/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared
LINE/COL ERROR
-------- -----------------------------------------------------------------
1152/4 PL/SQL: Statement ignored
1152/17 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared
Read more...