ADOP ERROR with Following “package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)”

Problem:

[ERROR] Failed to execute SQL statement:
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
[ERROR] Error Message:
[ERROR] ORA-04063: package body “APPS.AD_ZD_ADOP” has errors (DBD ERROR: OCIStmtExecute)

Cause:

Package “APPS.AD_ZD_ADOP” is not valid due to the incorrect execution of the adgrants.sql script.

Solution :

Complie the package and re-run the adop session.

SQL> conn / as sysdba
Connected.

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> conn apps
Enter password:
Connected.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

Restart the adop phase