My Oracle Support Banner

Refresh Collection Snaphot In Error "APPS"."EAM_ACT_ASSOC_SN" does not exist (Doc ID 2025798.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Issue:
=========
While configuring the ASCP setup in a new instance~ during Standard Collections
-- Refresh Collection Snapshot is going in error when launched from ASCP .
We are able to run the RCS manually in source instance, however it goes in error only when launched from ASCP.

We have already tried setting up MSC: Source setup Required to "Yes" and running the RCS for the failing Snapshot individually. Below is the error message:

ERROR:
==========
29-JUN 03:49:34 : Error_Stack...
29-JUN 03:49:34 : ORA-23401: materialized view "APPS"."EAM_ACT_ASSOC_SN" does not exist

29-JUN 03:49:34 : Error_Backtrace...
29-JUN 03:49:34 : ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2994
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT", line 2941

29-JUN 03:49:34 : Error refreshing individual snapshot : APPS.EAM_ACT_ASSOC_SN
29-JUN 03:49:34 : Error : ORA-23401: materialized view "APPS"."EAM_ACT_ASSOC_SN" does not exist

Other Information-
--------------------------
-- When we launch the RCS for EAM_ACT_ASSOC_SN alone, it completed successfully.
-- We have also tried the steps as mentioned in ML Note 1445672.1, but no help.

Business Impact
---------------------------

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


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.