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 7.9.6.3, 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.

Installing Oracle BI Apps 7.9.6.3

The following is a short description of what steps have to be taken to install Oracle BI Applications (OBIA) version 7.9.6.3. This version of OBIA is the first version which runs on the new Oracle BI 11g 11.1.1.5.0 platform

This document assumes, that Oracle BI 11g has been installed already. Make sure the Weblogic Administration Server is running before the installation starts.

  • Unpack the installation software
  • Navigate to the folder; ‘Oracle_BI_Applications’
  • Start Setup.exe
  • A wizard will start

  • Click Next
  • Enter the installation directories — {MIDDLEWARE_HOME}
    • There are three important locations;
      • Oracle BI Home Locatie  –> {MIDDLEWARE_HOME}\Oracle_BI1
      • Oracle Instance Locatie  –> {MIDDLEWARE_HOME}\instances\instance1
      • Oracle Domain Location –> {MIDDLEWARE_HOME}\user_projects\domains\bifoundation_domain

  • Click Next
  • Enter the Weblogic Administrator Details

  • Click Next
  • In the background, some examinations are performed. This could take a while
  • Select the applications (default = everything), which should be installed

  • Click Next
  • A summary appears with the e=information about what will be installed

  • Click Next
  • Wait for the installer to finish
  • Click Finish

After the installation has finished, one can check what has been installed. In the ‘Oracle BI Home’ there has been an additional folder (biapps) added.

You will find the new Repository RPD-file in; {MIDDLEWARE_HOME}\Oracle_BI1\biapps\repository

The Repository can be opened offline. The Repository password (Admin123) is the default.

De new Catalog resides in the; {MIDDLEWARE_HOME}\Oracle_BI1\biapps\catalog-folder.

More to come.