Invalid objects IBW_OE_PVT after 12.2.4 upgrade
invalid objects after 12.2.4 upgrade
SQL> select object_name,object_type,owner from dba_objects where status='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE OWNER
------------------- ------------------------------
IBW_OE_PVT PACKAGE BODY APPS
SQL> alter package IBW_OE_PVT compile body;
Warning: Package Body altered with compilation errors.
SQL> show error;
Errors for PACKAGE BODY IBW_OE_PVT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
65/1 PL/SQL: SQL Statement ignored
66/6 PL/SQL: ORA-04063: view "APPS.JTF_PF_WA_INFO_VL" has errors
259/1 PL/SQL: ORA-04063: view "APPS.JTF_PF_WA_INFO_VL" has errors
259/1 PL/SQL: SQL Statement ignored
862/1 PL/SQL: SQL Statement ignored