AD_ZD_ADOP Complie PACKAGE BODY

 

Solution:

Check the status of the object APPS.AD_ZD_ADOP

SQL> select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like'%ADOP%';

OWNER OBJECT_NAME OBJECT_TYPE
------ ----------- -----------
APPS AD_ZD_ADOP PACKAGE BODY

Try to compile the package.

SQL> ALTER PACKAGE AD_ZD_ADOP COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2686/3 PL/SQL: Statement ignored
2686/7 PLS-00201: identifier 'SYS.DBMS_METADATA_UTIL' must be declared
==================

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

SQL> show error
No errors.

Verify the Status of APPS.AD_ZD_ADOP package is valid.