My Oracle Support Banner

Create Snapshots Request Errors With ORA-20001: Snapshot Creation on OE_ORDER_LINES_ALL failed : ORA-23413: table "ONT"."OE_ORDER_LINES_ALL" does not have a materialized view log (Doc ID 2971804.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

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

Symptoms

When attempting to run the process: Refresh Collection Snapshots, the following error occurs.

ERROR

ERROR at line 1:
ORA-20001: MSCONTSN: ORA-20001: Snapshot Creation on OE_ORDER_LINES_ALL failed
ORA-20001: Snapshot Creation on OE_ORDER_LINES_ALL failed : ORA-23413: table "ONT"."OE_ORDER_LINES_ALL" does not have a materialized view log
ORA-06512: at line 367

The issue can be reproduced with the following steps:
1. Responsibility: Advanced Planning Administrator

2. Go to View -> Request -> Submit New Request

3. Process Name: Refresh Collection Snapshots

Parameter: <Select snapshot name> - The snapshot name in the above example: OE_ODR_LINES_SN

 

Changes

 

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
References


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