Overview of 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 downloadthe template in CSV format. You can download CSV and XML file templates from a spreadsheet template. The PayrollTransformation Formula for HCM Spreadsheet Data Loader transforms the raw delimited file to a format that suits the template.

This figure summarizes the process of transforming data that's uploaded using HCM Spreadsheet Data Loader.

Here's a summary of how the transformation process works.

1. On the Home page, click the Submit a Flow quick action under the My Clients Groups tab. Submit the Load Spreadsheet Data File flow pattern.

   The flow is secured using these privileges:

   Flow	Privilege
   Submit Payroll	PAY_SUBMIT_PAYROLL_FLOW_PRIV
   Load Data using HCM Spreadsheet Data Loader	HRC_LOAD_DATA_USING_HSDL_PRIV

2. This flow pattern invokes the transformation formula for the Content ID and has these tasks:

   1. Generate Data Loader File

   2. Initiate Spreadsheet Data Loader

3. The Generate Data Loader File task reads the data file line by line, producing an equivalent HCM Spreadsheet Data Loader format for each line. Finally, it creates a compressed file of all of the transformed data files and uploads it to Oracle WebCenter Content server.

4. The Initiate Spreadsheet Data Loader task takes the compressed file generated by the Generate Data Loader File task and invokes the HCM Spreadsheet Data Loader. The HCM Spreadsheet Data Loader creates the required data in the HCM Cloud.