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...