Part4 HDL Tutorial in Oracle Cloud : How to Terminate the Employee in Oracle cloud through HDL

Part4 HDL Tutorial in Oracle Cloud : How to Terminate the Employee in Oracle cloud through HDL

 This is the Fourth Part of Oracle Cloud HDL Tutorial , In the Last post Part 3, I have shared the HDL scripts to create the Employee Assignment in Oracle cloud If you want to create only Employee Header without Assignment then we can refer the part1 of HDL Tutorial. In this current post , I am sharing the HDL script to terminate the Employee & its Assignment information's through HDL. This below script help to terminate the employee in Oracle Cloud . Before starting this post , I would recommend to first start from the beginning of this Tutorial.

 

Here below is the Part3 of the HDLTutorial

 

https://rpforacle.blogspot.com/2019/04/part3-hdl-tutorial-in-oracle-cloud-how-to-create-employee-assignment-through-hdl.html

How to Terminate the Employee in Oracle cloud through HDL

Step1:- To Terminate any employee in system first we should have the Employee record in system. We should have his Employee number , Person id to start the termination.

 

 

Step2:- As below , this is the sample script to terminate the Employee in Oracle cloud through HDL. In this Script , We are using two METADATA'S.

 

First Meta Data help to Terminate the Employee Header and Second help to terminate the Employee Assignment.

 

As below this is the First MetaData and here we need to provide the Person Id , Person Number , source system Id. Action code will be 'RESIGNATION'.

 

METADATA|Worker|PersonId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|SourceSystemOwner|SourceSystemId
MERGE|Worker|234554|2015/04/20|4712/12/31|34564|2015/04/20|1970/05/21|RESIGNATION|XXTEST|234554

 

As below this is the Second MetaData and here we need to provide the Person Id , Person Number , source system Id. Action code will be 'RESIGNATION' and Reason Code will be 'RESIGN_PERSONAL'.

 

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|TerminateWorkRelationshipFlag|ActualTerminationDate|ActionCode|ReasonCode
MERGE|WorkRelationship|XXTEST|234554_UnitedStates|234554|LegalOrgName|Y|2018/06/22|RESIGNATION|RESIGN_PERSONAL

 

 

Here below this is the Complete worker file having , Employee and Employee Assignment HDL scripts for Termination.

 

 

Step3:-

 

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.