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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.