🔥 Oracle HDL Terminate Template (WorkRelationship) with Example & Errors

✅What We Will Cover in This Blog Section (Oracle HDL Blog)

Learn how to terminate a worker in Oracle Fusion HCM using HDL with complete WorkRelationship template, prerequisites, sample .dat file, common errors, and troubleshooting guide.

✅ Introduction: Termination of Worker in Oracle Fusion HCM

Termination of a worker in Oracle Fusion HCM is the process of ending an employee’s employment relationship with a legal employer.

Using HDL (HCM Data Loader), termination can be performed in bulk or individually by loading the WorkRelationship object.

This method is widely used in:

• Employee resignation

• Contract end

• Layoffs

• Organizational restructuring

• Mass termination

You can see step by step video to termination of worker using this Link

---

✅ Prerequisites for Worker Termination Using HDL

Before loading the termination file, ensure:

1. Worker record already exists in Oracle Fusion HCM.

2. PersonNumber is valid.

3. Legal Employer is correct.

4. Termination dates are accurate.

5. Worker.dat is already loaded.

👉 If the worker does not exist, load Worker.dat first.

---

✅ Required Object for Termination in HDL

For worker termination, you must load:

Object	Purpose
WorkRelationship	Terminates the employment relationship

👉 Only WorkRelationship is required for termination.

---

✅ Sample HDL Template for Termination of Worker

✅ WorkRelationship Template

METADATA|WorkRelationship|LegalEmployerName|PersonNumber|DateStart|WorkerType|ActionCode|TerminateWorkRelationshipFlag|ActualTerminationDate|LastWorkingDate|NotifiedTerminationDate|ProjectedTerminationDate|Comments
MERGE|WorkRelationship|US1 Legal Entity|XXTEST2|2018/01/01|E|TERMINATION|Y|2021/01/02|2021/01/02|2021/01/02|2021/01/02|Sample termination file

---

✅ Explanation of Key Fields

Field	Description
ActionCode	Must be TERMINATION
TerminateWorkRelationshipFlag	Must be Y
ActualTerminationDate	Actual termination date
LastWorkingDate	Last working day
PersonNumber	Employee number
LegalEmployerName	Legal employer name

---

✅ Step-by-Step Process to Terminate Worker Using HDL

1. Prepare WorkRelationship.dat file.

2. Zip the .dat file.

3. Upload using HDL in Oracle Fusion.

4. Submit the load process.

5. Verify termination in the employee record.

---

✅ Common Errors in Termination HDL (With Solutions)

✅ Common Issues and Solutions

⚠️ Issue	🔍 Root Cause	✅ Resolution
Worker not terminated	Wrong ActionCode	Set ActionCode = TERMINATION
No change after HDL load	Termination flag missing	Set TerminateWorkRelationshipFlag = Y
Invalid PersonNumber	Worker not found	Verify worker exists in Oracle HCM
Date error	Incorrect termination dates	Correct ActualTerminationDate & LastWorkingDate
Legal employer mismatch	Wrong legal employer name	Validate LegalEmployerName

🧠 Visual Error Flow (Infographic Style)

HDL Load Completed

        ↓

Worker Not Terminated ❌

        ↓

Check ActionCode → TERMINATION?

        ↓

Check Termination Flag → Y?

        ↓

Verify PersonNumber

        ↓

Validate Dates

        ↓

Validate Legal Employer

        ↓

Termination Successful ✅

---

✅ Difference Between Termination and Global Transfer in HDL

Termination	Global Transfer
Ends employment	Moves employee to another legal employer
Uses WorkRelationship only	Uses WorkRelationship + WorkTerms + Assignment
ActionCode = TERMINATION	ActionCode = GLB_TRANSFER

---

✅ Best Practices for Worker Termination Using HDL

• Always validate PersonNumber before loading HDL.

• Ensure termination dates are consistent.

• Test in lower environment.

• Check HDL logs after load.

• Avoid overlapping employment dates.

---

✅ Internal Linking Strategy (Very Important for SEO)

Use these internal links in your blog 👇

🔗 Recommended Internal Links (Anchor Text Optimized)

• Worker Creation Using HDL - Worker.dat blog
• Global Transfer Using HDL - Global Transfer blog
• Assignment Change Using HDL - Assignment Change blog
• Reverse Termination Using HDL - Reverse Termination blog
• Oracle HDL Top 50 Questions - HDL Errors blog
• Oracle eText BIP Template - Sample eText BIP Template 
• Person Contact Using HDL - Contact.dat Blog