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.

Exploring Oracle BI Applications 11.1.1.7.1

Last May I blogged about a new Oracle BI Applications version which had become GA.Thanks to my colleague Rob Chou we are able to explore this new OBIA version here at Scamander.

First stop; Oracle BI Applications Configuration Manager (http://<hostname>:<port>/biacm)

Oracle Business Analytics Version Releases

It has been a busy period over at Oracle with different Oracle Business Analytics software releases. For me personally the following releases attracted my attention:

As always, immediately after a new release of Oracle Business Analytics, there is a lot of buzz within the Oracle BA Community. What did impress me this time was that Oracle added some buzz as well in terms of various Youtube video’s. Next to that there is a lot of information online which should help you to get started. I will give an impression of some of the sources I have seen and used.

Oracle BI EE 11.1.1.7.0

There is lot of information online. There are two interesting links which are a little bit different than the others.

Oracle BIA 11.1.1.7.1

A few weeks ago Oracle BIA 11.1.1.7.1 has gone GA.

This is a completely new version of Oracle BIA. There are a few interesting blog postings on this release. I provided links to the different blogs. There are probably more postings so have a look around.

Oracle Endeca 3.0

  • Oracle Endeca Information Discovery v3.0 Screencast Series
  • Oracle Endeca 123

Feel free to add if you would like.

Completely off-topic, but nevertheless interesting to add is the following.

Last year I had the privilege to review the following; ‘Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial’. For more details on this book, check here.

Another interesting book on Oracle BI 11g is the one from Mark Rittman; ‘Oracle Business Intelligence 11g Developers Guide’

Check the Siebel Essentials site for two reviews about the books above.

One other thing I am working on is translating BITeamwork to the Dutch language. BITeamwork is all about Oracle Business Intelligence Collaboration.

As of this weekend the presentations of the RittmanMead BI Forum 2013 (Brighton and Atlanta) are online.

That’s it for now.

Oracle Business Intelligence Applications 11.1.1.7 GA on OTN

Oracle Business Intelligence Applications 11.1.1.7 GA on OTN.

“The new release of Oracle Business Intelligence (BI) Applications 11g, Release 11.1.1.7.1 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 Oracle.com)”

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 7.9.6.4: Bugs Fixed in 7.9.6.4

Last january Oracle announced the release of a new Oracle BI Applications version; OBIA 7.9.6.4. 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 7.9.6.4: Bugs Fixed in 7.9.6.4 [ID 1528774.1]

 

Oracle Business Intelligence Applications 7.9.6.4 GA on OTN

Oracle Business Intelligence Applications version 7.9.6.4 is Generally Available on OTN. For more details about this release please check the ‘Oracle Business Analytics – Proactive Support’-blog, with details on the two additional Applications (‘Oracle Manufacturing Analytics’ & ‘Oracle Enterprise Asset Management Analytics’) and the Highlights of this new release.

Go through the following links for download and additional documentation.

  • Check for the download here (scroll down to the middle of the page).
  • The documentation, including the Installation Guide, could be find here.
    • Have a look at the Release Notes (7.9.6.3 & 7.9.6.4 combined)
    • OBIA 7.9.6.4: Bugs Fixed in 7.9.6.4, here.
  • For more details on Licensing and Packaging, check here.
  • Oracle Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6.4, check here.

DAC Error Message – Error while executing : INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD

Thanks to Frank Davis, I was able to solve the following error; ‘Error while executing : INFORMATICA TASK:SILOS:@DAC_SIL_PositionDimension_FULL_TD_CMD’

A patch (Patch 12968641: DAC 10.1.3.4.1 CUMULATIVE PATCH FOR BI APPS – SEP 2011) for this error can be downloaded here.