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 – Oracle General Ledger – New and enhanced features

Posted on February 2nd, 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

Lot many emails I was getting since in past few months , asking to share some more information for R12 of General Ledger features, so thought to share in a post.

Here are some of the new feature of General Ledger in R12.

arrow upAccounting Setup Manager

The ledger is a basic concept in Release 12. The ledger replaces the 11i concept of a set of books. It represents an accounting representation for one or more legal entities or for a business need such as consolidation or management reporting. Companies can now clearly and efficiently model its legal entities and their accounting representations in Release 12. This seems to be a major area in getting success of the shared service center and single instance initiatives where many or all legal entities of an enterprise are accounted for in a single instance, and data, setup, and processing must be effectively secured but also possibly shared.

Now, legal Entities can be mapped to entire Ledgers or if you account for more than one legal entity within a ledger, you can map a legal entity to balancing segments within a ledger.

While a set of books is defined by 3 C’s,

  1. chart of accounts
  2. functional currency
  3. accounting calendar,

The addition in this list the ledger is defined by a 4th C: the accounting method,

This 4th C allows you to assign and manage a specific accounting method for each ledger. Therefore, when a legal entity is subject to multiple reporting requirements, separate ledgers can be used to record the accounting information.

Accounting Setup Manager is a new feature that allows you to set up your common financial setup components from a central location.

What is Accounting Setup Manager

Accounting Setup Manager is a new feature that streamlines the setup and implementation of Oracle Financial Applications. The Accounting Setup Manager will facilitate the setup required for simultaneous accounting for multiple reporting requirements.

With the Accounting Setup Manager, you can perform and maintain the following common setup components from a central location:

  • Legal Entities
  • Ledgers, primary and secondary
  • Operating Units, which are assigned to primary ledgers
  • Reporting Currencies, which is an enhanced feature
  • Subledger Accounting Options. This is where you define the accounting methods for each legal entity subledger transaction and associate them to the ledger where the accounting will be stored.
  • Intercompany Accounts and Balancing Rules
  • Accounting and Reporting Sequencing
  • Both Intercompany and Sequencing

Will discuss some more granular details in some other post.

arrow upSubledger Accounting (SLA)

As discussed in couple of earlier post GL is integrated with SLA to enable a unified process to account for subledger transactions and post data to GL, and to provide a consistent view when drilling down from GL to subledger transactions. You can read here.


arrow upEnhanced Foreign Currency Processing by Reporting Made easy

GL has added new features and enhanced existing features to support foreign currency processing , they are mainly as:

  • In R12, MRC feature is enhanced with a feature call Reporting Currencies. That mean it will now support multiple currency representations of data from any source, including external systems, Oracle or non-Oracle subledgers, and Oracle General Ledger journals and balances.
  • The second one is in reporting to view balances view balances that were entered in your ledger currency separate from those balances that were entered and converted to the ledger currency.The change in R12 is that balances entered in the ledger currency are maintained separately from balances converted to the ledger currency for use in Reporting and Analysis.

Here’s an example. Assume we have a ledger and the ledger currency is USD.
I enter and post two journals; one in 1,000 US Dollars, and another in 500 British Pounds that gets converted to 1200 US Dollars.

In Release 11i, I can review the 500 GBP and the 1200 USD that results from converting the 500 GBP, and the total 2200 USD which is the USD balance in the Cash Account. The $2200 is the sum of the $1000 entered in USD and the $1200 converted from the 500 British Pounds. However, I view that a 1000 USD were entered directly in USD.

In Release 12, I can view the 1000 USD by performing an account inquiry on the Cash account for balances entered only in the ledger currency. The amounts entered in foreign currencies that were converted to the ledger currency will not be included in the balance. Of course, if I want to retrieve all balances in USD, both the entered as well and the converted, I can still do that in Release 12.



arrow upCreating foreign currency recurring journals

In Release 11i, you could define recurring journals using the functional currency or STAT currency.

Now in Release 12, you can create recurring journals using foreign currencies. This is particularly useful if you need to create foreign currency journals that are recurring in nature. For example, assume a subsidiary that uses a different currency from its parent borrows money from the parent. The subsidiary can now generate a recurring entry to record monthly interest payable to the parent company in the parent’s currency.

arrow upData Access to Multiple Legal Entities and Ledgers

You no longer have to constantly switch responsibilities in order to access the data in a different ledger. You can access multiple ledgers from a single responsibility as long as all ledgers share the same chart of accounts and calendar.

