How to Change Non-Primary Work Relationship to Primary Using Worker.dat (Oracle Fusion HDL)

Introduction

In Oracle Fusion HCM, an employee can have only one Primary Work Relationship at any given time.

During data corrections or integrations, you may encounter a requirement to change an existing non-primary work relationship to primary.

Oracle Fusion allows this update using HCM Data Loader (HDL) by passing specific attributes in the Worker.dat file.

This blog explains:

• When this scenario occurs

• Required HDL attributes

• Sample Worker.dat template

• What happens after upload

HDL Template for Job Requisition

HDL Template for Job Requisition 

For this use JobRequisition.dat file.

You can see step by step video to load Job Requisition data using this Link

Please find the below sample template :

METADATA|JobRequisition|RequisitionNumber|RecruitingType|JobCode|JobFamilyCode|JobFunction|NumberOfOpenings|UnlimitedOpeningsFlag|RequisitionTitle|HiringManagerId|RecruiterId|PrimaryLocationId|PrimaryWorkLocationId|OrganizationId|DepartmentName|LegalEmployerName|WorkerType|RegularOrTemporary|FullTimeOrPartTime|EducationLevel|CurrentPhaseCode|CurrentStateCode|ExternalApplyFlowCode|PositionCode|BaseLanguageCode|BusinessUnitShortCode|CandidateSelectionProcessCode

MERGE|JobRequisition|XXTEST100|ORA_EXECUTIVES|XXTEST_PM|HUMAN RESOURCES|GSE_TEACH|2|N|XXTEST100|100000610420334|100000610420436|300000186934005|300000221843104|300000047826629|XXTEST Department1|US1 Legal Entity|E|Regular|FULL_TIME|13|REQUISITION_OPEN|REQUISITION_POSTED|ORC_FACULTY|XXTEST_POS1|US|US1 Business Unit|ORC_FACULTY

METADATA|PostingDetails|StartDate|ExternalOrInternal|RequisitionNumber

MERGE|PostingDetails|2021/08/23 00:00:00|ORA_INTERNAL|XXTEST100

MERGE|PostingDetails|2021/08/23 00:00:00|ORA_EXTERNAL|XXTEST100

Oracle Fusion HCM HDL Candidate.dat File – Load Candidate, Address, Phone, Name & Profile (Sample Template)

 

🧾 Oracle Fusion HCM – Load Candidate Data using HDL (Candidate.dat)

If you want to load candidate details into Oracle Fusion Recruiting, you can use HCM Data Loader (HDL) with the file Candidate.dat.

This blog covers:

✅ Candidate basic data
✅ Candidate address
✅ Candidate phone
✅ Candidate name
✅ Candidate profile (Degree / Certifications etc.)
✅ Sample Candidate.dat file format

---

📌 Prerequisites

Before loading Candidate HDL:

• You must have access to HCM Data Loader

• CandidateNumber must be unique

• Use valid codes for:

  • Country (US, IN, etc.)

  • LegislationCode

  • AddressType

  • PhoneType

---

🎥 Step-by-Step Video Reference

You can see step by step video to load Candidate data using this Link:
👉  Link

---

📂 Candidate.dat File – Full Sample Template

1️⃣ Candidate (Basic Candidate Record)

📌 HDL Metadata

METADATA|Candidate|CandidateNumber|CandPrefLanguageCode|StartDate|ConfirmedFlag|CountryOfBirth|DateOfBirth|RegionOfBirth|Source|SourceMedium|TownOfBirth|VisibleToCandidateFlag
✅ Sample Data

MERGE|Candidate|CT123|US|2019/03/20|Y||1980/08/05||direct Source|||Y

---

2️⃣ CandidateAddress

📌 HDL Metadata

METADATA|CandidateAddress|CandidateNumber|EffectiveStartDate|AddressLine1|AddressType|AddressLine2|Country|PostalCode|Region2|Region1|TownOrCity|EffectiveEndDate
✅ Sample Data

MERGE|CandidateAddress|CT123|2019/03/20|1257 Test1|HOME|Test|US|12576|NC|Wayne|Pikeville|

---

3️⃣ CandidatePhone

📌 HDL Metadata

METADATA|CandidatePhone|CandidateNumber|DateFrom|PhoneType|PhoneNumber|CountryCodeNumber|AreaCode|DateTo|Extension|LegislationCode|SpeedDialNumber|Validity|GUID
✅ Sample Data

MERGE|CandidatePhone|CT123|2019/03/20|H1|9605804|1|262|4712/12/31||US|||

---

4️⃣ CandidateName

📌 HDL Metadata

METADATA|CandidateName|EffectiveStartDate|EffectiveEndDate|CandidateNumber|NameType|LegislationCode|FirstName|LastName
✅ Sample Data

MERGE|CandidateName|2019/03/20||CT123|GLOBAL|US|Amar|Test

