Oracle Receivables Transaction Missing numbers

--Choose the Batch source specific to the Operating unit / Division

SELECT batch_source_id, org_id, name, a.* FROM ra_batch_sources_all  a where  org_id in (select ORGANIZATION_ID from Hr_operating_units where SET_OF_BOOKS_ID=2089) and STATUS='A'

select * from  RA_batch_sources_all
 where batch_source_id in ( 9096,  9106,9102,9113,9122)

SELECT 'alter sequence AR.'||seq.sequence_name||' nocache;' FROM
(SELECT
name bsname, org_id org,
'RA_TRX_NUMBER_'||BATCH_SOURCE_ID||'_'||org_id||'_S' seqname
FROM RA_batch_sources_all where org_id in (304) and  batch_source_id in (
9139)  ) src,
dba_sequences seq
WHERE src.seqname=seq.sequence_name -- Pass the Org_id  and Batch Source Id 
--AND seq.cache_size

--execute that output

COMMIT;


--Check the Sequence Cache cleared or not

SELECT sequence_owner, sequence_name, cache_size
FROM all_sequences
WHERE sequence_name LIKE 'RA_TRX_NUMBER_9139_304_S%';




--ALTER sequence RA_TRX_NUMBER_1146_1166_S increment BY 1 nocache;