arrow upSimultaneous Opening and Closing of Periods for Multiple Ledgers

You no longer have to open and close periods for each ledger separately. You can now open and close periods across multiple ledgers simultaneously by submitting Open and Close Periods programs from the Submit Request form.

arrow upSimultaneous Currency Translation of Multiple Ledgers

You can run the Translation program for multiple ledgers simultaneously, if you are managing multiple ledgers.

arrow upFinancial Reporting for Multiple Ledgers

Now with this feature you can run Financial Statement Generator (FSG) reports for multiple ledgers simultaneously. This is useful if you manage multiple ledgers and want to run a balance sheet or income statement report for all of your ledgers at the same time.

arrow upCross-Ledger and Foreign Currency Allocations

You are able to allocate financial data from one or more ledgers to a different target ledger. This enables you to perform cross-ledger allocations, which is useful for purposes such as allocating corporate or regional expenses to local subsidiaries when each entity has its own ledger

arrow upStreamlined Automatic Posting

You can now share AutoPost Criteria sets across multiple ledgers that share the same chart of accounts and calendar and use the AutoPost Criteria sets to post journals across multiple ledgers simultaneously.

arrow upStreamlined AutoReversal Criteria Setup Integrated Web-based

AutoReversal Criteria Sets can also be shared across ledgers to reverse journals across multiple ledgers. This is enhanced by integrated Web-based Spreadsheet Interface.

arrow upJournal Copy

Now we can now copy entire journal batches. You can copy journal batches with any status. The system will create a new journal batch containing the same journal entries.You may also change the batch name, period, and/or effective date while copying the journal batch. After copying the journal batch, you may modify the unposted journals in the same manner as any manually created journals.

arrow upStreamlined Consolidation Mappings

You are able to define Chart of Accounts Mappings (formerly known as Consolidation Mappings) between two charts of accounts. Therefore, if you have multiple Consolidation Definitions for parent and subsidiary ledgers that share the same chart of accounts pair, and their mapping rules are the same, you only have to define a single Chart of Accounts Mapping.

The enhancement in R12 allows you to define mappings between charts of accounts instead of between sets of books, so that they can be shared across multiple Consolidation Definitions.

Therefore, if you have multiple Consolidation Definitions for parent and subsidiary ledgers that share the same chart of accounts pair, and their mapping rules are the same, you only have to define a single Chart of Accounts Mapping.

You can also secure access to chart of accounts mappings using definition access set security. This allows you to secure which users can view, modify, and/or use chart of account mappings in consolidation definitions.

arrow upReplacement for Disabled Accounts

Normally when an account is disabled, you can prevent transactions that include the account from erroring during journal import by defining a replacement account for the disabled account. Journal import replaces the disabled account with the replacement account and continue the journal import process if the replacement account is valid. This improves processing efficiency by preventing the journal import process from erroring and enabling the successful creation of the journal with minimal user intervention when an account has been disabled.

arrow upData Access Security for Legal Entities and Ledgers

In R12, since you can access multiple legal entities and ledgers when you log into Oracle General Ledger using a single responsibility, Oracle General Ledger provides you with flexible ways to secure your data by legal entity, ledger, or even balancing segment values or management segment values. You are able to control whether a user can only view data, or whether they can also enter and modify data for a legal entity, ledger, balancing segment value or management segment value.

arrow upManagement Reporting and Security

This can be best understood as:You can designate any segment (except the natural account segment) of your chart of accounts to be your management segment and use Oracle GL security model to secure the management segment for reporting and entry of management adjustments.

arrow upPrevent Reversal of Journals with Frozen Sources

You can no longer reverse journals from frozen sources defined in the journal sources form.

If the journal is created from a frozen source, the journal cannot be modified even if the source is subsequently unfrozen in the future.
This provides streamlined data reconciliation with subsystems. Not being able to reverse journals that originated in subledgers will ensure that the account balances will always tie out with General Ledger. If you need to reverse a subledger journal, then you should do so in Subledger Accounting or the subledger application.

arrow upPrevent Reversal of Unposted Journals

You also can no longer reverse unposted journals. This ensures data integrity and better auditability. In the past when we allowed you to reverse unposted journals, there was a risk that the original journal could be deleted so you could end up reversing something that didn’t exist. Now, all reversals can be tied back to the original posted journal.

arrow upIntegrated Web-based Spreadsheet Interface

Through the integration with Web ADI, users can now leverage spreadsheet functionality in Oracle General Ledger via a web-based interface. The spreadsheet interface can be conveniently launched from a GL responsibility.

