Table MTL_ONHAND_QUANTITIES does not exist..on ebs 12.1.3
We are on EBS 12.1.3DB - 11.2.0.3
INV 12.0.0 R12.INV.B.3
While running "Refresh Collection Snapshots" it runs the Concurrent request : "Create INV Snapshots" .
There although i see the request gets completed normal, but LOG FILE has FOLLOWING ERROR messages:
05-NOV 16:14:04 : Table MTL_ONHAND_QUANTITIES does not exist..
ORA-12000: a materialized view log already exists on table 'MTL_RELATED_ITEMS'
05-NOV 16:14:04 : Snapshot on MTL_MATERIAL_TRANSACTIONS_TEMP already exists...
05-NOV 16:14:04 : ORA-00904: "MTRL"."OWNING_TP_TYPE": invalid identifier
---------------------------------------------------------------------
Querying DBA_OBJECTS table i see the same is only present as VIEW:
APPS MTL_ONHAND_QUANTITIES 15241 VIEW 2/12/2011 6:12:17 AM
No TABLE Exists, Do you know why and what needs to be done ??
INV 12.0.0 R12.INV.B.3
While running "Refresh Collection Snapshots" it runs the Concurrent request : "Create INV Snapshots" .
There although i see the request gets completed normal, but LOG FILE has FOLLOWING ERROR messages:
05-NOV 16:14:04 : Table MTL_ONHAND_QUANTITIES does not exist..
ORA-12000: a materialized view log already exists on table 'MTL_RELATED_ITEMS'
05-NOV 16:14:04 : Snapshot on MTL_MATERIAL_TRANSACTIONS_TEMP already exists...
05-NOV 16:14:04 : ORA-00904: "MTRL"."OWNING_TP_TYPE": invalid identifier
---------------------------------------------------------------------
Querying DBA_OBJECTS table i see the same is only present as VIEW:
APPS MTL_ONHAND_QUANTITIES 15241 VIEW 2/12/2011 6:12:17 AM
No TABLE Exists, Do you know why and what needs to be done ??
0