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

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