Refresh Snapshot Completes Error - ORA-12008 OR ORA-12048 & KEY ERROR -- ORA-01031
(Doc ID 1924473.1)
Last updated on AUGUST 24, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10 and laterInformation in this document applies to any platform.
MSRFWOR
MSCCLRFS
Symptoms
In 11.5.10, 12.1.x and 12.2.x running Refresh Snapshots
Which is 12.1 and 12.2 can spawn child program MSCCLRFS module: APS Collections Refresh Snapshot Thread,
the following error occurs for varying individual collections snapshots in either MSRFWOR module: Refresh Collection Snapshots OR MSCCLRFS module: APS Collections Refresh Snapshot Thread,
ERROR
-----------------------
Error : ORA-12008: error in materialized view refresh path
OR
ORA-12048: error encountered while refreshing materialized view [SNAPSHOT NAME]
THEN SEE KEY ERROR IN LOG
ORA-01031: insufficient privileges
EXMAPLES:
ORA-12048: error encountered while refreshing materialized view "APPS"."OE_ODR_LINES_SN"
ORA-01031: insufficient privileges
Error : ORA-12008: error in materialized view refresh path
ORA-01031: insufficient privileges Error refreshing individual snapshot : APPS.BOM_OPR_RESS_SN
-- Steps To Reproduce:
Customer states the issue can be reproduced at will at customer site with the following steps:
1. (R) Advanced Supply Chain Planner
2. (N) Collections / Oracle Systems / Standard Collection OR Launch ATP Data Collections from Order Management
3. Observe the noted error for one or more of the snapshots
This is most likely to happen on snapshots with high volumes, but the complete list is
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 |
References |