Posted on November 16th, 2007 by Sanjit Anand || Email This Post
Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today |
Most of us are well aware that in Release 12 of Oracle Applications, Subledger Accounting (SLA) has been introduced, which is a Rule-based accounting engine, toolset & repository which is supporting most of Oracle business Suite modules. As we know driver for introduction this is to have an option of allowing multiple accounting representations for a single business event, resolving conflicts between corporate and local fiscal accounting requirements. The Functionality is somehow very similar to Global accounting engine, which oracle does offer for European reporting Need.
So What is Subledger Accounting?
• SLA is an intermediate step between subledger products and the Oracle General Ledger
• Journal entries are created in Subledger Accounting and then transferred to Oracle General Ledger
• Each subledger transaction that requires accounting is represented by a complete and balanced subledger journal entry stored in a common data model
Is this Module or what?
It is good to know ,sub ledger Accounting is a Service, not an Application .
The high points of SLA would be:
- There are no SLA responsibilities
- Users do not login to SLA
- SLA is a service provided to Oracle Applications
- SLA forms and programs are embedded within standard Oracle Application responsibilities
- SLA provides the following services to Oracle Applications
- Generation and storage of detailed accounting entries
- Storage of subledger balances (e.g. third party control account balances)
- Subledger accounting entries
- Subledger reporting (e.g. Subledger journal reports, open account balances listing)
What oracle application Module taking services for SLA?
Most of modules which need accounting entry with finance uses service of SLA Modules.
This new Product has these many new functionality such as:
- Journal Entry Setup and sequencing
- Date Effective Application accounting Definitions
- Multiple Accounting Representation
- Multi-period Accounting
- Summarization Options
- Draft and online accounting
- Replacement for disabled accounts
- Process category Accounting
- Transaction account Builder
- Accrual Reversal Accounting
- Accounted and Gain/Loss Amount calculations
- Application Accounting Definition Loader
- Enhanced Reporting Currency Functionality
The overall advantage of SLA can be summarized by oracle as below:
GL Flow with Subledger-Level Secondary Ledger
Lets take a case , with a scenario with basic Finance module, you can find how tightly accounting model is separated with transaction model in release 12.
This is the typical flow within one product with SLA can be best described as:
November 17th, 2007 at 6:38 pm
Hi Anand,
Nice post, I’m keen to know if subledger accounting is just the extension and “exposure” of the ap_ae_headers/lines that the core financials modules have already in 11i? Any thoughts?
Gareth
November 25th, 2007 at 12:53 am
[…] and 2007 report for ERP VendorsOracle OpenWorld 2007 Presentations : Available for DownloadR12 SLA: From Product Accounting to Subledger AccountingSCM SubsystemKNOW WHAT IS SUPPLY CHAIN MANAGEMENT (SCM)? : An OverviewDiscrete & Process […]
December 7th, 2007 at 9:09 am
[…] and 2007 report for ERP VendorsOracle OpenWorld 2007 Presentations : Available for DownloadR12 SLA: From Product Accounting to Subledger Accounting […]
January 27th, 2008 at 7:35 am
[…] we have already seen in few earlier post “Oracle Subledger Accounting ” is a rules-based engine for generating accounting entries based on source transactions from […]
February 3rd, 2008 at 7:00 am
[…] 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 […]
February 5th, 2008 at 12:48 am
[…] R12 SLA: From Product Accounting to Subledger Accounting […]
March 20th, 2008 at 5:20 am
Dear Anand
it was a excellent article that has given me a good insight into the basic concepts vis a vis the SLA in Release 12. Yet i am having more doubts in SLA Set up.
April 18th, 2008 at 2:51 am
[…] R12 SLA: From Product Accounting to Subledger Accounting […]
May 2nd, 2008 at 4:00 am
[…] R12 SLA: From Product Accounting to Subledger Accounting […]
July 2nd, 2008 at 12:38 am
[…] is no need to explaining again , we already seen why this concept brought into Financial application . Fixed asset though one of Application, which heavily utilize the accounting information […]
August 28th, 2008 at 11:59 am
Hi, i get a issue when i try to make drill down by Gl to a account from Treasury, why don’t do anything, appear drill down frozen, is because I get a security rule or something? unmark something? I have to do it since treasury module? In oracle tell me about a new update contain it a patch with this change, is it real?
October 9th, 2008 at 1:00 am
[…] R12 SLA: From Product Accounting to Subledger Accounting […]
October 10th, 2008 at 4:13 pm
[…] R12 SLA: From Product Accounting to Subledger Accounting […]
November 20th, 2008 at 6:51 am
Nice article. Have a question. How does oracle record amounts for an event. For eg: when a invoice is matched to 3WAY PO, how does oracle know what amount to post for reversal of accruals. I did set up reversal of accruals accounts for Invoices, but it should post reversal for only the received amount and not for invoiced amount. How does oracle does it?
December 30th, 2008 at 11:52 pm
Hi,
I have 2 questions on SLA Methods..
1. If a pass a manual JV in GL, will that also go through the SLA methods defined..
a) If NO, then if I have Secondary Ledger defined then how the entry will get generated in the seconday Ledger
b) If YES..is this a mandatory or an optional setup?
2. The same funda for a transaction through a third party system into GL..will that also go through SLA?
October 28th, 2009 at 8:51 am
Thank you. Great article on Oracle SLA.
November 28th, 2010 at 8:21 pm
Really Your explanation is very -2 helpful to understand the SLA.