1/12

Contents

Title and Copyright Information

Preface

• Functional Setup Manager - Statement of Direction
• Audience
• Documentation Accessibility
• Diversity and Inclusion
• Related Documents
• Conventions

1 Oracle BI Applications Architecture and Installation Overview

• Oracle BI Applications Architecture
• Oracle BI Applications Installation Roadmap

2 Preinstallation and Deployment Requirements for Oracle BI Applications

• General Guidelines for Setting Up Databases for Oracle BI Applications
  • Guidelines for Setting Up Oracle Business Analytics Warehouse Databases
  • Why Use a Separate Database for the Oracle Business Analytics Warehouse?
• Oracle-Specific Database Guidelines for Oracle Business Analytics Warehouse
  • General Guidelines for Oracle Databases
  • Guidelines for Using Oracle Template Files

3 Installing and Setting Up Oracle BI Applications

• Hardware Requirements
• Installation Prerequisites for Oracle BI Applications
• Install and Configure Oracle BI Applications
  • Install JDK
  • Install Oracle Fusion Middleware Infrastructure (WebLogic Server)
  • Install Oracle Analytics Server
  • Create Schemas Using RCU
  • Install Oracle Data Integrator
  • Install Oracle BI Applications
  • Create Schemas for Oracle BI Applications
  • Set the BIAPPS Schema User Password as Unlimited
  • Apply Mandatory Patches
  • Configure Oracle Analytics Server
  • Edit Your Input File
  • Configure Oracle BI Applications
  • Configure Oracle BI Applications with Oracle Autonomous Data Warehouse
  • Load Translation Data
  • Configuring Oracle Data Integrator Studio
    • Configuring Authentication
    • Setting the JPS Config File Location
    • Starting Oracle Data Integrator Studio
    • Connecting to the Master Repository
    • Regenerating the Security Files
  • Using a RAC Database
  • Use an External LDAP
  • Configure Oracle BI Applications for High Availability
    • Configure High Availability with Automated Scripts
    • Configuring High Availability with Manual Steps
    • Configuring High Availability for ODI
    • Configuring Oracle HTTP Server for High Availability
    • Performing Post-Configure Steps for High Availability
    • Creating BI Schemas Using RCU with a RAC Database
• Uninstalling Oracle BI Applications

4 Performing Post-Installation System Setup Tasks

• Setting the Business Analytics Warehouse Connection in Oracle Data Integrator
• Performing Setup Steps for On-Premises Oracle Fusion Applications Sources
  • Creating a User for ETL
  • Configuring the Oracle BI Repository for ETL
• Registering Source Systems and Propagating Connection Details to Oracle Data Integrator
• Enabling Offerings for Deployment
• Setting Languages for Data Load into the Business Analytics Warehouse
• Running the Domains Load Plan
• Mapping Externally Conformed Domains
• User Access to Configuration Manager, FSM, and Oracle Data Integrator
• Editing Preferred Currency Display Names and Enabling Document Currency
• Enabling Initialization Blocks
• Trimming the Repository
  • Extracting Projects From Full Repository
  • Merging Repositories
• Next Steps After Setup — Functional Configuration

5 Setting Up Fusion Applications Cloud Data Sources

• Overview of Oracle Fusion Applications Cloud Source System Support
• Fusion Applications Cloud Source System Deployment Options
• Fusion Application Cloud Source System Deployment Roadmap
• Creating Service Requests for Oracle Business Intelligence Cloud Connector Console
• Provisioning a User for Export and Import of BI Data from Fusion UCM
• Provisioning a User for Oracle BI Cloud Connector Console Access
• Registering the Fusion Applications Source
• Creating a Load Plan and Specifying Offerings and Fact Groups to Load
• Extracting Data into Universal Content Management using Oracle BI Cloud Connector Console
• Synchronizing Deletes for a Cloud Extract
• Configuring Proxy Settings for WebLogic Server
• Managing Fusion Flex Extensions in Release 11.1.1.10.3
• Setting Up Key Flex Fields for Financials Fusion Applications Source Data
  • Using Oracle BI Cloud Connector Console to Configure Cloud Extract
  • Using ODI to Set Up Key Flex Fields
• Setting Up Key Flex Fields for HCM Fusion Applications Source Data

6 Setting Up Oracle Taleo Cloud Data Source

• Registering a Taleo Cloud Source System

7 Deploying the ODI Repository for Non-Oracle Source Databases

• Exporting Security Settings from Original ODI Repository
• Exporting Topology Settings from Original ODI Repository
• Creating a New Master Repository
• Connecting to the New Master Repository
• Creating a New Work Repository
• Importing Source Adaptor Metadata Content into the New ODI Repository
  • Preparing to Import Source Adaptor Metadata Content
  • Running the Command Line Utility to Import Source Adaptor Metadata Content
• Importing Security Settings in to the ODI Repository
• Importing Connection Details that Configure the Data Servers

A Generating DDL and Assigning Tablespaces to Tables and Indexes

• Overview of Oracle Business Analytics Warehouse Tables
• Generating the Oracle Business Analytics Warehouse DDL
• Oracle BI Applications Patches
• Assigning Tablespaces

B Integrating Dashboards and Siebel Applications

• Overview of Embedding Oracle Analytics in Siebel Application
• Configuring Oracle HTTP Server
• Updating the Siebel Application to Find Oracle Analytics Server Through HTTP Server
• About Configuring Action Links
• Accessing Optional Analytics Applications
• Customizing Oracle BI Applications Home Page and Dashboards
  • Configuring a New Home Page to Use a Symbolic URL
  • Determining the Oracle Analytics Report Path Argument
  • Adding Views for Custom Dashboards
• Viewing Preconfigured Dashboards
  • Exposing Dashboards and Requests
  • Locating Dashboards, Page Names, and Reports