RPM_STAGE_CLEARANCE TABLE

We are trying to upload clearance in bulk. We are populating rpm_stage_clearance table with under mentioned query. And after running the batch "InjectorPriceEventBatch" I cant see any record getting created in rpm_clearance table.

 

Query to insert data into rpm_stage_clearance is 

 

insert into rpm_stage_clearance(

RPM_STAGE_CLEARANCE_ID,

REASON_CODE,

ITEM,

DIFF_ID,

ZONE_ID,

ZONE_NODE_TYPE,

EFFECTIVE_DATE,

OUT_OF_STOCK_DATE,

CHANGE_TYPE,

CHANGE_AMOUNT,

AUTO_APPROVE_IND,

STATUS

)

Select rpm_stage_clearance_seq.nextval,

24,

'100938581',

'0086',

1,

1,

GET_VDATE+1,

GET_VDATE+365,

2,

99,

0,

'N'

from dual;

Please guide me if I am using correct query or not and if not then please share one.