Using the Journal Wizard, we can leverage spreadsheet functionality to create actual, budget, or encumbrance journals. You can take advantage of spreadsheet data entry shortcuts such as copying and pasting or dragging and dropping ranges of cells, or even using formulas to calculate journal line amounts. You can then upload your journals to Oracle General Ledger. Before uploading, you can save and distribute your journal worksheets for approval.

We can also import data from text files into spreadsheets, where it can be further modified before uploading to Oracle. This functionality is useful when migrating data from legacy systems, or from any source that can produce delimited files.

Using the Budget Wizard, you can download budget amounts to a spreadsheet, modify the amounts, and then upload them back. You can also choose to download the actual amounts to compare it with the budget amount. Budget Wizard also allows you to plot graphs and do a graphical comparison on the amounts. Budget Wizard also provides budget notes. You can add descriptions to accounts and amounts in your budget and explain your budget within the budget worksheet, avoiding the clutter of external documentation.

arrow upControl Accounts

You are able to control data entry to an account by ensuring it only contains data from a specified journal source and to prevent users from entering data for the account either in other journal sources or manually within general ledger.

arrow upSecurity for Definitions

You can secure your setup and definitions by granting specific privileges to users to view, modify, and/or execute a definition. This enables you to control which of your users can view a definition, but not modify or execute it, or execute a definition without modifying it, or vice versa.

Following is a list of definitions that have this security available for:

  1. MassAllocation and MassBudget Formulas
  2. FSG Reports and Components
  3. Accounting Calendars
  4. Transaction Calendars
  5. AutoPost Criteria Sets
  6. AuoReversal Criteria Sets
  7. Budget Organizations
  8. Chart of Accounts Mappings
  9. Consolidation Definitions
  10. Consolidation Sets
  11. Elimination Sets
  12. Ledger Sets
  13. Recurring Journals and Budget Formulas
  14. Rate Types
  15. Revaluations

arrow upSequence for Reporting

Maintaining two sequnces have been introduced, accounting and reporting sequencing.

Read my earlier post for more details:

arrow upJournal Line Reconciliation

Journal Line Reconciliation enables you to reconcile journal lines that should net to zero, such as suspense accounts, or payroll and tax payable accounts for countries, such as Norway, Germany, or France.

In R12, we’ve made many improvements to intercompany accounting. R11i’s Global Intercompany System (GIS) has been replaced with an exciting new product called Advanced Global Intercompany System (AGIS). We also extended intercompany balancing support to include encumbrance journals.

arrow upEnhanced Intercompany

For more deatils , read this

arrow upSome of the GL Standard Reports converted into XML Publisher

Oracle General Ledger’s Account Analysis, General Journals and Trial Balance standard reports are now integrated with XML Publisher.

Hope these feature greatly enhanced in GL operation.Any comments:)

Related Posts

