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:
-
On the Tasks panel tab of the Data Exchange work area, select Submit Extracts to open the Submit a Process or Report page.
-
Using the query by example fields, find your extract and click Next.
The Enter Parameters page opens.
-
In the Payroll Flow field, enter a flow name for this run of the extract.
-
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:
-
Click Next until you reach the Review page.
-
Click Submit.
A confirmation message appears when your extract is submitted successfully.
-
Close the Confirmation dialog box.
You can now view the extract output.
To learn how to create a HCM Extract delivery option to format your output into a HDL file and define a payroll flow pattern to initiate the extract and submit HDL, see the tutorial: Initiate HCM Data Loader for HCM Extract Generated Files