Select Descriptive Flex Fields and Map Attributes

As a functional administrator, select and add theprebuilt descriptive flex fields (DFFs) and their attributes to your Autonomous Data Warehouse using the DFF Attribute Mapper.

While selecting and adding the prebuilt DFFs and their attributes, you must ensure that they are BI-enabled. The BI-enabled DFFs are registered in the database as enabled for Oracle Business Intelligence (BI) and include a BI-enabled setting for each of its segments. When a global, context, or context-sensitive segment is BI-enabled, it's available for use in Oracle Business Intelligence. If you select any attribute that isn't BI-enabled, then your extraction and downstream data augmentation may fail.

After adding the DFFs such as Invoice and Payment Information along with their attributes, you can use the data from the added DFFs to augment the data from the source or enrich the data available in the Autonomous Data Warehouse. The ability to select the attributes that you need enables you to avoid pipeline failures and slow performance.

While searching for the prebuilt DFFs, filter the DFFs by functional areas or applications from the source system to view a smaller set. View the details of the flex field using the Details tab. You can add selected attributes or add all available attributes using the Add all attributes option.

  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Configurations, click Custom Data Configurations.
  4. On the Custom Data Configurations page, click Create, and then select Descriptive Flex Fields.
  5. On the Descriptive Flex Fields page, click Actions for a descriptive flex field that you want to add attributes.
  6. In Actions, click Edit to select attributes
  7. In the descriptive flex field dialog, select the check box for the attributes that you want to add and then click Done.
  8. After adding attributes to the descriptive flex fields that you want, click Save on the Descriptive Flex Fields page.