Oracle Fusion Application Configuration

The offerings in Oracle Fusion applications are the highest-level groupings of Oracle Fusion applications functionality. They are typically the starting points for configuration decisions, a feature of standardized Oracle Fusion applications functionality that is typically sold, implemented, and serviced as a unit. Transactional Business Intelligence is a required feature of certain Oracle Fusion application offerings. Because Transactional Business Intelligence has a limited set of actual Oracle Fusion setup tasks, the required tasks related to Transactional Business Intelligence are included as subtasks for these Oracle Fusion application offerings. These tasks are documented in the Functional Setup Manager (FSM) as a common set of tasks (see Table 2).

See also:

Table 2. Functional Setup Manager - Transactional Business Intelligence Tasklist

checkmark

TaskDescription
 

Define Transactional Business Intelligence Configuration:

Optimize Transactional Business Intelligence Repository

Configure Transactional Business Intelligence for ad-hoc reporting. Complete this task after all desired Oracle Fusion application offerings are configured:

Trim unused projects from Transactional Business Intelligence repository (Oracle BI repository) file based on configured Oracle Fusion application offerings. See Optimizing the Repository File (RPD) for Transactional Business Intelligence.

 

Define Transactional Business Intelligence Configuration:

Manage Transactional Business Intelligence Connections

Configure Transactional Business Intelligence for ad-hoc reporting. Complete this task after all desired Oracle Fusion application offerings are configured:

Define data source connections in the physical layer of the Transactional Business Intelligence repository file.

Note:

This task is automatically handled through provisioning. See Provisioning Users.

 

Define Transactional Business Intelligence Configuration:

Review security for Transactional Business Intelligence users

Provision Transactional Business Intelligence users and data with appropriate security levels.

See Provisioning Users and Transactional Business Intelligence and Oracle Fusion BI Security`

 

Manage User Currency Preferences in Transactional Business Intelligence

Manage user preferences in display of currency data in Transactional Business Intelligence:

See Coverage for Currency.
 

Manage Oracle Fusion Data Extensions for Transactional Business Intelligence:

Configure Key Flexfields

Review functional Oracle Fusion setups to be used in Transactional Business Intelligence:

Turn on and turn off BI-enabled flag for Key Flexfield segments for use in Transactional Business Intelligence

For a sample query which uses flexfields, see Sample COA Query.

Note:

Key Flexfields are usually implemented as dimensions.

 

Manage Oracle Fusion Data Extensions for Transactional Business Intelligence:

Configure Descriptive Flexfields

Review functional Oracle Fusion setups to be used in Transactional Business Intelligence:

Turn on and turn off BI-enabled flag for Descriptive Flexfield segments for use in Transactional Business Intelligence

 

Manage Oracle Fusion Data Extensions for Transactional Business Intelligence:

Import Essbase Cubes into Transactional Business Intelligence repository

Review functional Oracle Fusion setups to be used in Transactional Business Intelligence:

Import Essbase cubes into Transactional Business Intelligence repository.

Note:

This is required for Oracle Fusion General Ledger and optional for Oracle Fusion Project Portfolio Management.

Transactional Business Intelligence is included as part of the following offerings in Oracle Fusion applications:

The individual tasks for configuring Transactional Business Intelligence are found in Define Transactional Business Intelligence Configuration in the Transactional Business Intelligence application as illustrated below:

Figure 16. OTBI Configuration Tasks Menu

This screen shot displays the OTBI configuration task menu.