Manage an HCM Data Loader Extract Definition

HCM Extracts provides four predefined extracts for HCM Data Loader:

  • HCM Data Loader Data Set Summary

  • Compensation Changes Extract

  • Integration Object User Key Refresh

  • Integration Object User Key Map Extract

This topic explains how to copy a predefined extract, specify a delivery option, and compile the formulas for the copied extract. You can follow these instructions for any of the HCM Data Loader extracts.

Copy the Extract

Follow these steps to copy an HCM Data Loader extract:

  1. In the Data Exchange work area, click Extract Definitions.

  2. On the Extract Definitions page, search for the extract.

  3. Select the extract in the search results and click Actions > Copy or Rename.

  4. In the Copy Extract Definition dialog box, enter a name for your copy of the extract and click OK.

    A confirmation message appears when the copy is complete.

Specify a Delivery Option for the Copied Extract

Follow these steps to specify a delivery option:

  1. On the Extract Definitions page, search for your copy of the extract.

  2. Click the extract name in the search results to display the extract definition on the Extract Definitions page.

  3. Click Deliver.

  4. In the Extract Delivery Options section, click Add.

  5. Specify a delivery option. To keep the default XML output, set the Output Type to Data.

  6. For the XML delivery option, specify Delivery Option Name, Output Name, and Delivery Type values.

    Tip: The values that you must specify vary by output type.
  7. Click Save.

For more information, see Oracle Fusion HCM Extracts: Delivery Options (document ID 1573099.1) on My Oracle Support at https://support.oracle.com.

Compile the Formulas for the Copied Extract

Follow these steps to compile the formulas:

  1. On the Extract Definitions page, click Validate.

  2. In the Extract Execution Tree section, click Compile All Formula to compile the formulas.

  3. Refresh the table periodically until all formulas are successfully compiled. A check mark means success.

  4. Click Submit.

Once these steps are complete, perform the Refine Extracts task in the Data Exchange work area to configure the copied HCM Data Loader extract.