⭐ HDL Template for Worker in Oracle Fusion HCM (Worker.dat + Worker Example)

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

🔹 Prerequisites

Before you start:

1. Work structure must be loaded

   Click here for a sample Work Structure

2. You must have a Source Key defined. In earlier blogs, we created “XXTEST” as our source key.

3. Download the object templates from your instance:

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

🔹 Components in Worker.dat File

You can see step by step video using this link

You will load the following objects in Oracle Fusion HCM:

• Worker

• Person Name

• National Identifier

• Email

• Phone

• Address

• Citizenship

• Ethnicity

• Legislative Data

• Work Relationship

• Work Terms

• Assignments

Download the object template from instance.

🔹 Sample Worker Load with Example

1️⃣ Worker

METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|ActionCode|StartDate|DateOfBirth

MERGE|Worker|XXTEST|XXTEST_PER1|2018/01/01|4712/12/31|XXTEST1|HIRE|2018/01/01|1975/01/01

2️⃣ Person Name

METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title

MERGE|PersonName|XXTEST|XXTEST_PERNAME1|XXTEST_PER1|2018/01/01|4712/12/31|US|GLOBAL|Adam||Baro|MR. 

3️⃣ National Identifier

METADATA|PersonNationalIdentifier|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegislationCode|IssueDate|ExpirationDate|NationalIdentifierType|NationalIdentifierNumber|PrimaryFlag

MERGE|PersonNationalIdentifier|XXTEST|XXTEST_NID1|XXTEST_PER1|US|||SSN|456-23-4167|Y

4️⃣ Email

METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag

MERGE|PersonEmail|XXTEST|XXTEST_EMAIL1|XXTEST_PER1|2018/01/01|4712/12/31|W1|Adam.baro@ha.com|Y

5️⃣ Phone

METADATA|PersonPhone|SourceSystemOwner|SourceSystemId|PhoneType|DateFrom|DateTo|PersonId(SourceSystemId)|PhoneNumber|PrimaryFlag

MERGE|PersonPhone|XXTEST|XXTEST_WPH1|W1|2018/01/01|4712/12/31|XXTEST_PER1|789-123-2345|Y

6️⃣ Address

METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|AddressType|AddressLine1|AddressLine2|AddressLine3|AddressLine4|Building|FloorNumber|TownOrCity|Region1|Region2|Region3|Country|PostalCode

MERGE|PersonAddress|XXTEST|XXTEST_ADDR1|2018/01/01|4712/12/31|XXTEST_PER1|HOME|300 Some street|Unit 1|||||Pasadena|Los Angeles|CA||US|91101

7️⃣ Citizenship

METADATA|PersonCitizenship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|DateTo|LegislationCode|CitizenshipStatus

MERGE|PersonCitizenship|XXTEST|XXTEST_CTZSHIP1|XXTEST_PER1|2018/01/01|4712/12/31|AM|A

8️⃣ Ethnicity

METADATA|PersonEthnicity|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegislationCode|Ethnicity|PrimaryFlag

MERGE|PersonEthnicity|XXTEST|XXTEST_ETHNIC1|XXTEST_PER1|US|1|Y

9️⃣ Legislative Data

METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|MaritalStatus|MaritalStatusDate|Sex

MERGE|PersonLegislativeData|XXTEST|XXTEST_LEG1|2018/01/01|4712/12/31|XXTEST_PER1|US|M|1998/05/12|M

🔟Work Relationship

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|EnterpriseSeniorityDate|LegalEmployerSeniorityDate|ActualTerminationDate|Comments|LastWorkingDate|NotifiedTerminationDate|PrimaryFlag|ProjectedTerminationDate|RehireAuthorizerPersonId|RehireAuthorizor|RehireReason|WorkerNumber|WorkerType|OnMilitaryServiceFlag|RehireRecommendationFlag

MERGE|WorkRelationship|XXTEST|XXTEST_PDSERVICE1|XXTEST_PER1|US1 Legal Entity|2018/01/01|||||||Y|||||XXTEST1|E|N|Y

