My Oracle Support Banner

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

AutoPatch error:
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

Errors for PACKAGE BODY AD_ZD_ADOP:
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.