12.2 E-Business Suite After Application Of R12.AD.C.DELTA.8 Patch 21841299 Package AD_ZD_ADOP Is Invalid Due To Missing Table ADOP_VALID_NODES

(Doc ID 2226512.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications DBA, Online Patching ADOP Utilities issues

 

 After applying <Patch 21841299>, package AD_ZD_ADOP is invalid.

The following steps were followed with no success:

1. Completed the steps in <Note 2030727.1> and <Note 2079481.1> and attempted to compile the package.

2. Attempted to compile all the objects using the utlrp, still the object is invalid.

3. The below errors were then confirmed again:

SQL> alter package AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL> sho error
Errors for PACKAGE BODY AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1558/3 PL/SQL: SQL Statement ignored
1560/24 PL/SQL: ORA-00942: table or view does not exist
2427/3 PL/SQL: SQL Statement ignored
2429/24 PL/SQL: ORA-00942: table or view does not exist
2486/13 PL/SQL: SQL Statement ignored
2486/35 PL/SQL: ORA-00942: table or view does not exist
2492/8 PL/SQL: Statement ignored
2492/23 PLS-00364: loop index variable 'REC' use is invalid
2494/8 PL/SQL: Statement ignored
2494/45 PLS-00364: loop index variable 'REC' use is invalid
2900/9 PL/SQL: SQL Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
2901/16 PL/SQL: ORA-00942: table or view does not exist
2907/9 PL/SQL: SQL Statement ignored
2911/30 PL/SQL: ORA-00942: table or view does not exist
2951/7 PL/SQL: Statement ignored
2951/37 PLS-00364: loop index variable 'HOSTNAME' use is invalid
2963/9 PL/SQL: Statement ignored
2963/42 PLS-00364: loop index variable 'AV_NODE_NAME' use is invalid
2967/11 PL/SQL: Statement ignored
2967/27 PLS-00364: loop index variable 'AV_NODE_NAME' use is invalid
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-bash-4.1$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jan 10 11:35:36 2017

ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_ADOP"
ORA-06512: at line 2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <Patch 21841299>.

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