adcfgclone.pl failed while running autoconfig with the error "ORA-04063: package body "APPS.AD_ZD_ADOP" has errors"

This document describes about the error while running autoconfig as part of adcfgclone.pl

Autoconfig failed with below error while running autoconfig as part of adcfgclone.

Error details:

[APPLY PHASE]

  AutoConfig could not successfully execute the following scripts:

    Directory: /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/perl/bin/perl -I /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/oracle/ERPGOLD/fs1/EBSapps/appl/au/12.0.0/perl -I /u01/oracle/ERPGOLD/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/oracle/ERPGOLD/fs1/inst/apps/ERPGOLD_erpgoldapp/admin/install

      txkGenADOPWrapper.pl    INSTE8_APPLY      

Found below error in autoconfig log file and package body "APPS.AD_ZD_ADOP" is invalid.

SQL> SELECT ad_zd_adop.get_node_type('erpgoldapp') FROM DUAL

ERROR at line 1:

ORA-04063: package body "APPS.AD_ZD_ADOP" has errors

Solution:

SQL> alter package apps.AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2682/3   PL/SQL: Statement ignored
2682/7   PLS-00201: id

SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> alter package apps.AD_ZD_ADOP compile body;

Package body altered.

SQL>

Reran the autoconfig. It should complete.

Thanks for going through the post.