Collections Refresh Snapshot Thread Errors Out With ORA-08002: sequence MRP_AP_REFRESH_S.CURRVAL (Doc ID 1388071.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 17-May-2014***

Goal

APS Collections Refresh Snapshot Thread errors out even after applying the solution from documents
'Data Collection Completes With ORA-12008: Error In Materialized View Refresh Path [Doc ID 1284534.1]'
and
'ORA-08002: Sequence MRP_AP_REFRESH_S.CURRVAL Is Not Yet Defined In This Session [Doc ID 1291864.1]'.  

This is after running the db upgrade from 11.1.0.7.0 to 11.2.0.3.0 in a development instance -

Log file shows:


ORACLE error 12008 in FDPSTP

Cause: FDPSTP failed due to ORA-12008: error in materialized view refresh path
ORA-08002: sequence MRP_AP_REFRESH_S.CURRVAL is not yet defined in this session
ORA-06512: at "APPS.MRP_SN_ODR_LINES_T2", line 7
ORA-04088: error
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
14-DEC 14:44:56 : single refresh, fast
14-DEC 14:44:56 : Error in refresh snapshot program : ORA-12008: error in materialized view refresh
path
ORA-08002: sequence MRP_AP_REFRESH_S.CURRVAL is not yet defined in this session
ORA-06512: at "APPS.MRP_SN_ODR_LINES_T2", line 7
ORA-04088: error during execution of trigger 'APPS.MRP_SN_ODR_LINES_T2'


Solution

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