- OracleApps Epicenter - http://www.oracleappshub.com -

R12 SLA: From Product Accounting to Subledger Accounting

Posted By Sanjit Anand On November 16, 2007 @ 8:42 am In EBS Suite,R12,Release12 | 17 Comments

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 [1] Need.

purp 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

yel

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)

bluWhat oracle application Module taking services for SLA?
 Most of modules which need accounting entry with finance uses service of SLA Modules.

greThis 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

redThe overall advantage of SLA can be summarized by oracle as below:

subledgeraccounting1

 

bluGL 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.

subledger

This is the typical flow within one product with SLA can be best described as:

subledgeraccounting

17 Comments (Open | Close)

17 Comments To "R12 SLA: From Product Accounting to Subledger Accounting"

#1 Comment By Gareth Roberts On November 17, 2007 @ 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

#2 Pingback By R12 SLA: Analyzing Subledger Accounting On November 25, 2007 @ 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 [...]

#3 Pingback By Release 12 : Legal Entity uptake On December 7, 2007 @ 9:09 am

[...] and 2007 report for ERP VendorsOracle OpenWorld 2007 Presentations : Available for DownloadR12 SLA: From Product Accounting to Subledger Accounting [...]

#4 Pingback By Release 12: 6 New and Changed Feature in “Oracle Assets” On January 27, 2008 @ 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 [...]

#5 Pingback By R12 – Oracle General Ledger – New and enhanced features On February 3, 2008 @ 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 [...]

#6 Pingback By Highlights:Release 12 Financials On February 5, 2008 @ 12:48 am

[...] R12 SLA: From Product Accounting to Subledger Accounting [...]

#7 Comment By Ram Ganesh On March 20, 2008 @ 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.

#8 Pingback By R12 SLA: Accounting Methods Builder On April 18, 2008 @ 2:51 am

[...] R12 SLA: From Product Accounting to Subledger Accounting [...]

#9 Pingback By White Paper : R12 Oracle Subledger Accounting On May 2, 2008 @ 4:00 am

[...] R12 SLA: From Product Accounting to Subledger Accounting [...]

#10 Pingback By Fixed Asset & SLA On July 2, 2008 @ 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 [...]

#11 Comment By Isaias Martinez On August 28, 2008 @ 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?

#12 Pingback By Sub Ledger Accounting – Technical perspective | OracleApps Epicenter On October 9, 2008 @ 1:00 am

[...] R12 SLA: From Product Accounting to Subledger Accounting [...]

#13 Pingback By Highlights:Release 12 Oracle EBS Financials | OracleApps Epicenter On October 10, 2008 @ 4:13 pm

[...] R12 SLA: From Product Accounting to Subledger Accounting [...]

#14 Comment By Sridevi On November 20, 2008 @ 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?

#15 Comment By Rajib On December 30, 2008 @ 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?

#16 Comment By Oracle Training On October 28, 2009 @ 8:51 am

Thank you. Great article on Oracle SLA.

#17 Comment By Shailendra Agarwal On November 28, 2010 @ 8:21 pm

Really Your explanation is very -2 helpful to understand the SLA.

Article printed from OracleApps Epicenter: http://www.oracleappshub.com

URL to article: http://www.oracleappshub.com/release12/r12-sla-from-product-accounting-to-subledger-accounting/

URLs in this post:

[1] European reporting : http://www.oracleappshub.com/oracle-product/understanding-global-accounting-engine-product-ax/

Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.