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

MOSC Banner

invalid objects after applied patch 9976844

edited Feb 17, 2013 5:40AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered

after applied patch 9976844
customer got the following invalid object

Invalid object  MTL_MATERIAL_TRANSACTION_AUP  

SQL> alter procedure MTL_MATERIAL_TRANSACTION_AUP compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE MTL_MATERIAL_TRANSACTION_AUP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
416/1    PL/SQL: SQL Statement ignored
419/16   PL/SQL: ORA-00932: inconsistent datatypes: expected DATE got
       NUMBER

990/1    PL/SQL: SQL Statement ignored
992/16   PL/SQL: ORA-00932: inconsistent datatypes: expected DATE got
       NUMBER

ERROR
-----------------------

Invalid object  MTL_MATERIAL_TRANSACTION_AUP  


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