Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

R12 : Sequence in GL made Legal Compliance Easy

Posted on January 17th, 2008 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

In R12, to cater the need for legal compliance some other counties like Asia, Latin America, and Europe ,two Journal Sequencing options have been provided. These are accounting and reporting sequence, in reality there is bit difference in these two terms.

double-arrowAccounting Sequence
This is sequence used in GL journals when posted in GL ,Sequence subledger journals when completed in Subledger Accounting.

What we have seen in Release 11i, we had document sequencing that sequentially numbered documents upon creation. Accounting Sequencing will automatically assign a sequence number to GL journal entries that are posted in GL. There’s also an option to sequence subledger journals when they are completed in SLA Accounting.

double-arrowReporting Sequence
This sequence is used in GL Journals when you close a GL Period.Sequence sub ledger Journals when you complete the accounting in SLA .This is one of replacement of Accounting Engine (AX) legal sequencing and Italian Journal Book commonly known Libro Giornale.

These two Sequences can be assign mutually exclusive sequences based on:

  • Ledgers or Reporting Currencies
  • Journal sources
  • Journal categories
  • Balance types

double-arrowThe benefit of using these sequnces are summarized :

a) Legal Compliance made easy: The one biggest advantage of it will now addresses business requirements in many countries, such as Europe & Asia. Therefore its allows fiscal authorities to verify the completeness of a company’s accounting records.

b)Flexibility get enhanced:With this it provides greater flexibility in choosing different journal sequencing options, as mention above, these can be based out of these different criteria, such as by ledgers, reporting currencies, journal sources, journal categories, and balance types.

c)No Localization Required: Somehow related to (a) discussed above, earlier it the local reporting need was catered by localization , which now is part of GL activity.

double-arrowWhere to Define the the sequence.

You can define the accounting sequence in the context of a ledger in Accounting Setup Manager.There is another way ie Accounting Sequencing menu function which we can create and manage our sequencing rules.



For Accounting Sequences which is internally a posting event, the GL journals are sequenced when they are posted in GL and Subledger journals are sequenced when completed in SLA. For Reporting Sequences (period close event), GL journals and subledger journals are sequenced when a GL period is closed.You can see both can be appear in the Journal screen as below.



Related Posts

Posted in Oracle General Ledger, R12, Release12 | 7 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
7 Responses
  1. chelsea Says:

    hi Anand,
    i just find the define sequence in the form not java web.can u give me guide what i miss.

  2. chelsea Says:

    i have soled it.thank you!

  3. R12 - Oracle General Ledger - New and enhanced features Says:

    […] : Setting up for AP/AR Netting“Contra Charging” to “R12 AP/AR Netting”R12 : Sequence in GL made Legal Compliance EasySAP-ORCL – ‘ GL Journal’Is ..”Oracle Applications Not Secure “?SAP-ORCL: […]

  4. Hasan Mir Says:

    Thank you! To the point. Precise. Great Service.


  5. Stelm Says:

    One benefit is that sequencing in AP may have gaps (ie deleted AP invoices).
    Accounting sequences ensure accounted AP documents have sequences gapless.

  6. Oracle Training Says:

    Great article on Oracle General Ledger sequences. Thank you.

  7. AJS Says:

    Great Article to rely on

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.