My Oracle Support Banner

Error In Request MSCINVSN - Snapshot Creation On MTL_DEMAND Failed : ORA-00942: Table Or View Does Not Exist (Doc ID 2873899.1)

Last updated on JUNE 01, 2022

Applies to:

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

Symptoms

After upgrade from R12.2.4 to R12.2.10 - the Refresh Collection Snapshot processes are completing in error and see error in child request - MSCINVSN

ERROR at line 1:
ORA-20001: MSCINVSN: ORA-20001: Snapshot Creation on MTL_DEMAND failed :
ORA-20001: Snapshot Creation on MTL_DEMAND failed : ORA-00942: table or view does not exist


Changes

Upgraded from R12.2.4 to R12.2.10 - Error can occur on 12.2.6 and above
MSC_COLLECTED_ORGS exists in 12.1 and 11i releases, but was not introduced in 12.2 until 12.2.6

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
Changes
Cause
Solution


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