Initiate HCM Data Loader

This enhancement enables the Payroll flow tasks to seamlessly submit the HCM Data Loader when there's access restriction while loading security related data or mapping configured between business objects and user roles.

  • Create a file extract using a new delivery option called the Data Loader Interface in the HCM Extract: Extract Definitions page.

  • Configure and submit a Payroll Flow by sequencing the created extract and a new process called the Run HCM Data Loader to process the extract file by submitting the HDL or HSDL process based on the File Type and parameters defined in the delivery option.

You can create a delivery option for both HCM Data Loader and HCM Spreadsheet Data Loader files. For HCM Spreadsheet Data Loader, you can use different spreadsheet templates by configuring HSDL parameters for the delivery option. You can also create multiple delivery options for the same extract.

Steps to Enable

1. Perform the following steps to Create an Extract Definition:

  • Create an extract definition on Data Exchange > Extract Definitions page
  • Set up the parameters on Define, Design tabs
  • On the Deliver tab:
    • Click Add
    • Provide a Delivery Option Name and choose Data Loader Interface as the delivery option.Deliver tab
    • Click OK.
    • Set up the following Advanced parameters section on the created delivery option page.
      • Encryption Mode
      • Integration Name
      • File Type: Data Loader or Spreadsheet Loader - to determine the submission of HDL or HSDL
      • Compressed Delivery Group 
      • Compress

HSDL parameters:

  • Spreadsheet File Date Format
  • Spreadsheet File Delimiter
  • Spreadsheet File Escape Indicator
  • Spreadsheet File Header Included
  • Spreadsheet File New Line Indicator 
  • Spreadsheet Template Code

NOTE:

  • If the File Type is Spreadsheet Loader, then the HSDL parameters need to be set up.

  • For HSDL outputs, only the Spreadsheet Template Code is required, the others will default if not supplied.

HR Worker Extract: Define

  • Click OK.

The Data Loader Interface delivery option is now enabled for the created extract.

Similarly, you can set up the Data Loader Interface delivery option to create multiple HDL and HSDL outputs.

2. Create a Payroll Flow Pattern to define a flow pattern to include the created extract and the Run HCM Data Loader process and set up the Task Sequence, Parameters, and Task Parameters.

  • Edit the Run HCM Data Loader task and set the individual parameters such as Delete Source File, Extract Process Flow Name, File Action, File Encryption, Maximum Concurrent Threads for Import, Maximum Concurrent Threads for Load, Maximum Percentage of Load Errors, and Maximum Percentage of Import Errors for this process.

     NOTE: For existing Payroll Tasks, these parameters are comma separated values.

3. Click Submit a Payroll Flow from Data Exchange and submit the flow created above. 

Key Resources

For more information refer: