Load Objects with HCM Data Loader

Use HCM Data Loader for bulk-loading and maintaining payroll data. You can navigate to the HCM Data Loader pages directly from the Payroll Checklist page. On the Checklist page, select the Initiate Data Loader task to open the HCM Data Loader object status page.

You can use HCM Data Loader to load these payroll objects.

  • Balance Definitions

  • Element Entries

  • Object Groups

  • Organization Payment Method

  • Payroll Consolidation Groups

  • Payroll Costing

  • Payroll Definitions and Time Periods

  • Payroll Element Run Usage

  • Payroll Elements

  • Payroll Relationship

  • Personal Payment Method

  • Time Definitions

  • User-Defined Tables

  • Wage Basis Rules

For more info on how to load these business objects, refer to the Integrating with HCM guide.

Payroll Transformation Formula for HCM Data Loader

Your existing data or the data that you upload might not be in the format recognized by HCM Data Loader. In such cases, use the Payroll Transformation formula for HCM Data Loader to transform your data into a format that's supported by HCM Data Loader.

Payroll Transformation Formula for HCM Spreadsheet Data Loader

You can use HCM Spreadsheet Data Loader to load all payroll objects that HCM Data Loader supports. As the first step, you create a spreadsheet template for the required object from the Data Exchange work area and further download the template in CSV format. The Payroll Transformation Formula for HCM Spreadsheet Data Loader transforms the raw delimited file to a format that suits the template.