Patch 10338643: R12.ONT.B - Caused Multiple Invalid Objects
After applying patch 10338643 there are multiple invalid objects created that the DBAs cannot resolve.
These
invalids are stopping the Order Management application from working
correctly and so errors are occurring when sales order lines are being
entered.
The Appscheck output shows the following invalids objects
ERROR
-----------------------
Errors for PACKAGE BODY OE_DEFAULT_LINE_PATTR
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
Errors for PACKAGE BODY OE_DEFAULT_LOT_SERIAL
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
Errors for PACKAGE BODY OE_MASS_CHANGE_PVT
PL/SQL: ORA-22905: cannot access rows from a non-nested table item
PL/SQL: SQL Statement ignored