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

MOSC Banner

Patch 10338643: R12.ONT.B - Caused Multiple Invalid Objects

edited May 31, 2012 6:50PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 comments

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

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