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 SEPTEMBER 25, 2024
Applies to:
Oracle Applications DBA - Version 12.2 and laterInformation 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_user>/<apps_pwd>
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>.
Changes
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 |
Changes |
Cause |
Solution |
References |