How To Find AR Transaction Sequence or AR Transaction Sequence By Source

Use the following query to find AR Transaction Sequence By Source.

SELECT * FROM all_sequences
WHERE sequence_name LIKE ‘RA_TRX_NUMBER%’;

Some Tips

Example 1) Sequence RA_TRX_NUMBER_N1_81_S is a standard and manual source, this means N1 represents manual source.

Example 2) Sequence RA_TRX_NUMBER_3001_81_S is a custom or user defined source, here 3001 is batch_source_id and 81 is org_id.