R12 What are the Differences Between Accounting Sequencing and Reporting Sequencing?

The accounting sequence is assigned to Subledger Accounting journal entries at the time that the journal entry is completed. The sequence is assigned in the completion date order using the GL date as the date criterion for determining the sequence to be used.

The reporting sequence is assigned to both Subledger Accounting journal entries and General Ledger journal entries when the General Ledger period is closed. This sequence is used by most of the legal reports required in some countries as the main sorting criterion to display the journal entries.Reporting sequence is optional.

These two sequences are not mutually exclusive and can coexist in the same journal entry.

Note: for more details
-Oracle� Financials Implementation Guide (Part No. B16386-01) contains a
separate chapter on Accounting and Reporting Sequencing;
-Oracle� Subledger Accounting Implementation Guide chapter on Reporting Sequencing;

Setup:

1 Go to Setup > Financials > Sequences >.Assign
2.Select your General Ledger
3.Select Sequence Entity : ‘Subledger Journal Entry’
4.Select Sequence Event : ‘GL Period Close’: for fiscal reporting during accounting period close./
‘Accounting’: for fiscal accounting of journal entries originating in the subledgers.
5 .Select Sequence Entity : ‘GL Journal Entry’
6. Select Sequence Event: ‘GL Period Close’: for fiscal reporting during accounting period close./
‘Posting’ : for fiscal accounting of journal entries originating in the general ledger.