APS Collections Refresh Snapshot Thread (MSCCLRFS) Is Failing With ORA-23401 On WIP_WLINES_SN (Doc ID 1960987.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.

Symptoms

When attempting to run the Data Collections, the following error occurs in the APS Collections Refresh Snapshot Thread (MSCCLRFS)...

ERROR
-----------------------
08-JAN 18:06:50 : Database Version: 11.2.0.3.0
08-JAN 18:06:50 : single refresh, fast
08-JAN 18:06:50 : Error in refresh snapshot program : ORA-23401: materialized view "APPS"."WIP_WLINES_SN" does not exist

08-JAN 18:06:50 : Error refreshing individual snapshot : APPS.WIP_WLINES_SN
08-JAN 18:06:50 : Error : ORA-23401: materialized view "APPS"."WIP_WLINES_SN" does not exist

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Collections



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