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.

Solving the Informatica TM_6795 ERROR

When running an Execution Plan in the DAC, I ran into an error. Investigating this error led to the Informatica Workflow Monitor. The logfile returned the following error;

“TM_6795 ERROR: Session or its instance is invalidated and the Integration Service is configured not to run impacted sessions.”

The Informatica Message Reference leads to the following;

***

TM_6795 The Repository Service marked the session as impacted, and the Integration Service is not configured to run impacted sessions.
User Response: Validate the session or configure the Integration Service to run impacted sessions.

***

If this is the case check whether all the related Informatica Mappings, Mapplets and Workflows, etc. are  validated and checked in. The latter did it for me. Not all obnjects where properly checked in.