ORA-08002: Sequence MRP_AP_REFRESH_S.CURRVAL Is Not Yet Defined In This Session

(Doc ID 1291864.1)

Last updated on DECEMBER 18, 2017

Applies to:

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

Symptoms

Using Advanced Supply Chain Planning / Standard Data Collection

When attempting to perform a programatic snapshot refresh via the backed using SQL code like

BEGIN dbms_mview.refresh('INV.MTL_SUPPLY_SN','C'); END;

the following error occurs.

ERROR
-----------------------
ERROR at line 1:
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_SUPPLY_T1", line 33
ORA-04088: error during execution of trigger 'APPS.MRP_SN_SUPPLY_T1'
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2558
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2771
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2740
ORA-06512: at line 1

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Start a SQL session as the APPS user
2. BEGIN dbms_mview.refresh('INV.MTL_SUPPLY_SN','C'); END;
3. Observe the error noted

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