Data Collection Completes With ORA-12008: Error In Materialized View Refresh Path (Doc ID 1284534.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2012***
***Checked for relevance on 18-Mar-2014***

Symptoms

After upgrading the database to 11.2.0.2, MSCCLRFS (APS Collections Refresh Snapshot Thread) fails with:

ORACLE error 12008 in FDPSTP

Cause: FDPSTP failed due to ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [21028], [19], [20], [0], [], [], [], [], [], [], [], []
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT",

11-JAN 13:20:48 : Error refreshing individual snapshot : APPS.MTL_ITEM_CATS_SN
11-JAN 13:20:48 : Error : ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [21028], [19], [20], [0], [], [], [], [], [], [], [], []

Changes

Upgrade the database to 11.2.0.2

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