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

MOSC Banner

INvalid objects after 12.1.3 upgrade

edited May 10, 2013 6:39AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 7 commentsAnswered
Hi,
here are some invalid objects(under APPS schema) we see after upgrade from 11.5.10.2 to 12.1.3. some we have resolved using metalink search

1)  JE_OECD_XML_PKG


SQL> alter package JE_OECD_XML_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY JE_OECD_XML_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
131/1    PL/SQL: SQL Statement ignored
384/20   PL/SQL: ORA-00904: "JH"."SET_OF_BOOKS_ID": invalid identifier
523/1    PL/SQL: SQL Statement ignored
557/13   PL/SQL: ORA-00904: "JH"."SET_OF_BOOKS_ID": invalid identifier
712/1    PL/SQL: SQL Statement ignored
733/13   PL/SQL: ORA-00904: "JH"."SET_OF_BOOKS_ID": 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