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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s