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 NOVEMBER 10, 2016

Applies to:

Oracle Applications Manager - Version 12.2 to 12.2.4 [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.AD_ZD_ADOP" has errors

2. SQL> show user
USER is "APPS"

3. 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

4. SQL> alter package AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

5. 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.


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