How to Terminate the Employees through HDL In Oracle Cloud

How to Terminate the Employees through HDL In Oracle Cloud

HDL is HCM Data loader tool to create and Integrate the Employee Information in Oracle cloud. With the Help to HDL tool we can create and update Employee Information from External system. In the Same way if we want to Terminate the Employee from Back end or form External System then we can also do the same through HDL tool. HDL tool helps to allow the Employee Termination from External System. Here below I will share the detail steps to terminate the Employee through HDL in Oracle cloud.

 

 

Employee Termination steps through HDL in Oracle cloud

To Terminate the Employees, we need to use the Two METADATA under the Worker File. First Meta Data is Worker and Second one is Work Relationship as below.

First of all, to understand the concept of Terminate we should be knowing the process of Employee Creation HDL.

To Terminate Employee, we need to use the Action Code=’ RESIGNATION’ in the Worker MetaData. This First metadata will end date the Employee Header record in Oracle cloud.

We should be careful to give the Values to the PersonId and then PersonNumber. These values should be available in the Cloud application to terminate the Employees.

In this Case I am using the Person Id as a Source system Id. Source system Id is the Unique Key for Each Employee record and we give this during Employee Creation. So, we need to use the same Source system id during Employee Termination also. So, we need to take this during this script.

This is the First Script of Employee Termination

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

The second Meta Data is uses to end date the Employee Assignment Part. In this Meta also we do specify the ActionCode=’ RESIGNATION’ and the Reason Could be any based on option we have in the Cloud application but in this case we are using ReasonCode=’RESIGN_PERSONAL’

We also need to put the Legal Employer name to which this employee already assigned during creation.

We need to give the ActualTerminationDate and  TerminateWorkRelationshipFlag should be ‘Y’.

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

 

As below this is the Complete worker File for Employee Termination Through HDL in Oracle Cloud

 

 

Once we have prepared these two metadata for Terminated employee to rehire we need to save this meta data in Worker.dat file.

 

Then We need to put this Worker.dat file in the Worker.zip folder. After this We need to put this Worker.zip folder in the Cloud Application.

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

Once the zip file have been prepared. Then We need to go Data Exchange

Then Data Exchange ==> HCM Data Loader ==> Import and Load Data

Once Import the Worker File , Then Employee Should be Terminated after that.