Contact us at +1.415.901.7500 or

Oracle R12 Subledger Functionality – Your Questions Answered

Oracle R12 Subledger Functionality – Your Questions Answered

Last week over 90 people registered for IT Convergence’s latest webcast, Oracle R12 Subledger Functionality: Conditional Rule Creation.

Oracle Financials is of course at the core of Release 12 of the Oracle E-Business Suite, and the new Subledger functionality within the General Ledger has generated an enormous amount of interest in the Oracle user community.

As promised, we are happy to provide a transcript of the Q&A portion of the webcast.

  • Christina, why you need to number the lines and the conditions 10 spaces apart?
    It’s similar to when you’re doing journal entries in the GL, If you put them 1, 2, 3, 4, 5 and you’ve forgotten something, you can’t go back in and add it into the sequence of events. But if you number them about 10 spaces apart; 10, 20, 30, 40, ect, you can always go back in and add something to your concatenation strings or to your condition sequence of events. So by the 10 I can go back in and put a 5 which would then become the first sequence of events or piece of information that it concatenates.
  • If I copy an Oracle rule, it doesn’t automatically replace the Oracle rule with mine in the rest of the setup?
    No, so just like that accounting builder method overview showed, if you modified or create a rule a journal line type, account derivation, or journal description you have to go in and place it, into either in an existing journal line definition or create a new journal line definition. And then that journal line definition gets placed into or into a new created, application accounting definition and then that application accounting definition get placed into a Subledger accounting method. So remember that the flow of information works from the bottom up, you’ve touched almost the bottom most row and then you need to touch the rest of the flow as well.
  • Do I have to modify the rules in Subledger accounting for it to work properly? Subledger accounting out of the box is running quietly and in the background, always in R12. If you do not modify any of the setups or the accounting methods builder the rules in the subledger accounting, out of the box it works just passing your information from your subledgers to your General Ledger. So there’s nothing you have to do in order for subledger accounting to work, it’s already setup and running in Oracle R12.
  • Can we create custom events within R12’s subledgers?
    Yes, you will have noticed in our accounting methods builder when you’re under that setup list, there is a setup function for setting up custom events and sources. So you can do both you can create your own custom event based on your business need as well as your different sources, if you have something external coming in you can create a source for that as well.
  • Are you planning to do another webcast or another presentation on Oracle R12’s Subledger accounting?
    Yes, so our first one on the overview of Oracle Financials R12 was back in August or September where I think we just did the overview of subledger accounting there. In October we offered our first webcast devoted to Oracle R12’s subledger accounting,, so now we are following up with rule creation and probably in the spring some time we’ll offer a third on subledger accounting on more custom creation and the rest of the journal definition accounting method and application accounting definition, ect.
  • Is there any new reporting with R12’s subledger accounting
    Yes, there is a lot of new reporting with subledger accounting. One of the best is the Subledger Accounting Exception report, that runs when you create accounting from one of your subledgers and it is excellent. Really, Oracle has stepped up their game with new error messages that are extremely user friendly, so you are really going to like the subledger accounting exceptions report. There’s a couple of other canned reports that subledger accounting gives you, but it’s all about how the flow of information either got stuck or stopped or if a rule failed, things like that.

Our first webcast of 2011 will be on reporting options for the Oracle E-Business Suite R12.

Indeed, we’re expecting to offer another webcast on Oracle R12 Subledger accounting in either March or April of 2011. In the meantime, if you need to get up to speed on Oracle Financials R12 Subledger Accounting you can attend the workshop on it that we are offering with the Oracle Applications Users Group.

The R12 Subledger accounting workshop is part of the larger Oracle Applications Workshops that we’re sponsoring with the OAUG, whose members get 25% off the admission price, with additional discounts for companies that buy multiple workshop seats. You can click here to register for our webcast on Oracle E-Business Suite Reporting options by clicking here. Likewise, click here for more information about our Oracle R12 Subledger Functionality workshop.