Contents

New Features for Oracle BI Applications Installation

1 Oracle BI Applications Architecture and Installation Overview

• 1.1 Oracle BI Applications Architecture
• 1.2 Oracle BI Applications Installation Roadmap

2 Preinstallation and Deployment Requirements for Oracle BI Applications

• 2.1 General Guidelines for Setting Up Databases for Oracle BI Applications
  • 2.1.1 Guidelines for Oracle Business Analytics Warehouse Databases
  • 2.1.2 Why Use a Separate Database for the Oracle Business Analytics Warehouse?
  • 2.2.1 General Guidelines for Oracle Databases
  • 2.2.2 Using Oracle Template Files

  3 Installing and Setting Up Oracle BI Applications

  • 3.1 Hardware Requirements
  • 3.2 Installing Prerequisites for Oracle BI Applications
    • 3.2.1 Installing JDK or JRockit
    • 3.2.2 Installing Oracle WebLogic Server
    • 3.2.3 Running Fusion Middleware RCU
    • 3.2.4 Installing Oracle Business Intelligence Enterprise Edition 11g
    • 3.2.5 Configuring Oracle Business Intelligence
    • 3.2.6 Upgrading to WebLogic Server 10.3.6
    • 3.2.7 Installing Oracle Data Integrator
    • 3.3.1 Creating Database Instances for Schemas and Repositories
    • 3.3.2 Creating Schemas Using Business Analytics Applications Suite RCU
    • 3.3.3 Installing Oracle BI Applications Using the Business Analytics Applications Suite Installer
    • 3.3.4 Applying Platform Patches
    • 3.3.5 Updating ATGLite
    • 3.3.6 Updating FSM
    • 3.3.7 Configuring Oracle BI Applications
    • 3.3.8 How to Start the BI and Oracle Data Integrator Managed Servers
    • 3.3.9 Installing ODI Studio
      • 3.3.9.1 Installing ODI Studio
      • 3.3.9.2 Configuring User Access for ODI Studio

      4 Performing Post-Installation System Setup Tasks

      • 4.1 Setting the Business Analytics Warehouse Connection in Oracle Data Integrator
      • 4.2 Performing Setup Steps for On-Premise Fusion Applications Sources
        • 4.2.1 Creating a User for ETL
        • 4.2.2 Configuring the Oracle BI Repository for ETL
        • 4.11.1 Extracting Projects From Full RPD
        • 4.11.2 Merging Repositories
        • 4.12.1 Overview
        • 4.12.2 Cloud Adaptor Deployment Options
        • 4.12.3 About the Cloud Adaptor Deployment Process
        • 4.12.4 Cloud Adaptor Deployment Roadmap
        • 4.12.5 Create a Service Request to Deploy Fusion Cloud Adaptor
        • 4.12.6 Provision a User For Export and Import of BI Data
        • 4.12.7 Register the Fusion Applications Source
        • 4.12.8 Create FA SDS Schema
        • 4.12.9 Configure UCM Server in ODI
        • 4.12.10 Configure Proxy Settings for WebLogic Server

        5 Setting Up Key Flex Fields for Financials Cloud Adaptor

        • 5.1 Using Oracle BI Applications Configuration Manager to Configure Cloud Extract
        • 5.2 Using ODI to Set Up Key Flex Fields
        • 5.3 Additional Steps for Fusion Financials Implementations

        6 Deploying the ODI Repository for Non-Oracle Source Databases

        • 6.1 Exporting Security Settings from Original ODI Repository
        • 6.2 Creating a New Master Repository
        • 6.3 Connecting to the New Master Repository
        • 6.4 Creating a New Work Repository
        • 6.5 Importing Source Adapter Metadata Content into the New ODI Repository
          • 6.5.1 Preparing to Import Source Adapter Metadata Content
          • 6.5.2 Running the Command Line Utility to Import Source Adapter Metadata Content
          • 6.5.3 Add an ODI Administrator User

          A Repository Creation Utility Screens

          • A.1 Welcome
          • A.2 Create Repository
          • A.3 Database Connection Details
            • A.3.1 Specifying Connection Credentials for Oracle Databases and Oracle Databases Enabled for Edition-Based Redefinition
            • A.3.2 Specifying Connection Credentials for Oracle MySQL Databases
            • A.3.3 Specifying Connection Credentials for Microsoft SQL Server Databases
            • A.3.4 Specifying Connection Credentials for IBM DB2 Databases
            • A.4.1 Creating Database Users for IBM DB2 Databases
            • A.4.2 Creating Prefixes
            • A.4.3 Selecting Components and Dependencies
            • A.4.4 Specifying Custom Schema Names
            • A.4.5 Checking Schema Prerequisites
            • A.4.6 Dropping Schemas
            • A.6.1 Specifying Custom Variables for Oracle Business Intelligence Applications
            • A.6.2 Specifying Custom Variables for Master and Work Repository (ODI)
            • A.6.3 Specifying Custom Variables for Oracle WebCenter Portal's Activity Graph and Analytics
            • A.7.1 Default Tablespace Mappings
            • A.7.2 Changing Default and Temporary Tablespaces
            • A.7.3 Viewing and Changing Additional Tablespaces
            • A.7.4 Managing Tablespaces and Datafiles
              • A.7.4.1 Adding, Modifying, and Removing Tablespaces
              • A.7.4.2 Adding, Modifying, and Removing Datafiles

              B Installer Screens Common to All Oracle Fusion Middleware Suites

              • B.1 Specify Inventory Location
              • B.2 Inventory Location Confirmation
              • B.3 Welcome
              • B.4 Prerequisite Checks
              • B.5 Security Updates
              • B.6 Software Updates
              • B.7 Installation Location
              • B.8 Application Server
              • B.9 Summary
              • B.10 Installation Progress
              • B.11 Configuration Progress
              • B.12 Complete

              C Oracle BI Applications Installation and Configuration Screens

              • C.1 Welcome (When Running Business Analytics Applications Suite Installer)
              • C.2 Specify Installation Location (When Running Business Analytics Applications Suite Installer)
              • C.3 Welcome (When Running the configApps.bat/sh File)
              • C.4 Extend BI Domain
              • C.5 Specify Installation Location (When Running the configApps.bat/sh File)
              • C.6 Configure Components
              • C.7 RPD Encryption Password
              • C.8 BI Applications Administrator User
              • C.9 MDS Schema
              • C.10 BI Applications Components Repository Schema
              • C.11 Business Analytics Warehouse Schema
              • C.12 BI Applications ODI Repository Schema
              • C.13 Configure Ports

              D Generating DDL and Assigning Tablespaces to Tables and Indexes

              • D.1 Overview
              • D.2 Generating the Business Analytics Warehouse DDL
              • D.3 Patching Oracle BI Applications
              • D.4 Assigning Tablespaces

              E Integrating Interactive Dashboards and Siebel Operational Applications Data

              • E.1 Updating the Siebel Operational Application
              • E.2 Reapplying Customized Style Sheets
              • E.3 How to Configure Oracle Business Intelligence with Oracle's Siebel Web Server Extension (SWSE)
              • E.4 Creating a Virtual IP Address for the SWSE and Oracle BI Presentation Services
              • E.5 Testing the Virtual IP Configuration for Oracle Business Intelligence and the SWSE
              • E.6 About Configuring Oracle BI Action Links
              • E.7 Accessing Optional Analytics Applications
              • E.8 Customizing Oracle BI Application Home Page and Dashboards
                • E.8.1 Configure a new Home Page to use a symbolic URL
                • E.8.2 Determine the Oracle BI Report Path Argument
                • E.8.3 Add Views for Custom Oracle BI Interactive Dashboards
                • E.9.1 Exposing Dashboards and Requests
                • E.9.2 Locating Dashboards, Page Names and Reports

                F Preconfigured Mappings for Siebel System Subject Area

                G Available Languages for Oracle BI Applications Release 11.1.1.8.1