Running AutoConfig generates ORA-04063: Package Body "APPS.AD_ZD_ADOP" Has Errors (Doc ID 2175698.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.2 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2 version, AutoConfig

1. Receiving Errors while running AutoConfig as seen below.

2. Additionally, See the following errors for an invalid APPS.AD_ZD_ADOP object:

SQL> alter package APPS.AD_ZD_ADOP compile body;
Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2686/3 PL/SQL: Statement ignored
2686/7 PLS-00201: identifier 'SYS.DBMS_METADATA_UTIL' must be declared

 

ERROR
-----------------------
Script Name : txkGenADOPWrapper.pl
Script Version : 120.0.12020000.3
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/r11/app/FLRPRD/R12apps/fs1/inst/apps/FLRTEST_dbfinsfnyp01/admin/install/txkGenADOPWrapper.pl)
TIME : Mon Aug 22 18:15:08 2016
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 22 18:15:08 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type('dbfinsfnyp01') FROM DUAL
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

STACK TRACE
at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
TXK::Error::abort('TXK::Error', 'HASH(0x10069c0f0)') called at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::SQLPLUS=HASH(0x100f70020)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::SQLPLUS=HASH(0x100f70020)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832
TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x100f70020)', 0) called at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234
TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x100f70020)', 'HASH(0x101b6d968)') called at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618
TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x100f70338)', 'SELECT ad_zd_adop.get_node_type(\'dbfinsfnyp01\') FROM DUAL') called at /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573
TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x100f70338)', 'SELECT ad_zd_adop.get_node_type(\'dbfinsfnyp01\') FROM DUAL') called at /r11/app/FLRPRD/R12apps/fs1/inst/apps/FLRTEST_dbfinsfnyp01/admin/install/txkGenADOPWrapper.pl line 503
main::getNodeType() called at /r11/app/FLRPRD/R12apps/fs1/inst/apps/FLRTEST_dbfinsfnyp01/admin/install/txkGenADOPWrapper.pl line 199
eval {...} called at /r11/app/FLRPRD/R12apps/fs1/inst/apps/FLRTEST_dbfinsfnyp01/admin/install/txkGenADOPWrapper.pl line 140
)
ERRORCODE = 1 ERRORCODE_END
:
:
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /r11/app/FLRPRD/R12apps/fs1/FMW_Home/webtier/perl/bin/perl -I /r11/app/FLRPRD/R12apps/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /r11/app/FLRPRD/R12apps/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /r11/app/FLRPRD/R12apps/fs1/EBSapps/appl/au/12.0.0/perl -I /r11/app/FLRPRD/R12apps/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /r11/app/FLRPRD/R12apps/fs1/inst/apps/FLRTEST_dbfinsfnyp01/admin/install
txkGenADOPWrapper.pl INSTE8_APPLY 1

AutoConfig is exiting with status 1
AutoConfig execution completed on Mon Aug 22 18:15:48 2016


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Trying to run AutoConfig

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms