Refresh Collection Snapshots Program Ending In Error. Cannot create snapshots
(Doc ID 2045883.1)
Last updated on APRIL 09, 2020
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
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
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).
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