ORA-08002 sequence MRP_AP_REFRESH_S.CURRVAL is not yet defined in this session
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
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
0