1/18
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
New Features for Oracle BI Applications Installation
New Features for Oracle BI Applications 11g Release 1 (11.1.1.8.1)
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
Oracle-Specific Database Guidelines for 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
Installing and Configuring Oracle BI Applications
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
3.3.10
Applying the ODI Studio Patch
3.3.11
Copying Source Files
3.3.12
Next Steps
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.3
Registering Source Systems and Propagating Connection Details to Oracle Data Integrator
4.4
Enabling Offerings for Deployment
4.5
Setting Languages for Data Load into the Business Analytics Warehouse
4.6
Running the Domains Load Plan
4.7
Mapping Externally Conformed Domains
4.8
Granting Users Access to Configuration Manager, FSM and Oracle Data Integrator
4.9
Editing Preferred Currency Display Names and Enabling Document Currency
4.10
Enabling Initialization Blocks
4.11
Trimming the RPD
4.11.1
Extracting Projects From Full RPD
4.11.2
Merging Repositories
4.12
Setting Up Fusion Applications Cloud Data Sources
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
4.13
Next Steps
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
6.6
Enabling External Authentication
6.7
Importing Security Settings Into the ODI Repository
6.8
Configure the Data Servers
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
Select Components
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.5
Schema Passwords
A.6
Custom Variables
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
Map Tablespaces
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
A.8
Summary
A.9
Completion Summary
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
Viewing Information About Preconfigured 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
F.1
About Preconfigured Mappings for Siebel System Subject Area
G
Available Languages for Oracle BI Applications Release 11.1.1.8.1
G.1
Available Languages for Release 11.1.1.8.1
Index
Scripting on this page enhances content navigation, but does not change the content in any way.