INvalid objects after 12.1.3 upgrade
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
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:
0