Overview

Often times, your existing data or the payroll data that you upload might not be in the format recognized by HCM Data Loader.

In such cases, you can use a payroll transformation formula to transform your data into a format that'ssupported by HCM Data Loader.

Let's consider these examples.

• An inbound file contains data that needs to be loaded using different payroll business objects in HCM Data Loader. Here, the content of the file needs to be split across more than one HCM Data Loader file.

• You might create a transformation formula to convert an attribute value in the file to another value that you derive using value sets.

• You want to change a person number into an assignment number. In this case, you will use a more complex formula to convert the attributes.

You use the Load Data From File flow to transform your data into the HCM Data Loader file format using your transformation formula.

As this table shows, the two flow patterns are secured using these privileges:

Flow Pattern	Privileges
Submit Payroll Flow	PAY_SUBMIT_PAYROLL_FLOW_PRIV
Load HCM Data	HRC_LOAD_HCM_DATA_PRIV

This example specifies the file name in the formula as PersonalPaymentMethod, the file discriminator as PersonalPaymentMethod, and the business operation as MERGE.

/*HDL Related Outputs*/
    FileName = 'PersonalPaymentMethod'
    BusinessOperation = 'MERGE'
    FileDiscriminator = 'PersonalPaymentMethod'

To view details about the file name, file discriminator, and a list of supported business operations, use the View Business Objects task in the Data Exchange work area.

1. On the View Business Objects page, search for and select your business object. In this example, the business object is Personal Payment Method.

2. On the Component Details page, you can find the name of the file, and the file discriminator and a list of supported actions for the object.