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

Last updated on JUNE 28, 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms