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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s