My Oracle Support Banner

Refresh Snapshot Completes Error - ORA-12008 OR ORA-12048 & KEY ERROR -- ORA-01031 (Doc ID 1924473.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information 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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.