Adop erros : APPS.AD_ZD_ADOP became invalid

Error :

This post is about one of the error i encountered while applying txk patch. This error is due to AD_ZD_ADOP package became invalid due to one of the opatch which applied this morning.

Due to invalid package i was unable to perform any operation in adop.

bash-3.2$ adop phase=apply patches=25828573 hotpatch=yes abandon=no restart=yes flags=autoskip

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /a01/appsclone/CLONE/fs2/inst/apps/CLONE_ahqtest/appl/admin/CLONE_ahqtest.xml
    Patch edition context: /a01/appsclone/CLONE/fs1/inst/apps/CLONE_ahqtest/appl/admin/CLONE_ahqtest.xml
    Patch file system free space: 329.79 GB

Validating system setup.

 Statement Handler Error Code: 4063
 Statement Handler Error Message: ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
 Reference of statement-handler is valid, not attempting database reconnect.
 Failed to execute SQL statement:
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
 Error Message:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)    [UNEXPECTED]Error determining whether this is a multi-node instance

 Statement Handler Error Code: 4063
 Statement Handler Error Message: ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
 Reference of statement-handler is valid, not attempting database reconnect.
 Failed to execute SQL statement:
  select ad_zd_adop.validate_session_id('') from dual

 Error Message:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)

[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)

i queried dba_objects and confirmed the below. 

select object_name,object_type,owner,status from dba_objects where status='INVALID';

OBJECT_NAME          OWNER                          STATUS  OBJECT_TYPE

-------------------- ------------------------------ ------- -------------------

AD_ZD_ADOP           APPS                           INVALID PACKAGE BODY

FND_DIAGNOSTICS      APPS                           INVALID PACKAGE BODY

XX_AR_MASTER_DATA_DE APPS                           INVALID PACKAGE BODY

I ran utlrp and compile apps schema option through adadmin but it dint fix the issue. 

But the below did.

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> commit;

Commit complete.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

Query once again dba_objects and confirm the package became valid. Then after i was able to run adop. 

Thanks!