We have thus far seen the basic fundamentals and a simplistic scenario of Subledger Accounting. In the example that we 
saw, we created components required for the SLA configuration from ground zero. That is also known as the bottom up approach, where you build the lower level components and then move up the chain to attach your SLA configuration to your Ledger[11i SetOfBook equivalent in R12].
However you never ever use that approach in real life for modules such as Oracle Payables, Oracle Receivables, Oracle Cash Management, Oracle Fixed Assets or Oracle Project Accounting etc. The reason is that, SLA comes pre-configured for all the widely used modules in the EBusiness Suite. All the commonly used rules are already seeded into the SLA config by Oracle, hence all you need to do is to customize those components.
Before we see the steps for customization of SLA, let us first do some questions and answers
Question - I can customize the account generator in Procurement and Fixed Assets. Do I really ever need to customize “Subledger Accounting” in such cases?
Answer- The pre-configured SLA by Oracle will use the accounts generated in respective modules as the source. The seeded ADR's will in most cases return the very same accounts that are generated in the respective modules. Effectively "garbage in garbage out", or you can say "quality of the account that goes into SLA, and the same quality accounts are then sent to General Ledger". The message from seeded SLA in most cases is “What you feed to SLA will also be fed into the Oracle General Ledger”. Therefore if you have already customized the account generation workflow in the respective module then you do not require customization in SLA. In fact, the customizations on the seeded SLA configurations must be kept to bare minimum. Although SLA provides you with ability to override accounting definition, however the main reason for creation of SLA was to implement multiple shadow accountings against ledgers.
Question - If all the respective modules can generate accounting properly then why is SLA really needed?
Answer - Well, the main reason behind creation of SLA itself was to create shadow journals for secondary ledger. Please see the Part 1 in this series of articles.
Now let us take the example for customization of an existing SLA definition pre-seeded by Oracle in R12. In this example, a SLAM named STANDARD_ACCRUAL is attached to the Ledger [Set Of Book equivalent of 11i ]. As you will notice from the image below, many modules such as Leasing, Loans, Cash Management, Payables etc are attached to this SLAM. However we are interested in modifying just the Payables piece of this SLAM. Create a copy of this SLAM as shown in the image below. We will create a SLAM named ANIL_SLAM__STANDARD_ACCRUAL which happens to be the exact copy of SLAM named STANDARD_ACCRUAL.
Now create new entry for Payables within the copied SLAM, i.e. new SLAM will
be " ANIL_SLAM__STANDARD_ACCRUAL"
Now you have created a new SLAM. In this SLAM, end date the AAD assignment of Payables and add a new entry for Payables. Note that we still have AAD named "Accrual Basis" attached. However after we copy the "Accrual Basis" into a custom AAD, we will then return to this screen in order to replace "Accrual Basis" by custom AAD. Click on "Application Accounting Definition" button.
Now, click on copy, and this time we will copy the AAD definition named “Accrual Basis” to create a new AAD named ANIL_STD_PAYABLES_STD.
The new AAD will be called ANIL_STD_PAYABLES_STD as shown below. Click on button labelled Done to complete the Copy operation for the AAD.
Now this new AAD has been created. Before we customize this AAD, we need to ensure that this AAD has been attached to the custom SLAM that we created in Step 1 of this article.
Now, back to the SLAM screen, for the custom SLAM, for Payables AAD assignment record, we attach the custom AAD to Payables. Please note that the Payables entry that is attached to custom AAD named “Accrual Basis” has now been end dated, as shown in image below.
Now go back to AAD, by clicking on Application Accounting Definition button as per the image above.
Follow the instructions as per images below
Now copy the Journal Line Definition itself.
The image below shows how the custom/copied journal line definition will be modified. Our idea here is to attach a custom ADR for the generation of an account.
The name of the copied JLD will appear as below.
Attach the custom ADR as shown below
And now attach your custom Journal Line Definition to the custom AAD.
This completes the cycle for customization of the pre-seeded SLA configuration.
saw, we created components required for the SLA configuration from ground zero. That is also known as the bottom up approach, where you build the lower level components and then move up the chain to attach your SLA configuration to your Ledger[11i SetOfBook equivalent in R12]. However you never ever use that approach in real life for modules such as Oracle Payables, Oracle Receivables, Oracle Cash Management, Oracle Fixed Assets or Oracle Project Accounting etc. The reason is that, SLA comes pre-configured for all the widely used modules in the EBusiness Suite. All the commonly used rules are already seeded into the SLA config by Oracle, hence all you need to do is to customize those components.
Before we see the steps for customization of SLA, let us first do some questions and answers
Question - I can customize the account generator in Procurement and Fixed Assets. Do I really ever need to customize “Subledger Accounting” in such cases?
Answer- The pre-configured SLA by Oracle will use the accounts generated in respective modules as the source. The seeded ADR's will in most cases return the very same accounts that are generated in the respective modules. Effectively "garbage in garbage out", or you can say "quality of the account that goes into SLA, and the same quality accounts are then sent to General Ledger". The message from seeded SLA in most cases is “What you feed to SLA will also be fed into the Oracle General Ledger”. Therefore if you have already customized the account generation workflow in the respective module then you do not require customization in SLA. In fact, the customizations on the seeded SLA configurations must be kept to bare minimum. Although SLA provides you with ability to override accounting definition, however the main reason for creation of SLA was to implement multiple shadow accountings against ledgers.
Question - If all the respective modules can generate accounting properly then why is SLA really needed?
Answer - Well, the main reason behind creation of SLA itself was to create shadow journals for secondary ledger. Please see the Part 1 in this series of articles.
Now let us take the example for customization of an existing SLA definition pre-seeded by Oracle in R12. In this example, a SLAM named STANDARD_ACCRUAL is attached to the Ledger [Set Of Book equivalent of 11i ]. As you will notice from the image below, many modules such as Leasing, Loans, Cash Management, Payables etc are attached to this SLAM. However we are interested in modifying just the Payables piece of this SLAM. Create a copy of this SLAM as shown in the image below. We will create a SLAM named ANIL_SLAM__STANDARD_ACCRUAL which happens to be the exact copy of SLAM named STANDARD_ACCRUAL.
Now create new entry for Payables within the copied SLAM, i.e. new SLAM will
be " ANIL_SLAM__STANDARD_ACCRUAL"
Now you have created a new SLAM. In this SLAM, end date the AAD assignment of Payables and add a new entry for Payables. Note that we still have AAD named "Accrual Basis" attached. However after we copy the "Accrual Basis" into a custom AAD, we will then return to this screen in order to replace "Accrual Basis" by custom AAD. Click on "Application Accounting Definition" button.
Now, click on copy, and this time we will copy the AAD definition named “Accrual Basis” to create a new AAD named ANIL_STD_PAYABLES_STD.
The new AAD will be called ANIL_STD_PAYABLES_STD as shown below. Click on button labelled Done to complete the Copy operation for the AAD.
Now this new AAD has been created. Before we customize this AAD, we need to ensure that this AAD has been attached to the custom SLAM that we created in Step 1 of this article.
Now, back to the SLAM screen, for the custom SLAM, for Payables AAD assignment record, we attach the custom AAD to Payables. Please note that the Payables entry that is attached to custom AAD named “Accrual Basis” has now been end dated, as shown in image below.
Now go back to AAD, by clicking on Application Accounting Definition button as per the image above.
Follow the instructions as per images below
Now copy the Journal Line Definition itself.
The image below shows how the custom/copied journal line definition will be modified. Our idea here is to attach a custom ADR for the generation of an account.
The name of the copied JLD will appear as below.
Attach the custom ADR as shown below
And now attach your custom Journal Line Definition to the custom AAD.
This completes the cycle for customization of the pre-seeded SLA configuration.
Comments
(18)
Subscribe to this comment's feed
...
written by Anil Passi- , December 18, 2010
written by Anil Passi- , December 18, 2010
Hi Joy
The accounts generated within the Payables do not change, these new accounts are captured in SLA tables and then transferred to GL.
Thanks,
Anil Passi
Votes: +0
The accounts generated within the Payables do not change, these new accounts are captured in SLA tables and then transferred to GL.
Thanks,
Anil Passi
report abuse
vote down
vote up
Account generators
written by Joy , December 18, 2010
written by Joy , December 18, 2010
Hi Anil,
By customizing Project Account generators , we are able to change the accounting for Project related Supplier Invoices within AP(Not SLA).
So in the same manner will we not be able to customize project related invoice account generation in AP ?. If we are not able to change the accounting generation within AP , then SLA will not be able to completely replace customization of Accounting generators. Can you please comment on this .
Thanks
Joy
Votes: +0
By customizing Project Account generators , we are able to change the accounting for Project related Supplier Invoices within AP(Not SLA).
So in the same manner will we not be able to customize project related invoice account generation in AP ?. If we are not able to change the accounting generation within AP , then SLA will not be able to completely replace customization of Accounting generators. Can you please comment on this .
Thanks
Joy
report abuse
vote down
vote up
Chart of accounts API
written by Shokoofeh , January 04, 2011
written by Shokoofeh , January 04, 2011
Hi Dear Anil,
First of all,Happy new year and thank you for your excellent articles.we are migrating to R12,I want to know,there is api for char of accounts?If yes,how we can use it?
Regards,
Shokoofeh
Votes: +0
First of all,Happy new year and thank you for your excellent articles.we are migrating to R12,I want to know,there is api for char of accounts?If yes,how we can use it?
Regards,
Shokoofeh
report abuse
vote down
vote up
SLA - Custom Sources
written by Arun Sircar , January 13, 2011
written by Arun Sircar , January 13, 2011
Hi Anil,
When do we actually need to have a custom source without which we cannot customize SLA? Also can you give some 5 0r 6 examples of situations when SLA would be useful. Thanks,
Arun
Votes: +0
When do we actually need to have a custom source without which we cannot customize SLA? Also can you give some 5 0r 6 examples of situations when SLA would be useful. Thanks,
Arun
report abuse
vote down
vote up
...
written by Shokoofeh , January 17, 2011
written by Shokoofeh , January 17, 2011
Hi Anil,
Thanks for the post, Are there such this good post for setting up cost managements?
Regards,
Shokoofeh
Votes: +0
Thanks for the post, Are there such this good post for setting up cost managements?
Regards,
Shokoofeh
report abuse
vote down
vote up
designer neckties
written by designer , March 03, 2011
written by designer , March 03, 2011
What a wonderful post! this is my first time i visit here. I designer necktiesfound so many interesting stuff in your blog especially its discussion.I'd like to recommend something to you, you'll like it.I find my favoraite shop.
Votes: +0
report abuse
vote down
vote up
SLA Changes to transaction from Inventory
written by Biren , May 20, 2011
written by Biren , May 20, 2011
Hi Anil,
Hope you are well, I am looking at pushing transaction from Inventory to a seperate GL account code for a particular type of sub-inventory.
Would you recommend SLA changes?.
Regards
Biren
Votes: +0
Hope you are well, I am looking at pushing transaction from Inventory to a seperate GL account code for a particular type of sub-inventory.
Would you recommend SLA changes?.
Regards
Biren
report abuse
vote down
vote up
GHD straighteners australia
written by ghd australia , August 31, 2011
written by ghd australia , August 31, 2011
If you have not yet tried pink GHD straightener, it's time to own one and feel the difference it can make to your personality.
Votes: +0
report abuse
vote down
vote up
Very nice article! It really made me interested here. Thank you for bringing more informative post. I can't wait to read more of your blogs.
report abuse
vote down
vote up
electronic ballast
written by electronic ballast , November 18, 2011
written by electronic ballast , November 18, 2011
Ningbo Zhengjia Electric Appliance Co., Ltd is a professional R & D manufacturer and exporter of electronic ballast for fluorescent lamps(FL) and Compact Fluorescent Lamps(PL).
report abuse
vote down
vote up
...
written by rolex replica , December 15, 2011
written by rolex replica , December 15, 2011
fake rolex Daytona watches is generally far more pricey than fake rolex Sea Dweller watchesif you assess related types, but a single can typically justify this when you think about that Rolex will keep its value over time.
Votes: +0
report abuse
vote down
vote up
block machine
written by block machine , January 11, 2012
written by block machine , January 11, 2012
Ningbo Yinzhou Nuoya Cement Block Machine Factory, a professional manufacturer and exporter of all kinds of Single and Multi Spring brick machine,concrete brick machine,block machine,We are a member of Building Block Association with excellent and advanced technology.
report abuse
vote down
vote up
SLA changes for Fixed Assets
written by Rashmi Adikane , January 27, 2012
written by Rashmi Adikane , January 27, 2012
Hi Anil
I am trying to modify Addtion Cost Rule in Fixed Asset; I want one of the segment value (in my case is PROJ which is seg9) get overwritten by AP Clearing PROJ code. I have tried to modify the rule definition to use the source as "Asset Clearing Account Code Combination Identifier" but I am not seeing the PROJ code coming from this Asset Clearing Account Code Combination
Any suggestions
Votes: +0
I am trying to modify Addtion Cost Rule in Fixed Asset; I want one of the segment value (in my case is PROJ which is seg9) get overwritten by AP Clearing PROJ code. I have tried to modify the rule definition to use the source as "Asset Clearing Account Code Combination Identifier" but I am not seeing the PROJ code coming from this Asset Clearing Account Code Combination
Any suggestions
report abuse
vote down
vote up
Thanks for the post. By this example we can override the Liability account that is generated in AP itself, (rather than the shdow account to be sent to GL). Please confirm.
Also, if we customize Account generators as well as SLA, which of the accounting will hold precedence while getting generated in Sub ledgers ?
Thanks
Joy