Index

A B C D E F H I L N O P R S T U W

Symbols

$ODI_HOME, 4.4.2.1

A

Agents

ODI log file, 4.6.15

Selecting an agent, 4.5.3, 4.5.3

When to select the INTERFACE Agent, 4.5.3, 4.5.3

Applications product families

Oracle Financial Analytics, 7

Oracle Human Resources Analytics, 9

Oracle Procurement and Spend Analytics, 6, 6, 6, 8

Oracle Supply Chain and Order Management Analytics, 8

AR Aging calculations

including UnApplied Payments, 7.2.4.1

attributes

historically significant attributes, identifying, 11.4.4.1

Automated Database Statistics Collection, 4.6.5

Automated Delete Handling, 4.6.6

B

biapps_odi.zip

about, 4.4.2.2

unzipping, 4.4.2.2

biappstx_setup.sql

running, 4.5.8.2

C

calculations

including UnApplied Payments in AR Aging calculations, 7.2.4.1

Catalog Manager

using, 2.5

code lookup

about, 11.5.1.1

code mappings, 11.5.1.1.2

W_CODES table, 11.5.1.1.1

code page

environments, 4.3.2

Code Page requirements, 4.3.2

configuration

Language Environment, 4.3.3.3

Oracle Financial Analytics, 7

Oracle Human Resources, 9

Oracle Procurement and Spend Analytics, 6, 6, 6, 8

Oracle Supply Chain and Order Management Analytics, 8

configuration steps

controlling data set

Oracle Financial Analytics, 7, 7.2.4

Oracle Human Resources Analytics, 9

Oracle Procurement and Spend Analytics, 6

Oracle Supply Chain and Order Management Analytics, 8, 8

source independent, 5

Oracle BI Repository, 10

required before full load

Oracle Financial Analytics, 7

Oracle Human Resources Analytics, 9

Oracle Procurement and Spend Analytics, 6

Oracle Supply Chain and Order Management Analytics, 8, 8

source independent, 5

configuring

fiscal calendar, 5.1.3.5

connection details

modifying, 4.6.4

connections

in Oracle BI Applications Configuration Manager, 4.5.8.8

Contexts, 4.1, 4.6.10

Test to Production, 4.6.10

cost-based optimizer

parameters, 3.1

cross-module configuration, performing

codes lookup, 11.5.1.1

dimension keys, resolving, 11.5.1.2

domain values, working with, 11.5.2

loads, configuring, 11.4.3

records, filtering and deleting, 11.4.3.1

slowly changing dimensions, changing, 11.4.4

CSV file

delimiter, 11.4.2.2

Customer Status History Fact table

about, 8.2.11.8

configuring, 8.2.11.9

customization, 11.1.3

adding an index, 11.5.3

and patch installation, 11.1.3

category 1, 11.2

category 2, 11.3

category 3, 11.4

Domain Values, 11.5.2

overview, 11.1

Stored Lookups, 11.5.1

D

dashboards

viewing a list of, 2.5

data

loading with E-LT, 4.7

Data Movement Mode, 4.3.2

data movement mode, 4.3.2

database accounts

for installation, 4.3.3.1

database requirements, 4.3.3.1

DataMovementMode parameter, 4.3.2

DATASOURCE_NUM_ID

about, 5.1.6.1

configuring, 5.1.6.1

DBLink Procedure

creating, 4.5.7.4

debug mode

Oracle BI Applications Configuration Manager, 4.5.8.7

debugging

list of log files, 4.6.15

delimiter

for CSV file, 11.4.2.2

deployment

roadmap, 2.4

topology example, 4.1

dimensions

key resolution, using a lookup, 11.5.1.2.1

keys, resolving, 11.5.1.2

documentation

Repository Documentation feature, 2.5

domain values

domain value conversion process, understanding, 11.5.2.1

domain value set, configuring, 11.5.2.5

domain value set, extending, 11.5.2.3

importance, understanding, 11.5.2.2

working with, 11.5.2

E

E-LT

Execution Plans, 4.7.1

Master Packages, 4.7.1

performing, 4.7

Using ODI Designer, 4.7.3

Using Oracle BI Configuration Manager, 4.7.2, 4.7.2

E-LT Parameters

managing, 4.6.3.3

EnterpriseBusinessAnalytics.zip, 4.4.1

environment variables

NLS_LANG, 4.3.3.3.1

error messages

list of log files, 4.6.15

extracts, configuring

extracting additional data, about, 11.4.2.1

extracting data from new source table, 11.4.2.1.2

extracting new data from existing source table, 11.4.2.1.1

F

fiscal calendar

configuring, 5.1.3.5

fiscal month

configuring, 5.1.3.5

fiscal week

configuring, 5.1.3.5

Flexfields

NUM_PARTITIONS_INCR, 4.6.9.1.1

Flow Control

activating and deactivating, 4.6.14

folders

lkpfiles, 4.4.2.2

srcfiles, 4.4.2.2

H

historically significant attributes

identifying, 11.4.4.1

I

infrastructure requirements, 4.3.1

init10gR2.ora

about, 3.1

parameters in, 3.1

unzipping, 4.4.2.2

installation

database accounts required for, 4.3.3.1

Oracle BI Applications installation process task list, 4.2

Oracle Business Intelligence Applications, 4.4.1

Oracle Data Integrator, 4.4.2

pre-installation tasks, 4.3

installation and setup

roadmap, 4.2

Installation and setup task list, 4.2

installing

Oracle BI repository, 10.1

