My Oracle Support Banner

APS Collections Refresh Snapshot Thread (MSCCLRFS) Is Failing With ORA-23401 On WIP_WLINES_SN (Doc ID 1960987.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


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

08-JAN 18:06:50 : Database Version:
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

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


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

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