My Oracle Support Banner

Create INV Snapshots Log File Messages - ORA-00904: "MTRL"."OWNING_TP_TYPE": invalid identifier AND ORA-12000: a materialized view log already exists on table 'MTL_RELATED_ITEMS' (Doc ID 3074709.1)

Last updated on FEBRUARY 28, 2025

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When profile MSC: Source Setup Required - Yes

Then when request Refresh Collection Snapshots is launched, it will launch child requests to create snapshots.
One of those requests is Create INV Snapshots

Log files has messages as follows:

 

MSCINVSN: Create INV Snapshots
.....
08-FEB 14:44:41 : Snapshot Log on MTL_ITEM_CATEGORIES already exists...
ORA-12000: a materialized view log already exists on table 'MTL_RELATED_ITEMS' 

08-FEB 14:58:32 : Creating Snapshot for MTL_TXN_REQUEST_LINES ...
08-FEB 14:58:32 : ORA-00904: "MTRL"."OWNING_TP_TYPE": invalid identifier

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.