INTERFACE Agent

When to select, 4.5.3, 4.5.3

L

Language Environment

configuration, 4.3.3.3

lkpfiles folder, 4.4.2.2

about, 4.4.2.2

loads, configuring

about, 11.4.3

log files

agentservice.log, 4.6.15

calcStatsFile_name.log, 4.6.15

dropTableFile_name.log, 4.6.15

for Oracle BI Applications Configuration Manager, 4.5.8.7

indexFile_name.log, 4.6.15

list, 4.6.15

truncateFile_name.log, 4.6.15

N

NLS_LANG

environment variable, 4.3.3.3

NLS_LANG environment variable, 4.3.3.3.1

NUM_PARTITIONS_INCR FlexFields, 4.6.9.1.1

O

ODI

metadata repository, 4.3.3.1

Oracle Home location, 4.4.2.1

repository database, 4.3.3.1

ODI Agents

log file, 4.6.15, 4.6.15

running as a Windows service, 4.5.3

running on Unix, 4.6.11

odiparams.bat/.sh file

configuring, 4.5.2

modifying passwords, 4.6.4

Oracle BI Administration Tool

using to generate Repository Documentation, 2.5

Oracle BI Applications

installation and configuration process task list, 4.2

Oracle BI Applications Configuration Manager

biappstx_setup.sql file, 4.5.8.2

creating connections, 4.5.8.8

E-LT, 4.7.2

launching, 4.5.8.6

Launching in debug mode, 4.5.8.7

log files, 4.5.8.7, 4.6.15

set up, 4.5.8

setup on UNIX and Linux, 4.5.8.4

setup on Windows, 4.5.8.3

Oracle BI Configuration Manager

debug mode, 4.5.8.7

Oracle BI EE

infrastructure requirements, 4.3.1

requirements, 4.3.1

Oracle Business Analytics Warehouse

about, 2.2

architecture, 2.3

architecture components, 2.3.1

database, 4.3.3.1

Oracle Business Intelligence Applications

about, 2.1

Oracle Data Integrator

home directory, 4.4.2.1

Oracle database

cost-based optimizer, 3.1

NLS_LANG, 4.3.3.3.1

parameters, 3.1

Oracle Financial Analytics, 7

configuration steps before full load, 7.2

overview, 7.1

Oracle Human Resources

configuration steps before a full load, 9

overview, 9

Oracle Order Management and Fulfillment Analytics

configuration steps before a full load, 8.1

overview, 8.1

Oracle Procurement and Spend Analytics, 6, 6, 8

configuration steps before full load, 6.2

overview, 6.1, 6.2

OracleBIAnalyticsApps.rpd

configuring, 10

username

OracleBIAnalyticsApps.rpd, 10

P

package

Truncate All Tables, 11.3.3.2.3

parameters

E-LT, 4.6.3.3

init10gR2.ora, 3.1

partitioning

an example, 4.6.9.2

data warehouses, 4.6.9

re-partitioning, 4.6.9.6

passwords

BI Administration Tool, 10

encoding, 4.6.4

Oracle BI Configuration Manager, 4.6.4

reset, 4.6.4

patch installation

impact on customizations, 11.1.3

Payroll table, about aggregating, 9.2.26.1

PERIOD

about, 8.2.11.8

pre-installation tasks, 4.3

Presentation Catalog

unzipping, 4.4.1

Presentation Services Catalog

viewing, 2.5

primary extract and delete mapping

delete and primary extract sessions, enabling, 11.4.3.3.2

source-archived records, deletion configuration, 11.4.3.3.1

working with, 11.4.3.3

primary extract and delete mappings

understanding, 11.4.3.2

working with, 11.4.3.3

R

records

filtering and deleting, 11.4.3.1, 11.4.3.2, 11.4.3.3

source-archived records, deletion configuration, 11.4.3.3.1

repository, 10.1

Oracle BI repository, setting up, 10.1

Repository Documentation

generating, 2.5

using BI-EE, 2.5

requirements

database, 4.3.3.1

infrastructure, 4.3.1

Oracle BI EE, 4.3.1

resetting passwords, 4.6.4

roadmap

application configuration, 4

Configuring Common Areas and Dimensions, 5

Configuring Oracle Financial Analytics, 7

Configuring Oracle Human Resources Analytics, 9

Configuring Oracle Procurement and Spend Analytics, 6

Configuring Oracle Supply Chain and Order Management Analytics, 8

customization, 11

deployment, 2.4

installation and setup, 4.2

overview, 2

preinstallation, 3

pre-installation tasks, 4.3

What's New in Version 7.9.5.2, 1

RPD

configuration, 10

S

set up

component set up, 4.5

slowly changing dimensions, configuring

about, 11.4.4

effective dates, 11.4.4.2.3

historically significant attributes, identifying, 11.4.4.1

Type I changing dimension, 11.4.4.2

Type II slowly changing dimension, 11.4.4.2.2

source-archived records

deletion configuration, 11.4.3.3.1

srcfiles folder, 4.4.2.2

Supply Chain and Order Management Analytics

domain values and CSV worksheet files, 6.2.3

T

Test to Production, 4.6.10

topology

deploying Oracle BI Applications, 4.1

example, 4.1

Truncate All Tables package, 11.3.3.2.3

U

UnApplied Payments

Using in AR Aging calculations, 7.2.4.1

unzipping, 4.4.1

W

WH_DATASOURCE_NUM_ID

about, 8.2.11.8

Work Repository

customization and patch application, 11.1.3