Overview of Upgrade Process

Upgrade of Oracle BI Applications from release 11.1.1.10.1 to 11.1.1.10.2 includes upgrades to components, repositories (schema and content), and data.

To upgrade Oracle BI Applications release 11.1.1.10.1 to 11.1.1.10.2, you must upgrade the following:

  • Platform components

  • Oracle BI Applications binaries

  • Oracle BI Applications Component Repository (BIACOMP)

  • the JAZN file, the repository, and Presentation Catalog

  • Oracle Data Integrator (ODI) repository content (BIA_ODIREPO)

  • Oracle Business Analytics Warehouse (DW) - schema

  • Data migration of existing data in the Oracle Business Analytics Warehouse

Note:

The upgrade from Oracle BI Applications 7.9.6.x to Oracle BI Applications 11.1.1.10.2 is not supported. Additionally, upgrade from Oracle BI Applications for Oracle Fusion Applications (11.1.1.5.x to 11.1.1.7.0 or 11.1.1.8.0) is not supported.

Upgrade Process Flow

Perform the following steps to upgrade Oracle BI Applications 11.1.1.10.1 to 11.1.1.10.2:

  1. Complete the upgrade prerequisites.

  2. Run the Oracle BI Applications 11.1.1.10.2 installer to upgrade the Oracle BI Applications binaries from release 11.1.1.10.1 to 11.1.1.10.2.

  3. Apply the Oracle Fusion Middleware patches for Oracle BI Applications 11.1.1.10.2.

  4. Use the Patch Set Assistant (PSA) tool to upgrade BIACOMP schema (ATGLite, FSM, BIACM and BIACM_IO component upgrades).

  5. Run script to upgrade deployment changes in Oracle BI Applications 11.1.1.10.2.

  6. Use the BI Update Metadata tool to upgrade the JAZN.

  7. Upgrade the repository and Presentation Catalog.

  8. Apply client-side patches.

  9. Upgrade the ODI Repository metadata (content).

  10. Upgrade Oracle Business Analytics Warehouse schema and Migrate Data in Data Warehouse.