---

5️⃣ CandidateProfile (Degree / Profile Items)

CandidateProfile is used for things like:

• Degree

• Certifications

• Skills

• Previous employment

• Education details

📌 HDL Metadata

METADATA|CandidateProfile|CandidateNumber|ContentType|ContentItem|SectionContext|DateFrom|ItemDate7|ItemNumber9|ItemText2401|CountryGeographyCode|CountryCountryCode|ProfileItemId

✅ Sample Data

MERGE|CandidateProfile|CT123|DEGREE|BA - Bachelor of Arts|PERSON_DEGREE|2019/03/20|2019/03/20|||US|US|122

---

✅ Best Practices (Important)

✔ Always Follow this Order in Candidate.dat

Recommended sequence:

1. Candidate

2. CandidateName

3. CandidateAddress

4. CandidatePhone

5. CandidateProfile

---

✔ Date Format

Use:

• YYYY/MM/DD
  Example:

• 2019/03/20

---

✔ Effective End Date

Use:

• 4712/12/31

---

❌ Common Errors & Fixes

1) Candidate already exists

Error: Duplicate candidate number
✅ Fix: Use unique CandidateNumber

---

2) Invalid country / legislation code

Error: Invalid CountryCode or LegislationCode
✅ Fix: Use valid values like:

• Country: US, IN

• LegislationCode: US, IN

---

3) AddressType invalid

Error: AddressType HOME not valid
✅ Fix: Use correct address type based on setup:

• HOME

• MAILING

• WORK

---

4) ProfileItemId issue

Error: Profile item not created
✅ Fix: Ensure ProfileItemId exists OR remove ProfileItemId for new inserts.

---

🔗 Internal Links 

Add these links at the bottom or inside the blog:

• HDL Load Worker Data (Complete Guide)

• HDL Template – Benefit Enrollments

• HDL Template – Person Contact

• eText BIP Report

• Common HDL Errors and Fixes

---

⭐ FAQ 

Q1. Which file is used to load candidate data in HDL?

Candidate.dat is used to load candidate records in Oracle Fusion Recruiting.

Q2. Can we load Candidate Address using HDL?

Yes, using CandidateAddress in Candidate.dat.

Q3. How to load candidate education or degree in Oracle HDL?

Use CandidateProfile with ContentType like DEGREE,Education etc.

Q4. What is the best Effective End Date in HDL?

Most implementations use 4712/12/31.

HDL Template for Content Item

 For this use ContentItem.dat file.

You can see step by step video to load Content Item data for talent profile using this Link

Find Content Item Value set Name using below Query - 

SELECT 

a.content_value_set_id as ContentItemValueSetId, 

a.content_value_set_code, 

b.value_set_name as ContentItemValueSetName, 

value_set_description

FROM FUSION.hrt_content_tp_valuesets_b a, FUSION.hrt_content_tp_valuesets_tl b

WHERE a.content_value_set_id = b.content_value_set_id

and b.language = 'US' ;

Please find the below sample template :

METADATA|ContentItem|SourceSystemOwner|SourceSystemId|ContextName|ContentItemCode|Name|ItemDescription|DateFrom|DateTo|ContentItemValueSetName

MERGE|ContentItem|XXTEST|XXTEST_BTECH|DEGREE||BTECH|BTECH|1951/01/01||Degrees

HDL Template for Talent Profile in Oracle Fusion HCM (TalentProfile.dat + Examples + Common Errors)

HDL Template for Talent Profile in Oracle Fusion HCM

Load Talent Profile Data Using HCM Loader (HDL)

TalentProfile.dat Step-by-Step Guide + Examples

Oracle Fusion HCM provides the Talent Profile feature to manage employee skills, languages, certifications, competencies, and other professional attributes. To load or migrate talent profile data in bulk, Oracle supports HCM Data Loader (HDL) using the TalentProfile.dat file.

In this blog, we will walk through:

• Talent Profile HDL overview

• Required HDL objects

• Sample HDL template

• Common mistakes and best practices

📹 You can also watch the step-by-step video to load Talent Profile data using HDL from the provided link.

---

📌 What Is Talent Profile in Oracle Fusion HCM?

Talent Profile allows organizations to capture and manage:

• Skills

• Languages

• Certifications

• Education

• Licenses

• Competencies

This data is widely used in Talent Management, Recruiting, Learning, and Succession Planning modules.

---

📂 HDL File Used for Talent Profile

To load Talent Profile data, use the following HDL file:

TalentProfile.dat

This file primarily uses two business objects:

• TalentProfile

• ProfileItem

---

🔹 TalentProfile HDL Object

The TalentProfile object defines the main profile linked to a person.

🔸 Sample Metadata & MERGE

METADATA|TalentProfile|SourceSystemOwner|SourceSystemId|Description|
Summary|ProfileTypeCode|ProfileCode|ProfileStatusCode|ProfileUsageCode
|PersonId

