After applying project management patches PJI_FM_PLAN_EXTR,PA_DATAFIXES_UTIL package body became inv
Hi Sumedh,
Welcome to patching community !!!
Issue: After applying project management patches PJI_FM_PLAN_EXTR,PA_DATAFIXES_UTIL package body became invalid.
Please find error below after compile the object :
SQL> alter package PJI_FM_PLAN_EXTR compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PJI_FM_PLAN_EXTR:
LINE/COL ERROR
-------- -----------------------------------------------------------------
315/1 PL/SQL: SQL Statement ignored
348/7 PL/SQL: ORA-00942: table or view does not exist
390/1 PL/SQL: SQL Statement ignored
428/17 PL/SQL: ORA-00904: "WORKER_ID": invalid identifier
504/1 PL/SQL: SQL Statement ignored
633/25 PL/SQL: ORA-00904: "PJI_RM_SUM_MAIN"."G_NULL": invalid identifier
SQL> alter package PJI_FM_PLAN_EXTR compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PJI_FM_PLAN_EXTR:
LINE/COL ERROR
-------- -----------------------------------------------------------------
315/1 PL/SQL: SQL Statement ignored
348/7 PL/SQL: ORA-00942: table or view does not exist
390/1 PL/SQL: SQL Statement ignored
428/17 PL/SQL: ORA-00904: "WORKER_ID": invalid identifier
504/1 PL/SQL: SQL Statement ignored
633/25 PL/SQL: ORA-00904: "PJI_RM_SUM_MAIN"."G_NULL": invalid identifier
Tagged:
0