Oracle Worker.dat HDL Template with Example | Oracle Fusion HCM Guide

Introduction

Oracle Worker.dat HDL template is used to load employee, assignment, and work relationship data into Oracle Fusion HCM using HCM Data Loader (HDL). This tutorial explains Worker.dat HDL file structure, examples, loading steps, and common errors..

You will also find:

• Sample HDL templates

• Required components per object

• Loading steps and verification

• Related articles for Oracle Fusion troubleshooting

Oracle Cloud - Load Work Structure Components - HDL

Load Work Structure Using HCM Data Loader in Oracle Fusion HCM

Oracle Fusion HCM provides HCM Data Loader (HDL) as a powerful and efficient tool to load and maintain large volumes of HCM data. One of the most common technical requirements during implementation or data migration is loading Work Structure components.

In this blog, we will walk through how to load Work Structure using HCM Data Loader in Oracle Fusion HCM, with complete HDL file examples and step-by-step instructions.

In an earlier blog, we explained how to define Source Keys and created a custom Source System Owner – XXTEST. The same source system will be reused while loading Work Structure objects.

📽️ A step-by-step video walkthrough is also available using the provided link.

---

What Are Work Structures in Oracle Fusion HCM?

Work Structures define the organizational framework of an enterprise and are prerequisites for loading Worker and Assignment data.

Using HCM Data Loader, the following Work Structure components can be loaded:

• Grade

• Job

• Location

• Organization

• Position

Each component is loaded using its respective HDL object and must follow a proper dependency sequence.

---

Download Work Structure Object Templates

Before creating HDL files, download the required object templates from your Fusion instance.

Navigation:

Navigator → My Client Group → Data Exchange → View Business Objects

This page displays all business objects supported by HCM Data Loader. Download the templates related to Work Structure Objects.

Note: In this blog, only the required attributes are used from the template to simplify the data load.

---

Load Grade Using HCM Data Loader

Grades define employee levels within an organization.

HDL File – Grade

METADATA|Grade|SourceSystemOwner|SourceSystemId|EffectiveStartDate
|EffectiveEndDate|SetCode|GradeCode|GradeName|ActiveStatus

MERGE|Grade|XXTEST|XXTEST_GRADE01|1951/01/01|4712/12/31|COMMON
|XXTEST_GRADE01|XXTEST Grade01|A

🔑 Source Keys Used

• SourceSystemOwner: XXTEST

• SourceSystemId: XXTEST_GRADE01

📁 Save the file as Grade.dat

---

Load Job Using HCM Data Loader

Jobs represent roles such as Manager, Analyst, or Director.

HDL File – Job

METADATA|Job|SourceSystemOwner|SourceSystemId|EffectiveStartDate
|EffectiveEndDate|SetCode|JobCode|Name|ActiveStatus|RegularTemporary

MERGE|Job|XXTEST|XXTEST_JOB1|1951/01/01|4712/12/31|COMMON|XXTEST_CFO
|XXTEST: Chief Financial Officer|A|R

📁 Save the file as Job.dat

---

Load Location Using HCM Data Loader

Locations define physical or logical work locations.

HDL File – Location

METADATA|Location|SourceSystemOwner|SourceSystemId|EffectiveStartDate
|EffectiveEndDate|SetCode|LocationCode|LocationName|Description
|ActiveStatus|AddressLine1|AddressLine2|TownOrCity|Region1|Region2
|PostalCode|Country

MERGE|Location|XXTEST|XXTEST_LOC5|1951/01/01|4712/12/31|COMMON
|XXTEST_LOC5|XXTEST Location5|XXTEST Location6|A|250 Some st1||Pasadena
|Los Angeles|CA|91101|US

📁 Save the file as Location.dat

---

Load Organization Using HCM Data Loader

Organization loading requires two HDL objects.

1️⃣ Organization

METADATA|Organization|SourceSystemOwner|SourceSystemId|EffectiveStartDate
|EffectiveEndDate|Name

MERGE|Organization|XXTEST|XXTEST_DEPT1|1951/01/01|4712/12/31
|XXTEST Department1

---

2️⃣ Org Unit Classification

METADATA|OrgUnitClassification|SourceSystemOwner|SourceSystemId
|EffectiveStartDate|EffectiveEndDate|OrganizationId(SourceSystemId)
|ClassificationCode|SetCode|Status

MERGE|OrgUnitClassification|XXTEST|XXTEST_DEPT_CLASS1|1951/01/01
|4712/12/31|XXTEST_DEPT1|DEPARTMENT|COMMON|A

📁 Save both records in a single file as Organization.dat

---

Load Position Using HCM Data Loader

Positions define individual instances of jobs within departments.

HDL File – Position

METADATA|Position|SourceSystemOwner|SourceSystemId|EffectiveStartDate
|EffectiveEndDate|PositionCode|Name|BusinessUnitName|ActiveStatus
|JobId(SourceSystemId)|DepartmentId(SourceSystemId)|HiringStatus
|PositionType|FTE|HeadCount|FullPartTime|WorkingHours|Frequency

MERGE|Position|XXTEST|XXTEST_POSITION1|1951/01/01|4712/12/31|
XXTEST_POS1|XXTEST Position1|US1 Business Unit|A|XXTEST_JOB1|
XXTEST_DEPT1|APPROVED|NONE|1|1|FULL_TIME|40|W

📁 Save the file as Position.dat

---

Create ZIP File for HDL Load

Create a ZIP file containing all HDL .dat files:

• Grade.dat

• Job.dat

• Location.dat

• Organization.dat

• Position.dat

Example:

WorkStructure_HDL_Load.zip

---

Load HDL Files into Oracle Fusion HCM

Navigation:

Navigator → My Client Group → Data Exchange → Import and Load → Import

Steps:

1. Upload the ZIP file

2. Submit the Import and Load process

3. Refresh to monitor the load status

Once the process completes successfully, the Work Structure data is loaded.

---

Verify Work Structure Data

After successful load, verify the data from respective pages:

• Manage Grades

• Manage Jobs

• Manage Locations

• Manage Organizations

• Manage Positions

---

Conclusion

Using HCM Data Loader, Work Structure components in Oracle Fusion HCM can be efficiently loaded by defining correct Source Keys, using the required attributes, and following the proper load sequence.

This approach is commonly used during:

• Data migration

• Initial implementation

• Test-to-production refresh

---

What’s Next?

➡️ In the next blog, we will cover how to load Worker Data in Oracle Fusion HCM using HCM Data Loader, including Worker, Assignment, and Element Entry objects.