Upgrade To EBS 12.2.4 Package Body "APPS.AD_ZD_ADOP" Has Errors And Cannot Compile Or Adop
(Doc ID 2030727.1)
Last updated on JANUARY 22, 2024
Applies to:
Oracle Applications Manager - Version 12.2 to 12.2 [Release 12.2Cloud]Information in this document applies to any platform.
Symptoms
On Oracle Applications,
upgrading to release 12.2.4, package body "APPS.AD_ZD_ADOP" has the following errors and cannot compile or adop:
1. $ adop phase=apply patches=19197270 hotpatch=yes
ORA-04063: package body <APPS_SCHEMA>.AD_ZD_ADOP has errors
2. SQL> SELECT object_name, object_type FROM user_objects WHERE object_type IN ('PACKAGE', 'PACKAGE BODY') AND status = 'INVALID' ORDER BY object_type;
OBJECT_NAME OBJECT_TYPE
--------------- ---------------
AD_ZD_ADOP PACKAGE BODY
3. SQL> alter package AD_ZD_ADOP compile body;
Warning: Package Body altered with compilation errors.
4. SQL> show errors
LINE/COL ERROR
-------- -----------------------------------------------------------------
505/13 PL/SQL: SQL Statement ignored
507/86 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
511/13 PL/SQL: SQL Statement ignored
513/86 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
521/12 PL/SQL: SQL Statement ignored
524/18 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
533/9 PL/SQL: SQL Statement ignored
535/121 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
575/9 PL/SQL: SQL Statement ignored
577/123 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
1580/7 PL/SQL: SQL Statement ignored
1582/65 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier
The issue can be reproduced at will with the following steps:
1. Applying patch 19197270.
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 |