1/41

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Upgrade Process – Overview and Prerequisites

• Overview of Upgrade Process
• Upgrade Prerequisites
  • Upgrading Oracle BI Enterprise Edition From 11.1.1.7.0 to 11.1.1.9.0
  • Upgrading ODI From 11.1.1.7.0 To 11.1.1.9.0

2 Oracle BI Applications Infrastructure, Metadata, and Schema Updates

• Downloading Oracle BI Applications 11.1.1.10.2 Software and Files
• Upgrading Oracle BI Applications Binaries to Release 11.1.1.10.2
• Applying Fusion Middleware Platform Patches for Oracle BI Applications 11.1.1.10.2
• Upgrading BIACOMP Schema
• Upgrading the JAZN File
• Upgrading the Repository
• Upgrading the Oracle Data Integrator Repository
  • Creating a Backup of the 11.1.1.10.1 ODI Repository
  • Exporting Content from the 11.1.1.10.1 ODI Repository
  • Noting the ID of the 11.1.1.10.1 ODI Repository
  • Dropping the 11.1.1.10.1 ODI Repository Schema
  • Creating the ODI Repository for Oracle BI Applications 11.1.1.10.2
  • Copying Source Files for Upgrading
  • Importing Content into the 11.1.1.10.2 ODI Repository
  • Running Scripts by Connecting to the Upgraded ODI Repository Schema
  • Reconfiguring External Authentication
  • Regenerating Load Plans
• Importing and Applying ETL Customizations
  • Importing Datastores
  • Importing Customized ETL tasks

3 Oracle Business Analytics Warehouse Schema and Data Upgrades

• Performing Pre-Upgrade Tasks
• Granting New Required Privileges to <prefix>_DW
• Upgrade Oracle Business Analytics Warehouse Schema and Data
• Performing Post-Upgrade Tasks
• Running the Source Upgrade Load Plan

A New ETL Content in Oracle BI Applications 11.1.1.10.2

• Financials
• Procurement and Spend
• Manufacturing
• Supply Chain Management
• Human Capital Management