How to end date Supervisor Records through HDL in Oracle Fusion : HDL script to end date employee supervisors record

How to end date Supervisor Records through HDL In Oracle Fusion : HDL script to end date employee supervisors record

In this post , We will be discuss about how to end date Supervisor Records through HDL. HDL provides meta data which helps to end date the supervisor record in oracle fusion. We need to write this meta data script under Worker.dat file to end date supervisor record for an employee in oracle fusion. But we need put the right information in this meta data script as per the current employee supervisor record in Oracle fusion. Here below is the detail about How to end date Supervisor Records through HDL in Oracle Fusion.

HDL script to end date employee supervisors record through HDL in Oracle Fusion

Step 1:- 

End date of supervisor record can be done by passing the below parameter

'ReplaceEffectiveEndDate' in METADATA and in MERGE, provide 'Y'
Please find the below example

METADATA|AssignmentSupervisor|AssignmentNumber|ManagerType|EffectiveStartDate|EffectiveEndDate|NewManagerPersonNumber|ManagerPersonNumber|PrimaryFlag|ActionCode|ReplaceLasatEffectiveEndDate
MERGE|AssignmentSupervisor|Exxxxx|LINE_MANAGER|yyyy/mm/dd|yyyy/mm/dd||yyyyy|Y|ASG_CHANGE|Y

We need to store the above HDL script in worker.dat file as below.

 

To Import this Worker.Zip file we need to follow these steps as below.

 

 

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

 

 

 

 

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

Step7:-Select the Import and Load Data.

Step 6:- Select the Option Import Local File as highlighted below to Import the Worker File Created in Step3 for Employee Termination.