Business Driver

Upgrade the Oracle BI Apps 7.9.6.X to Oracle BI Apps 11.1.10.1. Migrate ETL code from Informatica to ODI and upgrade OBIEE 11g to 12c.

Selection Process

The company evaluated many consulting companies but selected KPI Partners because of KPI's expertise in BI APPS, Informatica, ODI, and OBIEE. In addition, KPI proposed a team with 100% offshore team resources to minimize cost and risk for the customer.

What KPI Delivered

KPI proposed Upgradation of Oracle BI Apps 7.9.6.4 (Informatica version) to Oracle BI Apps 11.1.10.1 (ODI Version) from multiple source systems like PSFT, Primavera, SQL Server, and flat-files. Upgradation has been done on Oracle Financials, Project and Supply Chain, and HR Analytics.

We have installed and configured BI Apps 11.1.1.10.1. Converted 500+ mappings from Informatica to ODI which includes ROV and other custom mappings. Customized the load plan in an optimal way to increase the ELT load performance. Enabled usage tracking and email configuration in ODI for load notifications.

Upgraded OBIEE 11g to 12c using bar file and configured the security as it was in OBIEE 11g. More than 600 reports were validated and updated the data model in RPD as per BI Apps standards. Created BI publisher reports on SQL server tables based on Client requirements.

We have Developed ELT mappings and reports for the Quality custom module.

Business Benefits

The new BI Apps version with ODI reduces the load time and server cost. It also helped and encouraged the team to find key new further of the ELT tool and OBIEE 12c which help their business grow.