Setting Up Key Flex Fields for HCM Fusion Applications Source Data

If applicable, load the HCM KFF data mentioned in this topic into Oracle Business Analytics Warehouse.

These instructions only apply if you are deploying a Fusion Applications cloud data

When you have completed the KFF setup in Fusion and deployed the Flexfield, VOs are generated for each segment that you have enabled for BI. Each VO must be seeded and enabled for BI extraction so that it can be loaded into Oracle Business Analytics Warehouse.

To set up key flex fields for HCM Fusion applications source date:

  1. Use BI Cloud Connector Console to load the View Objects (VOs) listed in Supported View Objects 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-C0A44AA0-F03E-4243-A6AA-CCEFF60EB403-default.gif follows
      Description of the illustration GUID-C0A44AA0-F03E-4243-A6AA-CCEFF60EB403-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 (+) to display the Add Data Store dialog and create a new data store.

      Description of GUID-1E37B6B0-4D74-4AC4-AC58-42A57E27BECB-default.gif follows
      Description of the illustration GUID-1E37B6B0-4D74-4AC4-AC58-42A57E27BECB-default.gif

    Note:

    FscmTopModelAM.InvUomPublicViewAM.InvUnitsOfMeasurePVO view object could fail if you have not deployed the INV_UOM_CLASSES flexfield. If you encounter a failure, then disable this view object for Human Capital Management using Oracle BI Cloud Connector Console.

    The next scheduled Cloud Extract executed by BI Cloud Connector Console will extract these VOs and generate files as required by you. Then, the next scheduled load plan executed by Configuration Manager will download the newly generated FLEX files and load the flexfield changes into the Business Analytics 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