Monday, 26 July 2021

HDL Template for Talent Profile

HDL Template for Talent Profile in Oracle Fusion HCM

Load Talent Profile Data Using HCM Loader (HDL)

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:

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)

📈 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.

Highlights

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

Oracle Fusion HCM Tutorial Blog

Monday, 26 July 2021