Running AutoConfig generates ORA-04063: Package Body "APPS.AD_ZD_ADOP" Has Errors
(Doc ID 2175698.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.2 to 12.2.5 [Release 12.2]Information in this document applies to any platform.
Symptoms
<SID>_<HOSTNAME>
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/<SID_HOSTNAME>/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('<HOSTNAME>') 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(\'<HOSTNAME>\') 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(\'<HOSTNAME>\') FROM DUAL') called at /r11/app/FLRPRD/R12apps/fs1/inst/apps/<SID_HOSTNAME>/admin/install/txkGenADOPWrapper.pl line 503
main::getNodeType() called at /r11/app/FLRPRD/R12apps/fs1/inst/apps/<SID_HOSTNAME>/admin/install/txkGenADOPWrapper.pl line 199
eval {...} called at /r11/app/FLRPRD/R12apps/fs1/inst/apps/<SID_HOSTNAME>/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/<SID_HOSTNAME>/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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |