5
Dec

On Oracle Applications 12.2 version, Online Enablement patch fails on APPS.AD_ZD_PREP package

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...

Back to Top