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

MOSC Banner

After applying project management patches PJI_FM_PLAN_EXTR,PA_DATAFIXES_UTIL package body became inv

edited Jul 18, 2013 8:09PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 commentsAnswered
 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
Tagged:

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