Issue:
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/EBSSMK/fs1/FMW_Home/webtier/perl/bin/perl -I /u01/EBSSMK/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/EBSSMK/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/EBSSMK/fs1/EBSapps/appl/au/12.0.0/perl -I /u01/EBSSMK/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u01/EBSSMK/fs1/inst/apps/EBSSMK_grcldm/admin/install
txkGenADOPWrapper.pl INSTE8_APPLY 1
Cause:
The SYS.DBMS_METADATA_UTIL object needs to be recompiled first before the APPS.AD_ZD_ADOP object can become valid.
Fix:
1. Check the status of the object APPS.AD_ZD_ADOP
$ sqlplus "/as sysdba"
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
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.
