Setting Up Flexfields

To load Flexfield data from Fusion Applications into the OTBI-Enterprise data warehouse, you must perform the following configuration steps in the Fusion Applications SaaS environment.

How to Set Up Flexfields to Display in BI Dashboards and Reports

In the Fusion Applications SaaS environment, do the following:
  1. Enable DFF extensions.
    For information on how to enable DFF extensions, refer to the following two documents on My Oracle Support:
    Note: You do not need to run BI Extender again.
    — How To Expose Descriptive Flexfields In Relevant OTBI Subject Areas After They Have Been Configured In Fusion Applications (Doc ID 1478273.1)
    — Fusion Applications Business Intelligence - List of Descriptive Flex Field Mappings (Doc ID 1509316.1)
  2. Use BI Cloud Connector Console to load the View Objects (VOs) listed in the ‘Supported View Objects’ table below:
    1. On the Fusion Applications pod, start BI Cloud Connector Console using a HTTP URL based on the following format: http://<FA OHS Host>:<FA OHS Port>/biacm.
    2. In BI Cloud Connector Console, select the Configure Cloud Extract link on the Tasks pane to display the Configure Cloud Extract dialog.
      Description of GUID-99F3003D-1A24-487F-8E7D-2C1530C44D30-default.gif follows
      Description of GUID-99F3003D-1A24-487F-8E7D-2C1530C44D30-default.gif
    3. Scroll down to the Data Store area.
    4. For each of the View Objects (VOs) listed in the ‘Supported View Objects’ table below, click the Add icon (Add icon) to display the Add Data Store dialog and create a new data store.
      Description of GUID-8E77FA4F-9103-4820-ACBA-25BD594C3A48-default.gif follows
      Description of GUID-8E77FA4F-9103-4820-ACBA-25BD594C3A48-default.gif
The next scheduled Cloud Extract executed by BI Cloud Connector Console will extract these VOs and generate files as required by OTBI Enterprise.
Then, the next scheduled OTBI-E load plan executed by Configuration Manager will download the newly generated FLEX files and load the flexfield changes into the OTBI-Enterprise data warehouse.
Supported View Objects
Presentation Table Name in Fusion Applications Target Table Model Name VO Name

Assignment Extensible Attributes

W_HR_ASSIGNMENT_DS/D

Dim – HR Assignment

HcmTopModelAnalyticsGlobalAM.BaseWorkerAsgDFFBIAM.FLEX_BI_BaseWorkerAsgDFF_VI

Person Extensible Attributes

W_HR_PERSON_DS/D

Dim – HR Person

HcmTopModelAnalyticsGlobalAM.PersonsDFFBIAM.FLEX_BI_PersonsDFF_VI

Person Extensible Attributes

W_HR_PERSON_LEG_DS/D

Dim – HR Person Legislation

HcmTopModelAnalyticsGlobalAM.PersonLegislativeInfoDFFBIAM.FLEX_BI_PersonLegislativeInfoDFF_VI

Position Extensible Attributes

W_HR_POSITION_DS/D

Dim – HR Position

HcmTopModelAnalyticsGlobalAM.PositionCustomerFlexBIAM.FLEX_BI_PositionCustomerFlex_VI

Pay Grade Extensible Attributes

W_PAY_GRADE_DS/D

Dim – Pay Grade

HcmTopModelAnalyticsGlobalAM.GradeCustomerFlexBIAM.FLEX_BI_GradeCustomerFlex_VI

Job Extensible Attributes

W_JOB_DS/D

Dim – Job

HcmTopModelAnalyticsGlobalAM.JobCustomerFlexBIAM.FLEX_BI_JobCustomerFlex_VI

Location Extensible Attributes

W_BUSN_LOCATION_DS/D

Dim - Worker Location

HcmTopModelAnalyticsGlobalAM.LocationCustomerFlexBIAM.FLEX_BI_LocationCustomerFlex_VI

Department Extensible Attributes

W_INT_ORG_DS/D

Dim - Department

HcmTopModelAnalyticsGlobalAM.OrgAttributesDFFDFFBIAM.FLEX_BI_OrgAttributesDFF_VI