Posted in Oracle General Ledger | 37 Comments »Email This Post Email This Post |

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

    Great overview. Missing a section on the new global tax engine. I personally have not had any experiences with GL R12. I would imagine change management would be a challenge for those currently on 11i. However, it is also my understanding that ledgers do not have to be turned on and you can continue with the SOB concept if preferred. Thoughts.

  2. rajasekhar venkata mutyala Says:

    i used to get confused why they have introduced all the new concepts. i understand the importance of r12.i thank sanjit for providing such informatio.

  3. ravi Says:

    thanks Sanjit, this is very useful!

  4. Sudhir Jain Says:

    A Good Insight in enhanced features..Thanx

  5. Appani Yugandhar Says:

    Thanks!! Sanjit Anand. It is very very usefull site. Thanks! a lot.

  6. Andrew Borgen Says:

    Sanjit, that was a beautiful, lucid explanation of R12 concepts! Please keep up the good work for Apps professionals such as ourselves.

    Also found a portal that gives R12 training material free:

    I keep monitoring this site and find that they are adding really good stuff one page at a time!

  7. anil Says:

    could u pls explain the setups and process of consolidated billing, say example my client wants his payment terms to be start from the 1st day of next month for all sales during current month………
    please help in this regard

  8. anil Says:

    the above mentioned is in relation to r12 i need


  9. anil Says:

    how can i add new category to reversal criteria set for a given ledger (r12)


  10. prasad Says:

    Hi, I have a problem in FSG (r12) when i was trying to run a report for the previous period i.e. i selected the previous period in the run individual report window but when i click on submit it is submitting for the current month…please suggest me and how can i convert the same into excel

  11. Navin Says:

    In R12 Gl,with two ledgers (same structures), can i perform a single transaction – having one leg in say ledger A and another leg in ledger B?

  12. Sanjit Anand Says:


    Do get confuse with R12 Ledger.

    The ledger is just a replacement of SOB in R12.

    You should understand Ledger in LE Context.

    Not sure what drives you to capture ledger info in one of leg.

    If I am not wrong, there is IC segment where you can qualify the segments to capture other legs.

    For your understanding with COA segment context with LE

    1)If your company uses legal entities and wants the ability to identify legal entities during transaction processing, designate the balancing segment of the chart of accounts as the legal entity or company segment. This enables you to identify transactions per legal entity and take full advantage of the legal entity accounting features available, such as intercompany accounting.

    2)If you have multiple legal entities that use different charts of accounts, it is recommended that you limit the number of value sets that you define for the balancing segment. This allows you to share the same value set across multiple charts of accounts and assign unique balancing segment values for each legal entity that is consistent across charts of account.

  13. Subroto Bhattacharjee Says:

    Thanks for the info it helps me alot in working with Oracle Apps

  14. Highlights:Release 12 Oracle EBS Financials | OracleApps Epicenter Says:

    […] R12 – Oracle General Ledger – New and enhanced features […]

  15. Chinna Says:

    It is very good, and I amd not seeing new APIs that are part of R12. Overall, it is good. Please update if you could with new APIs.

  16. sangi Says:

    I didn’t see yet R12 application but i have understand some feathers from Oracleapps Epicenter. Thanks Anand. Please update more thinks on R12.

  17. Kristina Says:

    Please explain, how the AutoPost is working in R12. I did set up all the requirements and selected the time = as soon as possible, it is not working, AutoPost is not executed automaticaly?

  18. Jane Heppel Says:

    Thanks for the advice, its so difficult to make your way through the technical stuff which never tells you the implications!
    I’m working on a shared service site and we are teasing out what is meant by a shared chart of accounts – how shared is shared in order to reap the benefits in R12? Shared totally as in using the same segment, or just shared in terms of design?
    “You can access multiple ledgers from a single responsibility as long as all ledgers share the same chart of accounts and calendar.”

  19. Sujatha Says:

    Really this is nice.Thank a lot for the info.

  20. Sujatha Says:

    Really this excellent.Thanks a lot the info.

  21. Oracle Training Says:

    Great article on new features in Oracle R12.

  22. Sindhuri Says:

    Can anyone help me with entering journal entry and changing currency to STAt

  23. Muthukumar Says:

    thanks for this doc. i’m beginer in financial but till i cant understand the concept of primer and secondary, sub ledger. pls anybody help me thanks

  24. syed Says:

    pls send me complted notes of oracle finace r12 pls

  25. syed Says:

    wht the mean of subledger

  26. muthu Says:

    WOW ,nice information
    can u pls any one tel me what about oracle applications R12 certifications ?
    how about demand value in market present?

  27. suerndra Says:

    this is a nice document. can you give an idea about the Localization Setup in R12. it will be very help full. thanks

  28. Gana Says:

    Great Insights. Thanks

  29. Meetu Says:


    Can you send me some PPT of Oracle GL flow in R12.

  30. Rahul kamble Says:

    Thanks anand for ur helpful information…
    as am taking trainin on oracle apps as tech consultant its very useful to me…
    rahul kamble

  31. Rahul kamble Says:

    Thanks anand for ur helpful information…
    as am taking trainin on oracle apps as tech consultant its very useful to me…
    rahul kamble

  32. Rajesh Says:

    any one can explain diffrence between 11i and R12.

  33. Venky Says:

    Could you please sens the PPTs on G/L 11i

  34. Harly Says:

    Ledger is Balancing Segment Value it self?

    After creating chart of account (COA segments and value sets), next step is setting a primary ledger or legal entity (Accounting Setup Manager >> Accounting Setups)?

    What is the different between Legal Entity (GL > Accounting Setup Manager > Accounting Setups) and Legal Entity (IV > Setup > Organization)?

  35. Fred Says:


    I am a new comer to R12 and would like to learn as much as possible pertaining to GL, AP, AR and FA.

    Where can I get learning materials including setups?


  36. Siva Says:

    Its a Very Good Material for R12 Beginners.. I think with they can understand the difference between 11i and R12.

  37. phani kumari Says:

    Good Noon……. Thank You So Much…

Leave a Comment

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