My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

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

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

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
Goal
Solution
References


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