HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Hi friends, we are going to share the HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion. We will share the detail steps to upload the employees payroll data in oracle fusion using the HDL loader. Oracle fusion has provided the feature to upload the mass payroll data using the hdl in oracle fusion. Using HDL tool, we can upload the employees as well employees payroll data in oracle fusion. We need to prepare the payroll data in the form of HDL script and then upload the data in to the Oracle cloud application. If we have an bulk of payroll data which we want to upload in oracle cloud then this is the best way to upload in the application. In this post , We will discuss the HDL Script to upload the Employees Payroll Data in more detail and we will share the complete hdl scripts for that. Please find below the complete detail about HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion.

Step by step using HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Step 1: We need to use the  Assigned Payroll business object to load payroll information assigned to the person.We will use this Assigned Payroll business object to upload Employees Payroll Data in Oracle Fusion.

HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Step 2:- Here below , is the Assigned Payroll business object Attributes/Columns which is provided by oracle fusion to upload the employees payroll data. We need to prepare the Employees Payroll Data in this Format.

HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Step 3:- 

Here below is the actual HDL script example , here we have put the dummy employees payroll data to upload in to the oracle fusion application. 

You need to prepare the data in the same format as below.

The following example shows the content of a file that adds one person to a payroll in the US LDG by assignment number.

METADATA|AssignedPayroll|AssignmentNumber|PayrollDefinitionCode|LegislativeDataGroupName|EffectiveStartDate|EffectiveEndDateMERGE|AssignedPayroll|E300100005857719|PM YS Weekly|PM US Sun Power |2017/03/25|4712/12/31

HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Step4:- 

Once Your Data has been prepared then you need to go to the Oracle Cloud application.

You need to have 'human capital management integration specialist' role to use the HDL tool in Oracle Fusion.

Go to Navigator ==> Data Exchange

HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

 

 

 

 

Step 6:- Now you are in the HDL screen. Select the Task option as highlighted below.

HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Step 7:-Select the Import and Load Data.

HDL Script to upload the Employees Payroll Data into Oracle Cloud/Fusion

Step 6:- Select the Option Import Local File as highlighted below to Import the Worker File Created in Step3  to upload the Employees Payroll Data