Error while applying the patches on application Tier (Upgrading from 12.2.0 to 12.2.7)

Jul 9, 2019 4:05AM

SQL> alter package apps.ad_zd_adop compile body;

Warning: Package Body altered with compilation errors.

SQL> show error;

Errors for PACKAGE BODY APPS.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

577/121 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier

617/9 PL/SQL: SQL Statement ignored

619/123 PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier

871/1 PL/SQL: SQL Statement ignored

LINE/COL ERROR

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