Submit an HCM Data Loader Extract

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 submit a configured HCM Data Loader extract.

Select the Extract

Follow these steps:

1. On the Tasks panel tab of the Data Exchange work area, select Submit Extracts to open the Submit a Process or Report page.

2. Using the query by example fields, find your extract and click Next.

   The Enter Parameters page opens.

3. In the Payroll Flow field, enter a flow name for this run of the extract.

4. Enter the parameter values for your extract.

Enter Parameters for the HCM Data Loader Data Set Summary Extract

This table shows the parameters for the HCM Data Loader Data Set Summary extract. Enter any one of the Content ID, Process ID, and Data Set Name parameters. You can find all of these values for a specific data set on the Import and Load Data page.

Parameter	Description
Content ID	The content ID associated with the data set. This ID was assigned when you uploaded your source file to the Oracle WebCenter Content server.
Data Set Name	The data set name, which is also your source file name.
Process Configuration Group	Leave blank.
Process ID	The process ID of the process that created the data set. This ID was assigned when you submitted your source file for processing by HCM Data Loader.

Enter Parameters for the Compensation Changes Extract

This table shows the parameters of the Compensation Changes Extract. To identify the compensation run to report on, use one of the following parameters or pairs of parameters:

• Plan and Period Name

• Process Id

• Run Id

Parameter	Description
Plan	The compensation plan name
Period Name	The period name for the compensation run
Process Id	The process ID for the compensation run
Run Id	The run ID for the compensation run

Enter Parameters for the Integration Object User Key Refresh Extract

This table shows the parameters of the Integration Object User Key Refresh Extract.

Parameter	Description
Business Object	The file discriminator of the business object for which you want to refresh keys. For example, for some or all components of the Worker object, set this parameter to Worker. You can find the file discriminator values on the Business Object Details page for the object in the Data Exchange work area.
Component Discriminator	The file discriminator of the business object component. For example, to refresh keys for the Work Relationship component of the Worker object, set this parameter to WorkRelationship. You can find the file discriminator values on the Business Object Details page for the object in the Data Exchange work area.
Include Child Components	Set to Yes to include the child components of the business object or component in the refresh.
Process Configuration Group	Leave blank.

Enter Parameters for the Integration Object User Key Map Extract

This table shows the parameters of the Integration Object User Key Map Extract.

Parameter	Description
Business Object	The file discriminator of the business object for which you want to extract keys. For example, for some or all components of the Worker object, set this parameter to Worker. You can find the file discriminator values on the Business Object Details page for the object in the Data Exchange work area.
Component Discriminator	The file discriminator of the business object component. For example, to extract keys for the Work Relationship component of the Worker object, set this parameter to WorkRelationship. You can find the file discriminator values on the Business Object Details page for the object in the Data Exchange work area.
Include Child Components	Set to Yes to include the child components of the business object or component in the extract. Tip: If you're extracting a large number of records, then you're recommended to set this parameter to No and extract each component separately.
Process Configuration Group	Leave blank.
Source System Owner	If required, select a value to extract the keys for a specified source system owner. The extract includes all types of keys, but only for those object instances with this source system owner.

Submit the Extract

Follow these steps:

1. Click Next until you reach the Review page.

2. Click Submit.

   A confirmation message appears when your extract is submitted successfully.

3. Close the Confirmation dialog box.

You can now view the extract output.