Enabling Extensive Flexfields in Oracle Fusion Analytics Warehouse Part 1

September 20, 2022 | 5 minute read
Krishna Prasad Kotti
Senior Member of Technical Staff
Krithika Raghavan
Director, Oracle Analytics
Text Size 100%:

This article applies to Fusion Analytics Warehouse release 22R3 and walks you through the step-by-step process of enabling Extensible Flexfields in Fusion Analytics. This is the first article in a two-part series. 

Deciding on the flexfield structure is important in any organization implementing Oracle Cloud Applications. An extensible flexfield is similar to a descriptive flexfield in that it provides a customizable expansion space that implementors, such as Oracle Cloud Applications customers, can use to configure additional attributes (segments) without additional programming. Once extensible flexfields are enabled, it's essential that they're available for reporting.

Enable Extensible Flexfields

1.    Log in to Oracle Cloud Applications.

2.    In Settings and Actions, click Setup and Maintenance.

Set up and Maintenance













3.    Click Search and navigate to Manage Extensible Flexfields.

Manage Extensible Flexfields


Manage Extensible Flexfields02


4.    Click Edit.

Edit Flexfield


5.    Click Manage Contexts.

6.    Click Search and Edit Context.

Edit Context01


Edit Context02

7.    Ensure that View Privileges within Context Usages is set to None.

View Privileges

8.    In Context Sensitive Segments, click Edit.

Context Sensitive Segments

9.    Ensure that BI Enabled is checked under Business Intelligence.

BI Enabled

10.    Save your changes and repeat these steps for all Context Sensitive Segments and for all Segments.

Repeat Steps

11.Click Deploy Flexfield.

Deploy Flexfields





The Flexfield should be deployed without any errors.



12.    Log in to Oracle Transactional Business Intelligence (OTBI) and confirm that flexfields are available in the subject areas.




13.    Create a report with all these flexfields and capture the OTBI logs.

14.    Based on the logs, find the attribute names and VO name. 

The VO name is used in Fusion Analytics Warehouse to create Data Augmentation, which is covered in the second article of the series. 

OTBI Log01


OTBI log02

By following these steps, you've enabled and verified an extensive flexfield.

You can proceed to configuring the extensive flexField in Fusion Analytics Warehouse, as describedin the second article in this series.

Schedule a meeting today to talk to the Oracle Analytics product team and learn more about how you can deploy Oracle Fusion Analytics Warehouse. 


Krishna Prasad Kotti

Senior Member of Technical Staff

Krithika Raghavan

Director, Oracle Analytics

Previous Post

How to leverage custom scripts in your Oracle Analytics Cloud data flow

Gabrielle Prichard | 5 min read

Next Post

Enabling Extensive Flexfields in Fusion Analytics Warehouse Part 2

Krishna Prasad Kotti | 4 min read