1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating with the Oracle HCM Cloud
  4. Creating an Oracle HCM Cloud Data Source Application

Creating an Oracle HCM Cloud Data Source Application

In Data Management, use the Target application option to register an individual Oracle Human Capital Management Cloud extract as a data source target application.

To create an individual Oracle HCM Cloud extract as a data source application:

  1. Select the Setup tab, and then under Register, select Target Application.

  2. Click Add, and then select Data Source.

  3. In Source System, select the name of the Oracle HCM Cloud source system.

    For example, you might specify Oracle HCM Cloud.

  4. In Source Entity, specify the file name (in XML format) of the source entity to register as a data source.

    The file is the Oracle HCM Cloud extract application name/definition that has already been uploaded to the inbox in Data Management.

    The Oracle HCM Cloud extract application name and definition are defined in Oracle HCM Cloud, and are included in the XML file that is downloaded from the Oracle HCM Cloud.

    Image shows adding an Oracle HCM Cloud Data Source Application source system and source entity.

    You can also launch the Search and Select screen by clicking Image shows Browse icon. and selecting a source entity.

    Image shows the Select screen.

  5. Click OK.

  6. Optional: You can apply filter conditions to the Oracle HCM Cloud data source so that only those records that meet selected conditions are returned to Data Management. You can specify a single filter condition or multiple filters conditions, and additionally specify the exact values that you want returned.

    To apply a filter condition:

    1. From Application Details, select the Application Filters tab.
    2. Select the name of the field to which to apply the filter condition.
    3. From the Condition drop-down, select the applicable condition.
      • EQ (equals)
      • Like
      • In
    4. In Value, specify the filter definition.

  7. Click Save.

    Note:

    When you create an Oracle HCM Cloud data source, dimension details are populated automatically and mapped directly to the target dimension class "Generic." As a rule, when loading data from an Oracle HCM Cloud data source, do not change, add, or delete any dimension details on the Target Application screen.