Performance - EBS (MOSC)

MOSC Banner

ORA-08002 sequence MRP_AP_REFRESH_S.CURRVAL is not yet defined in this session

edited Nov 30, 2012 10:16PM in Performance - EBS (MOSC) 6 commentsAnswered
I am doing a fast refresh of a MV and getting the following error.
SQL> exec dbms_snapshot.refresh('BOM_INV_COMPS_SN','C');

BEGIN dbms_snapshot.refresh('BOM_INV_COMPS_SN','C'); END;

*
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_INV_COMPS_T1", line 4
ORA-04088: error during execution of trigger 'APPS.MRP_SN_INV_COMPS_T1'
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2545
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2751
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2720
ORA-06512: at line 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center