In these article, we will explore the very basics of SLA and why it exists.
Firstly, what exactly does SLA do?
SLA is a module which now sits between the SubLedgers like AP/AR etc and the General Ledger. Have a look at this diagram below. As you will notice, SLA can act as a mediator between the subledgers and Oracle General Ledger.
Before we progress, some terminologies of R12 must be revisited. In 11i we had set of books, and in R12 we call them Ledgers. Likewise in R12 we also have secondary ledgers and reporting ledgers. Hence from 11i perspective think of Ledger as Set of Books. As for Subledger, a Subledger is nothing but a module like AP/AR/PO/Inventory etc.
In the diagram below, the second scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is not customized, then the very same A.B.C.D combination will be passed to Oracle General Ledger via the SLA. And before you wonder... Yes, SLA module has its own set of tables to capture these accounting entries.
Before we progress, some terminologies of R12 must be revisited. In 11i we had set of books, and in R12 we call them Ledgers. Likewise in R12 we also have secondary ledgers and reporting ledgers. Hence from 11i perspective think of Ledger as Set of Books. As for Subledger, a Subledger is nothing but a module like AP/AR/PO/Inventory etc.
In the diagram below, the second scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is not customized, then the very same A.B.C.D combination will be passed to Oracle General Ledger via the SLA. And before you wonder... Yes, SLA module has its own set of tables to capture these accounting entries.
Please see the image below.
In the image above, SLA passes to GL whatever value is fed by the Subledger, in this case A.B.C.D
There are cases where SLA module can alter or massage the CCID or code combination that is generated in Subledger before transferring the same to Oracle General Leger. This scenario is explained whereby let's say that payables module generates a charge account segment combination for an invoice distribution line as A.B.C.D. In such case, if SLA module is customized, then the A.B.C.D code combination of Payables can be passed to Oracle General Ledger via the SLA as A.B1.C1.D instead.
The most important application however of the SLA is its ability to create shadow journals that contain different values or differing credit/debit entries for the transactions. This is the main reason why SLA module was invented/designed. Let us take an example. For company "Apps2Fusion UK", it might have operations in France, which is "Apps2Fusion France". With UK being the parent company, the French company has to do accounting journals in formats that can be reported as per French legislation and also as per UK legislation. For example, in France an inventory item is accounted as expense, whereas in UK the inventory item is accounted as an asset. In the example below, A.B.C.D is never passed to the GL. Instead to GL A.B1.C1.D is passed to the Primary Ledger FRANCE and A2.B2.C.D is passed to the Secondary Ledger UK. The picture below shows the role that SLA plays in such scenario.
Therefore in this article you have learnt the different usages of Subledger accounting.
Comments
I have got an assignment in OAF of R12 cash management module. My task is of customization Bank Account Transfer Page...could you plz guide how SLA is connected to Cash management & what should be my approach for extension of "Bank Account Transfer" Page as its a seeded page i am trying to run this page in jdev but till now no success because controller class throws compilation error in jdev....plz helpp i am working without any input with strict deadlines..
Thanks ,
Anil Passi
Thanks a lot lot for this great article. Its very useful to have the understanding of SLA. Do we have the ability to Split between actual and Accrual w.r.t. advanced intercompany?
Thanks,
Raj
:) :) :) :) :) :)
Thanks
P.Karthikeyan
Thank s,
Sangita Deshmukh
First of all thank you very much for providing excellent posts to understand the concepts.
We have a requirement for intercompany accounting where 2 operating units are involved belonging to different legal entities.
In SLA, we can create mapping rules between Primary Ledger and Secondary Ledger in order to create entries in Secondary Ledger based on the coversion level.
In the same way, Can we create mapping between 2 primary ledgers. For Eg: When we create any invoice in primary ledger1, can we post these entries in Primary Ledger 2 through SLA? Also we wanted to restrict only few entries to be transferred to Primary Ledger 2.
Is it feasible in R12 SLA?
Please provide some thoughts on it
Thanks a lot
Sreenivas
SLA is a service and it is embedded with the menus and forms of the subledgers/modu les like AP/AR etc....
thanks
krishna
RSS feed for comments to this post