MERGE|TalentProfile|XXTEST|XXTEST_TALENT2|||PERSON|PERSON_TALENT|A|P
|100000609812368

🔑 Key Fields Explained

• ProfileTypeCode → PERSON

• ProfileCode → PERSON_TALENT

• ProfileStatusCode → A (Active)

• ProfileUsageCode → P (Person)

• PersonId → Person ID from Fusion

---

🔹 ProfileItem HDL Object

The ProfileItem object stores the actual talent details such as languages, skills, certifications, etc.

🔸 Sample Metadata & MERGE (Language Example)

METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|
ProfileId(SourceSystemId)|ContentType|ContentItem|SectionName|
CountryCountryCode|DateFrom|DateTo|RatingModelCode1|RatingModelCode2
|RatingModelCode3|RatingLevelCode1|RatingLevelCode2|RatingLevelCode3

MERGE|ProfileItem|XXTEST|XXTEST_TALENTPROF2|XXTEST_TALENT2|LANGUAGE
|Hindi|PERSON_LANGUAGE||2021/07/26||LANGUAGE|LANGUAGE|LANGUAGE|
HIGH|HIGH|HIGH

🔑 Key Fields Explained

• ProfileId(SourceSystemId) → SourceSystemId from TalentProfile

• ContentType → LANGUAGE

• ContentItem → Hindi

• SectionName → PERSON_LANGUAGE

• RatingModelCode → LANGUAGE

• RatingLevelCode → HIGH

---

🧩 Supported Content Types in ProfileItem

Some commonly used ContentType values:

• LANGUAGE

• SKILL

• CERTIFICATION

• EDUCATION

• LICENSE

Each content type may have different required attributes depending on configuration.

---

⚠ Common Errors & Troubleshooting

Talent Profile Load Common Issues

---

✅ Best Practices

✔ Load TalentProfile first, then ProfileItem
✔ Use consistent SourceSystemOwner
✔ Validate lookups for ContentType and RatingModel
✔ Test loads in lower environments
✔ Use MERGE instead of CREATE for updates

---

❓ Frequently Asked Questions (FAQ)

Q1. Which HDL file is used for Talent Profile?

Use TalentProfile.dat to load Talent Profile and Profile Items.

Q2. Can we load multiple skills or languages?

Yes. Use multiple ProfileItem records linked to the same TalentProfile.

Q3. Can Talent Profile be updated using HDL?

Yes. Use MERGE with the same SourceSystemId.

Q4. Is PersonId mandatory?

Yes. Talent Profile must be linked to a valid person.

---

🔗 Related Articles (Internal Linking)

• 🔗 Load Worker Data Using HCM Loader

• 🔗 Common Errors During Worker HDL Load

• 🔗 HDL Template for Dependent Enrollment

• 🔗 Change Primary Work Relationship Using HDL

---

📈 Conclusion/ Highlights 

HDL provides a reliable and scalable way to load Talent Profile data in Oracle Fusion HCM. By correctly using TalentProfile and ProfileItem objects, you can efficiently migrate or maintain talent information such as skills and languages.

TalentProfile.dat HDL template Oracle Fusion HCM

If you found this helpful, bookmark this page and explore other HDL templates available on this blog.

HDL Template for Legislative Data Group

  For this use LegislativeDataGroup.dat file.

You can see step by step video to load Legislative Data Group using this Link

Please find the below sample template :

METADATA|LegislativeDataGroup|Name|DefaultCurrencyCode|LegislationCode|StructureInstanceName|SourceSystemOwner|SourceSystemId

MERGE|LegislativeDataGroup|US_LDG|USD|US|US Cost Flex Instance|XXTEST|XXTEST_LDG01

HDL Template for Documents Of Record

 For this use DocumentsOfRecord.dat file.

You can see step by step video to load Documents Of Record using this Link

Please find the below sample template :

METADATA|DocumentsOfRecord|SourceSystemOwner|SourceSystemId|DocumentsOfRecordId|PersonNumber|DocumentTypeId|DocumentType|Country|DocumentCode|DocumentName|DocumentNumber|DateFrom|DateTo|IssuingAuthority|IssuedDate|IssuingCountry|IssuingLocation|Comments|Publish|PublishDate|Status|VerifiedBy|VerifiedDate

MERGE|DocumentsOfRecord|XXTEST|XXTEST_DOCREC01||XXTEST2||Passport||XXTEST_DOCREC01|Passport|XXTEST2123|||||US|||||||

METADATA|DocumentAttachment|SourceSystemOwner|SourceSystemId|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|Title|URLorTextorFileName|File

MERGE|DocumentAttachment|XXTEST|XXTEST_DOCREC01|XXTEST2|Passport||XXTEST_DOCREC01|passport.png|passport.png|FILE|passport.png