You are currently viewing Accessing flexfields in OTBI Analytics
Accessing flexfields in OTBI Analytics

When we configure the flex fields we check the BI Enabled flag for the flex field to be used in OTBI analysis.

Table of Contents

Setting Extensible Flexfields as BI-Enabled: Procedure

Extensible flexfields are BI enabled if at least one segment in a context is BI enabled.

Setting Extensible Flexfields as BI-Enabled

To set extensible flexfields as BI-enabled:

  1. Navigate to Setup and Maintenance.
  2. Navigate to Manage Extensible Flexfields.
  3. Enter the extensible flexfield name; for example, Organization Information EFF.
  4. Select the applicable extensible flexfield, and then click Edit.
  5. Select the applicable Category. The category contexts are populated automatically.
  6. Click Manage Contexts
  7. In the Edit Context page, select the applicable Context, and then click Edit.
  8. Select the applicable Segment, and then click Edit.
  9. In the Edit Segment page, select the BI Enabled check box at the bottom of the screen.
  10. Click Save.

Once the BI Enabled box is checked and the flexfield is deployed, we need to run the process “Import Oracle Fusion Data Extensions for Transactional Business Intelligence” for the flexfield segments to be available in their corresponding subject areas.

Below are the steps to run the process:

Running the Import Scheduled Process: Procedure

To import changes, run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence scheduled process.

Running the Job

To run the process:

  1. In the Scheduled Processes window, select Search and Select: Name.
  2. Select Search and Select: Name.
  3. Highlight Import Oracle Fusion Data Extensions for Transactional Business Intelligence.
  4. Click OK.
  5. Schedule the process.

Process Status Conditions

The process status displays one of the following conditions:

  • INIT: The process has just begun and is waiting for the extender command line JAR to update the status with more details.
  • COMPLETED_NO_EXTENSION_NEEDED: No new Flex changes were detected in any of the Oracle Applications Cloud sources; because the Oracle Business Intelligence is already synchronized with all Flex changes, no changes were made in the Oracle Business Intelligence.
  • COMPLETED: Oracle Business Intelligence was successfully updated with Flex changes and uploaded into the Oracle Business Intelligence Server.
  • COMPLETED: PROCESS_ERRORS: Oracle Business Intelligence was updated with the Flex changes but with some warnings that require manual intervention.
  • FAILED: Error conditions exist that require manual intervention.

Successful Import Process

If the import process is successful, you can perform the following actions:

  • Query subject areas by segment dimensions such as Balancing Segment and Cost Center.
  • Access DFF attributes for analyses.

For more details, please refer the oracle documentation at

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.