Refresh Materialized Views Program Is Failing For MSC_ATP_PLAN_SN With ORA-12008, Then ORA-08103: object no longer exists (Doc ID 1512927.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Oracle Global Order Promising - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Refresh Materialized Views for MSC_ATP_PLAN_SN is failing at the end of the plan run.  Customer has MSCTATPB.pls 120.2.12000000.5 - this version comes from a fix done in <bug 12926041>.

Log file shows

MSCREFMV module: Refresh Materialized Views
+---------------------------------------------------------------------------+

Current system time is 10-DEC-2012 10:16:12

+---------------------------------------------------------------------------+

**Starts**10-DEC-2012 10:16:12
**Ends**10-DEC-2012 10:17:10
ORA-12008: error in materialized view refresh path
ORA-08103: object no longer exists
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Begin REFRESH_MAT_VIEWS
Refreshing  MSC_ATP_PLAN_SN
ORA-12008: error in materialized view refresh path
ORA-08103: object no longer exists
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

 

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