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

This MOS Note will help consultants to find the exact Version and Patch level for installed components. This is very useful when you are logging an Oracle Service Request.  

 

OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment? [ID 1519745.1]

Oracle BI Applications (OBIA) 7.9.6.4 released

Good News Oracle Business Intelligence Application new version 7.9.6.4 is available to download.

Highlights of the Oracle BI Applications 7.9.6.4 Release:

  • New Application – Oracle Manufacturing Analytics with pre-built adapters for EBS Process Manufacturing R12.x and EBS Discrete Manufacturing R12.x and 11.5.10
  • New Application – Oracle Enterprise Asset Management Analytics with pre-built adapters for EBS R12.x, EBS 11.5.10 and IBM Maximo 7.5
  • Universal Adapter to extend the capability to other source systems
  • Certified for OBIEE 11g
  • Certified for Exalytics
  • Certified for DAC 11g including support for Exalytics / Times Ten, Patching Framework, Dual ETL Support and many other performance enhancements
  • Native support for mobile and tablet devices
  • Localized in 28 languages
  • Supported on Oracle, SQL Server, DB2 and Teradata DB
  • Rollup patch resolving 122 BI Applications bugs

Good thing so many bugs are fixed. To get solution / work around,  me and my team spent days on Severity 1 Service Requests with Oracle.

OBIA 7.9.6.4: Bugs Fixed in 7.9.6.4 [ID 1528774.1]

Link to Download Software and Documentations

https://blogs.oracle.com/proactivesupportEPM/entry/oracle_bi_applications_obia_7

TASK_GROUP_Load_PartyDimension “Duplicate Keys Found”

While Running Full load on Oracle Business Intelligence Applications 7.9.6.3, when using Source system R12 TASK_GROUP_Load_PartyDimension failed with error Log says the issue is because “duplicate keys found”

Extract from the Log

**********************************************************************************************************************

CREATE INDEX:W_PARTY_D:W_PARTY_D_U1 has started.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_PARTY_D:W_PARTY_D_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
with error DataWarehouse:CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
EXCEPTION CLASS::: java.lang.Exception

**********************************************************************************************************************

For Resolution:- Download and review the readme and pre-requisites for Patch.14085106.

IBM Maximo and BIAPPS (Oracle BI Applications)

Few days back i was in a meeting with Client, Where client is using Maximo for EAM operations and Oracle eBusiness for Financial. Client was considering BI APPS (Oracle BI Applications) as a central reporting tool where they can monitor KPI’s based on data Oracle eBusiness and MAXIMO and have single window view of complete reporting.

Oracle launches two new applications, which are both based on Oracle’s Business Intelligence Foundation Suite, are designed for the manufacturing sector, and for enterprise asset management (EAM), and are the first in-memory analytic applications for that sector.

Oracle Manufacturing Analytics is intended to help operations managers, manufacturing analysts, manufacturing and
supply chain executives and production cost accountants to have a better view into manufacturing processes, inventory and product quality, to enable them to reduce production costs, improve product quality, minimize inventory levels and respond faster to customer demands.

Oracle Enterprise Asset Management Analytics has been designed to give more effective management and analysis of assets, in areas such as projecting expected asset life, planning strategies to reduce maintenance costs and increase uptime, and realize operational efficiencies. The application is pre-integrated with Oracle E-Business Suite Enterprise Asset Management (EAM) module, as well as IBM Maximo.

Detail Reading on

Oracle Business Intelligence Applications 7.9.6.3 step by step installation and Configuration with screen shots.

Visit ERPstuff.com to download Installation and configuration Guide Version 1.0

Link

Note:- you have to be a registered member and should have access to Documents (Tutorials) Section in Forums