Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« HR Analytics in Retail Industry - Part 2 | Main | Achieving Smart Sourcing using Oracle Procurement Cloud »

Oracle BI Apps Upgrade Paths

With the recent explosion of Oracle's Business Intelligence portfolio, enterprises are left wondering whether or not to go for the latest release of Oracle BI Apps. The decision surprisingly is taken without much consideration. Through this blog, the attempt is to highlight the need for such upgrades, and the options available once it's decided to go for the upgrade. 

Upgrading OBIA

There can be various reasons for an organization to consider upgrading to a more recent version of the Oracle BI Apps release. The more prominent amongst those are listed below.

  • Upgrade of old Transactional Systems
  • Leveraging features and enhancements of a newer version
  • Increased maintenance costs due to discontinuation of support
  • Business requirements

Key Considerations about OBIA Upgrade

Although, there are quite a few points on which the whole cost-benefit analysis of whether or not to go for an upgrade can be done, there are a few key considerations that have to be looked at before and during the upgrade process to ensure its success.

  1. It is imperative to realize that the upgrade process is not just a technical process rather would involve significant planning and involvement of different teams
  2. A rationalization exercise, which serves as a precursor to the actual update process, is recommended. This helps to limit the scope of the upgrade along and allows the technical team to perform an analysis of the existing customizations against the newer content available and define their relevance
  3. Depending on the upgrade path available, the upgrade process would either be in-place or out-of-place. Regardless of the upgrade type, a good strategy is to have Before-and-After environments setup for detailed validations and benchmarking

OBIA Upgrade Paths

Oracle provides multiple upgrade paths to upgrade from one version of BI Apps to another be it either BI Apps 10g or 11g.  In the end the path chosen has to be done after a thoroughly understanding the costs and benefits associated to each. 

OBIA 10G Upgrade Paths

10g Upgrade Paths Edited.jpg

View image

Illustrated above are the various options available provided by Oracle for upgrade within the 10g umbrella. It is essential to note that there is no supported upgrade path from OBIA 10g to OBIA 11g. The only possible way is through a complete re-implementation.

OBIA 11G Upgrade Paths

11g Upgrade Paths Edited.jpg

View image

Illustrated above are the various options available provided by Oracle for upgrade within the 11g umbrella. It is essential to note that there is no supported upgrade path from OBIA 10g to OBIA 11g. The following are the points to be considered


  • Upgrade to BI Apps 11.1.1.8 requires OBIEE 11.1.17 with the minimum BP as 11.1.1.7.131017 as a minimum 
  • Upgrade to BI Apps 11.1.1.9.2 is supported from either OBIA 11.1.1.8.1 PB6 or OBIA 11.1.1.9.1. To get to OBIA 11.1.1.8.1 PB6 there are two approached
  1. If the data has already been loaded in an existing instance and a full load is not advisable, then the path is 
  2. 11.1.1.8.1 -> 11.1.1.8.1 PB3 -> 11.1.1.8.1 PB6
  3. If data hasn't been loaded or is not required to be upgraded, then the path is
  4. 11.1.1.8.1 -> 11.1.1.8.1 PB6
  • Upgrade to OBIA 11.1.1.9.2 from 11.1.1.9.1 consists of upgrading 
  1. Platform components
  2. BI Apps binaries
  3. RPD, Catalog and JAZN files
  4. ODI repository contents
  5. Since there is no new content in 11.1.1.9.2 compared to 11.1.1.9.1 there is no data warehouse upgrade required
  • Upgrade to 11.1.1.10.1 from 11.1.1.9.2 includes upgrade of
  1. Platform components
  2. BI Apps binaries
  3. BI Apps Component repository (BIACOMP)
  4. RPD, Catalog and JAZN files
  5. ODI repository contents
  6. Business Analytics Warehouse
  7. Migration of existing data

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles