Create Inv Snapshots ORA-20001 Error
(Doc ID 1355187.1)
Last updated on NOVEMBER 14, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Data Collections
When attempting to run Data Collections, the following error occurs in Create INV Snapshots
ERROR
-----------------------
ORA-20001: Snapshot Creation on MTL_RELATED_ITEMS failed : ORA-20000: Unable to analyze TABLE "APPS"."MTL_ITEM_RELATIONSHIPS_SN ", insufficient privileges or does not exist
STEPS
-----------------------
1. Advanced Planning Administrator Responsibility
2. Nav: Collections > Oracle Systems > Standard Collection
3. Notice Create INV Snapshots completes with error
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 |