Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Upgrade To EBS 12.2.4 Package Body "APPS.AD_ZD_ADOP" Has Errors And Cannot Compile Or Adop

edited Aug 20, 2021 10:19AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi All,

Facing this issue tried to compile manually and with scripts but issue remains as same. Followed 2030727.1

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @ADZDADOPB.pls

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY AD_ZD_ADOP:

LINE/COL ERROR

-------- -----------------------------------------------------------------

547/13   PL/SQL: SQL Statement ignored

549/86   PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier

553/13   PL/SQL: SQL Statement ignored

555/86   PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier

563/12   PL/SQL: SQL Statement ignored

566/18   PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier

575/9    PL/SQL: SQL Statement ignored

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center