invalid objects after applied patch 9976844
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