MRP_AP1_ONHAND_SUPPLIES_V view is invalid after 12.1.3 upgrade
12.1.3 upgrade - MRP_AP1_ONHAND_SUPPLIES_V view is invalid:SQL> alter view apps.MRP_AP1_ONHAND_SUPPLIES_V compile;
Warning: View altered with compilation errors.
SQL> select TEXT from dba_errors where NAME='MRP_AP1_ONHAND_SUPPLIES_V';
TEXT
------------------------------------------------------
ORA-00942: table or view does not exist
Warning: View altered with compilation errors.
SQL> select TEXT from dba_errors where NAME='MRP_AP1_ONHAND_SUPPLIES_V';
TEXT
------------------------------------------------------
ORA-00942: table or view does not exist
Tagged:
0