Subledger Accounting (Oracle eBS R12) for Oracle BI Applications

I am currently reading the following book; ‘Oracle Business Intelligence Applications: Deliver Value Through Rapid Implementations’. As far as I know it’s the first and only book on Oracle BI Applications. In Chapter 5: Financial Analytics there is a paragraph about analyzing on Subledger Accounting (SLA) Transactions. This functionality is not in the Out-of-the-Box version of Oracle BIA, but Oracle provides a patch to make SLA Transaction analyzing possible.

If you want more details about this patch, have look on My Oracle Support. Search for; Patch 13697336 – PROVISION FOR LOADING SUB-LEDGER SLA ENTRIES FOR EXCHANGE GAIN/LOSS (Patch)

It could be of added value to my current project, so I will check it out. More on this later.

Validating the Group Account Mapping in Oracle BIA 7963

Configuring Oracle BIA is one of the crucial steps when implementing Oracle BIA. If you omit this step or you perform this step incorrectly, you won’t see the correct figures in your Oracle BIA Dashboards. One of the major steps is the Group Account Mapping.

For Oracle eBS installations, you probably won’t (at least not here in the Netherlands) use the Group Accounts in e.g. the Balance Sheet. It’s more likely that custom GL hierarchies are used. Nevertheless it is essential/crucial that the Group Account Mapping is performed correctly. Oracle BIA will use this Group Account Mapping to decide e.g. whether a record should go an AR-Fact table or to AP.

As a Technical OBIA Implementation Consultant I would advice you to consult a Functional eBS Implementation Consultant to perform the Group Account Mapping. If you still want to have a look at it yourself, you could have a look at the Account Segment Hierarchy in Oracle BIA, to see whether you can map Parents of the Accounts to Group Accounts. This might give you some more insight in the ranges you will need.

In the end, if you want to check whether the Group Account Mapping is correctly executed, you can use the Oracle BIA out-of-the-Box Financial Dashboard. Navigate to the ‘Financials – General Ledger’-Dashboard. Select either the ‘GL Balance’- or the ‘Trial Balance’-page. Filter on Group Account Number; values ‘NULL’ & ‘OTHERS’. If an Account isn’t mapped to a Group Account, the Oracle BIA ETL automatically maps the Account to ‘OTHERS’. Check whether the analysis returns Accounts and still map these Accounts.

Oracle Business Intelligence Applications GA on OTN

Oracle Business Intelligence Applications GA on OTN.

“The new release of Oracle Business Intelligence (BI) Applications 11g, Release has been designed to add new in-memory analytic applications, significantly expand functional content across existing front and back-office Oracle BI Applications, re-architect the solution to leverage the power of Oracle Data Integrator and, introduce new out-of-the-box tools to increase productivity and drive down Total Cost of Ownership (TCO). — (Source”

Check the Release Notes for more details.

The software can be downloaded here and the documentation is here.

Enjoy this new release of Oracle BIA.

Oracle BI Applications Bugs Fixed in

Last january Oracle announced the release of a new Oracle BI Applications version; OBIA In the announcement Oracle mentioned the fact that they applied 122 Bugfixes to this release. Unfortunately no one at Oracle seemed to be able to tell which Bugfixes.

Thanks to Ahmad Bilal for pointing me into the right direction. Have a look at the following note on Oracle Support; OBIA Bugs Fixed in [ID 1528774.1]