OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment

OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment

MOS 1519745.1

The Products versions can be found as below:

Oracle Business Intelligence Enterprise Server (OBIEE):

Provide the version.txt file from the following directory

for OBIEE 10g <BI_Home>\OracleBI\ 

for OBIEE 11g <BI_Home>\Oracle_BI1\bifoundation

OBIEE Applied Patches:

Patches applied can be found through

for OBIEE 10g, please review Note 1135013.1 - How to Keep Track of OBIEE 10g Patches Applied? How To Handle Version.Txt Files When You Have Multiple Patches? Are Patches Cumulative?

for OBIEE 11g, use "opatch lsinventory". For more information, review Note 1220799.1 - OBIEE 11g: How to Apply Patches Using Opatch

Oracle Business Intelligence Applications (OBIA):

Provide the version_apps.txt file from the following directory

for OBIEE 10g <BI_Home>\OracleBI\Document

for OBIEE 11g <FMW_Home>\Oracle_BI1\bifoundation\biapps

This can be obtained only from the machine where you have installed Oracle Business Intelligence Administration Tool and where you ran the Oracle Business Intelligence Applications installer to install the Oracle Business Intelligence Applications metadata.

Informatica Admin Console:

Start > Programs > Informatica PowerCenter > Server > Launch Admin Console

Click on the 'About' link

Informatica Designer:

Start > Programs > Informatica PowerCenter > Client > PowerCenter Designer

From the menu options; select Help > Informatica Designer

Provide the 'Version' information from this dialog window

For example:

  Product: Informatica PowerCenter Administration Console

  Version:

  Build Date:

  Build Number: 

Informatica Server:

Provide the version.txt from your <INFA_HOME>\PowerCenterxxx\server directory.

For example:

  Version:

  HotFixNumber:

  Product: Informatica PowerCenter Server

  PreviousInstalledVersion:

Informatica Java:

Provide the Java version installed for Informatica from <INFA_HOME>/java/bin directory and run "./java -version"

Data Warehouse Administration Console (DAC) Client:

Provide the DAC version (DAC Client > Help > About DAC)

DAC Server:

On the DAC server machine, execute "serverinfo" (.bat or .sh) and provide results.

DAC Applied Patches:

DAC Build version usually looks like "DAC Build # 10.1.3.4.1.patch.20120711.0516"

This Shows the DAC version "10.1.3.4.1" and also shows the Build date of the Patch applied "20120711".

"20120711" shows that DAC Patch 14306642 - "DAC 10.1.3.4.1 CUMULATIVE PATCH FOR BI APPS - JUL 2012" is applied.

DAC Container:

The DAC Container (DAC Client > Design > which container in drop down list)

Also confirm if this is a Custom DAC Container.

Application Source System Type:

Provide the Application Source System Type and Version.

For example: EBS R12.1.3 or Siebel 8.x or PeopleSoft

Source OLTP Database:

Provide the type and full database version (including fix packs and Patches) of the Source OLTP system.

Target OLAP Database:

Provide the type and full database version (including fix packs and Patches) of the Target OLAP system.

Reference - MOS 1519745.1