My Oracle Support Banner

Refresh Collection Snapshots Program Ending In Error. Cannot create snapshots (Doc ID 2045883.1)

Last updated on DECEMBER 05, 2024

Applies to:

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

Symptoms

 When we run Refresh Collection Snapshot program manually from source instance, Create INV Snapshots and Create OE Snapshots program ended in error

Because of this issue when we run standard collection from ASCP instance (destination instance) Planning Data Pull is also ending in error.

Error:  ORA-12015: cannot create a fast refresh materialized view from  a complex query

Changes

 Tried also the action plan:
 
1. Run Drop Snapshot request(on source instance) for OE_ODR_LINES_SN, MTL_SUPPLY_SN and MTL_SYS_ITEMS_SN;
 
2. drop the MLOG manually via SQL*PLUS with apps schema from source instance: .
 ------------------
DROP SNAPSHOT LOG ON ONT.OE_ORDER_LINES_ALL;
DROP SNAPSHOT LOG ON INV.MTL_SUPPLY_SN;
DROP SNAPSHOT LOG ON INV.MTL_SYSTEM_ITEMS_B;
 --------------------

3. Run Create Snapshot (on source instance) for OE_ODR_LINES_SN, MTL_SUPPLY_SN and MTL_SYS_ITEMS_SN;
  --again ORA-12015: cannot create a fast refresh materialized view from  a complex query-before next step

4. Run Data Collections with Complete Refresh(on planning instance).

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.