1️⃣1️⃣ Work Terms

METADATA|WorkTerms|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryWorkTermsFlag|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|LegalEmployerName|SystemPersonType

MERGE|WorkTerms|HIRE|XXTEST|XXTEST_WRKTERM1|2018/01/01|4712/12/31|1|Y||XXTEST_WRKTERM1|ACTIVE_PROCESS|ET|US1 Business Unit|Y|Y|XXTEST_PDSERVICE1|XXTEST_PER1|US1 Legal Entity|EMP

1️⃣2️⃣  Assignment

METADATA|Assignment|ActionCode|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentName|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|PositionOverrideFlag|PrimaryAssignmentFlag|PrimaryFlag|SystemPersonType|LegalEmployerName|JobId(SourceSystemId)|LocationId(SourceSystemId)|OrganizationId(SourceSystemId)|PositionId(SourceSystemId)|GradeId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|PersonId(SourceSystemId)|PersonTypeCode|ManagerFlag|LabourUnionMemberFlag|WorkTermsAssignmentId(SourceSystemId)|AssignmentCategory|Frequency|HourlySalariedCode|NormalHours|NoticePeriod|ProbationPeriod|ProbationUnit|ReasonCode

MERGE|Assignment|HIRE|XXTEST|XXTEST_ASSIGN1|2018/01/01|4712/12/31|1|Y|E-XXTEST1|XXTEST_ASSIGN1|ACTIVE_PROCESS|E|US1 Business Unit|Y|Y|Y|EMP|US1 Legal Entity|XXTEST_JOB1|XXTEST_LOC65XXTEST_DEPT1||XXTEST_GRADE01|XXTEST_PDSERVICE1|XXTEST_PER1|Employee|Y|N|XXTEST_WRKTERM1|FR|W|S|40|0|||NEWHIRE

🔹 Steps to Load Worker.dat in Oracle Fusion

1. Save all HDL objects as Worker.dat

2. Create a zip file containing Worker.dat and all other HDL files

3. Navigate to:

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

4. Upload the zip file

5. Refresh page to verify load status

6. Once successfully loaded, confirm work structure is updated correctly

🎥 Step-by-step video guide is available here

 

🔹 Common Worker HDL Errors and Solutions

Error	Reason	Solution
Person already exists	Duplicate person number	Use unique PersonNumber
Business unit not found	Invalid BU name	Verify BU setup
SourceSystemId duplicate	Same ID used	Use unique ID
Invalid date format	Wrong date format	Use YYYY/MM/DD
Load failed	Data issue	Check HDL logs

🔹 FAQ – Oracle Worker HDL

Q1. What is Worker.dat in Oracle Fusion?
Worker.dat is used to load employee data using HCM Data Loader in Oracle Fusion HCM.

Q2. Can we update employee data using Worker.dat?
Yes, using MERGE action in HDL.

Q3. Why does Worker HDL load fail?
Due to invalid setup values or duplicate IDs.

Q4. What is SourceSystemId in HDL?
It is a unique identifier for HDL records.

Q5. Is Worker.dat mandatory for employee creation?
Yes, it is the primary HDL file for worker creation.

🔗 Related Articles (Internal Linking)

• • Oracle Worker HDL Common Errors - A complete guide to troubleshoot Worker.dat issues including Primary Work Relationship, GradeId, and SourceSystemOwner errors.

  • How to load employee data using Worker HDL
    Step-by-step solution to load  Worker HDL loads.

  • BI Publisher eText Reports – Delimiter vs Fixed Position  Learn when to use Delimiter-based vs Fixed Position-based eText templates in Oracle BI Publisher.

  • Load WorkStructure data in Oracle Fusion using HCM Loader(HDL) 

  • How to load dependent enrolment in oracle benefits

  • How to load Seniority Date in Oracle Fusion

  • Top 50 Fusion HCM Technical Questions

🎓 Oracle HCM Technical Training  

If you want to learn Oracle Fusion HCM Technical in a structured way, I also provide Oracle HCM Technical with real-time practical examples.

If you want Oracle HCM Technical Training, you can contact me here: Link