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 Oracle BI Cloud Connector Console to load the View Objects (VOs) listed in Supported View Objects below:

    1. On the Fusion Applications pod, start Oracle BI Cloud Connector Console using a HTTP URL based on the following format: http://<FA OHS Host:<FA OHS Port/biacm

    2. In Oracle 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 Oracle 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 Oracle Business Analytics 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

Assignment History Extensible Attributes

W_HR_ASSIGN_ADDL_D

Dim – HR Assignment History

HcmTopModelAnalyticsGlobalAM.BaseWorkerAsgDFFBIAM.FLEX_BI_BaseWorkerAsgDFF_VI

HcmTopModelAnalyticsGlobalAM.BaseWorkerAsgLegDDFBIAM.FLEX_BI_BaseWorkerAsgLegD DF_VI

HcmTopModelAnalyticsGlobalAM.WorkRelationshipDFFBIAM.FLEX_BI_WorkRelationshipDFF_VI

HcmTopModelAnalyticsGlobalAM.WorkRelationshipLegDDFBIAM.FLEX_BI_WorkRelationsh ipLegDDF_VI

HcmTopModelAnalyticsGlobalAM.ContractDFFBIAM.FLEX_BI_ContractDFF_VI

HcmTopModelAnalyticsGlobalAM.ContractLegDDFBIAM.FLEX_BI_ContractLegDDF_VI

Person Extensible Attributes

W_HR_PERSON_DS/D

Dim – HR Person

HcmTopModelAnalyticsGlobalAM.PersonsDFFBIAM.FLEX_BI_PersonsDFF_VI

HcmTopModelAnalyticsGlobalAM.PersonDetailsDFFBIAM.FLEX_BI_PersonDetailsDFF_VI

HcmTopModelAnalyticsGlobalAM.PersonTypeUsagesDFFBIAM.FLEX_BI_PersonTypeUsagesD FF_VI

Person Extensible Attributes

W_HR_PERSON_LEG_DS/D

Dim – HR Person Legislation

HcmTopModelAnalyticsGlobalAM.PersonLegislativeInfoDFFBIAM.FLEX_BI_PersonLegislativeInfoDFF_VI

HcmTopModelAnalyticsGlobalAM.CitizenshipDFFBIAM.FLEX_BI_CitizenshipDFF_VI

HcmTopModelAnalyticsGlobalAM.EthnicityDFFBIAM.FLEX_BI_EthnicityDFF_VI

HcmTopModelAnalyticsGlobalAM.PersonLegDDFBIAM.FLEX_BI_PersonLegDDF_VI

HcmTopModelAnalyticsGlobalAM.PersonNameDFFBIAM.FLEX_BI_PersonNameDFF_VI

HcmTopModelAnalyticsGlobalAM.PersonNameLegDDFBIAM.FLEX_BI_PersonNameLegDDF_VI

HcmTopModelAnalyticsGlobalAM.ReligionDFFBIAM.FLEX_BI_ReligionDFF_VI

HcmTopModelAnalyticsGlobalAM.PersonVisaLegDDFBIAM.FLEX_BI_PersonVisaLegDDF_VI

HcmTopModelAnalyticsGlobalAM.VisaPermitDFFBIAM.FLEX_BI_VisaPermitDFF_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

  

Payroll Extensible Attribute

W_PAY_PAYROLL_D

Dim - Payroll Details

HcmTopModelAnalyticsGlobalAM.AllPayrollsDDFBIAM.FLEX_BI_AllPayrollsDDF_VI

Candidate Extensible Attributes

W_SCCN_CANDIDATE_D

Dim - Succession Candidate

HcmTopModelAnalyticsGlobalAM.PlanCandidateDFFBIAM.FLEX_BI_PlanCandidateDFF_VI

Workforce Event Type Extensible Attributes

W_WRKFC_EVENT_TYPE_D W_WRKFC_EVNT_ADDL_D W_WRKFC_EVNTRSN_ADDL_D

Dim - HR Workplace Event Type

HcmTopModelAnalyticsGlobalAM.ActionReasonsDFFBIAM.FLEX_BI_ActionReasonsDFF_VI

HcmTopModelAnalyticsGlobalAM.ActionsDFFBIAM.FLEX_BI_ActionsDFF_VI

HcmTopModelAnalyticsGlobalAM.ActionsLegDDFBIAM.FLEX_BI_ActionsLegDDF_VI

Project Attribute Extension

PROJECT_ADDL_D

Dim - Project

FscmTopModelAM.PJF_PROJECTS_ALLBIAM.FLEX_BI_PJF_PROJECTS_ALL_VI

Task Attribute Extension

TASK_ADDL_D

Dim - Task

FscmTopModelAM.TaskDffBIAM.FLEX_BI_TaskDff_VI

N/A

Employee_ADDL_D

Dim - Employee

  

N/A

W_UOM_CONVERSION_G

N/A