HDL Script to Close and Delete the Employees Payroll Data into Oracle Cloud/Fusion
Hi friends, we are going to share the HDL Script to close and delete the Employees Payroll Data into Oracle Cloud/Fusion. We will share the detail steps to close and delete the employees payroll data in oracle fusion using the HDL loader. Oracle fusion has provided the feature to close 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 close in oracle cloud then hdl is the best way to close in the application. In this post , We will discuss the HDL Script to close and delete 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 close and delete the Employees Payroll Data into Oracle Cloud/Fusion.
Example of HDL Script to close and delete the Employees Payroll Data into Oracle Cloud/Fusion
Step 1: We need to use the Assigned Payroll business object to close and delete the payroll information assigned to the person.We will use this Assigned Payroll business object to close and delete Employees Payroll Data in Oracle Fusion.
 |
| HDL Script to Close and delete 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 close the employees payroll data. We need to prepare the Employees Payroll Data in this Format.
 |
| HDL Script to Close and delete 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 close 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 using person which were added to a payroll in the US LDG by assignment number and now we are going to close the payroll data for that employee.
Closing Payroll Data HDL Script
METADATA|AssignedPayroll|AssignmentNumber|PayrollDefinitionCode|LegislativeDataGroupName|CloseDate|EffectiveStartDate|EffectiveEndDateMERGE|AssignedPayroll|E300100005857719|PM YS Weekly|PMUS Sun Power |2018/01/25 00:00:00|2017/03/25|4712/12/31
 |
| HDL Script to Close and delete the Employees Payroll Data into Oracle Cloud/Fusion |
Deleting Payroll Data HDL Script
METADATA|AssignedPayroll|AssignmentNumber|PayrollDefinitionCode|LegislativeDataGroupName|EffectiveStartDate|EffectiveEndDateDELETE|AssignedPayroll|E300100005857719|PM YS Weekly|PM US Sun Power |2017/03/25|2017/09/30
 |
Deleting Payroll Data HDL Script |
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 Close and delete 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 close and delete the Employees Payroll Data into Oracle Cloud/Fusion |
Step 7:-Select the Import and Load Data.
 |
| HDL Script to Close and delete 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 close and delete the Employees Payroll Data
0 comments:
Post a Comment