Talent Profile HDL File Upload in Oracle Fusion HCM

Oracle Fusion HCM provides a robust way to manage employee information, including Talent Profiles. A Talent Profile captures employee skills, qualifications, certifications, work preferences, and career aspirations. To upload or update this information for multiple workers at once, HCM Data Loader (HDL) is the recommended tool.

In this blog, we will walk through:

1. Understanding HDL for Talent Profile

2. Preparing the HDL File Structure

3. Sample HDL File for Talent Profile Upload

4. Uploading the HDL File in Fusion HCM

   
   

1. Understanding HDL for Talent Profile

HCM Data Loader (HDL) is Oracle’s bulk data loading tool for Fusion HCM. It allows HR teams and administrators to:

• Insert new records (such as skills, competencies, or education details).

• Update existing employee profile data.

• Maintain consistent employee records across the enterprise.

For Talent Profiles, HDL supports objects like:

• TalentProfile (Profile header for a worker or a job).

• ProfileItem (Skills, certifications, education, languages, etc.).

• ContentSection (Logical grouping of profile content).

  
  

2. Preparing the HDL File Structure

HDL files are .dat files written in a specific format. A typical Talent Profile HDL upload requires:

• Header section → Defines the entity (TalentProfile, ProfileItem).

• Attributes → Columns that represent worker IDs, profile item codes, start/end dates, and so on.

• Sequence → Each line is processed in sequence, so dependencies must be respected.

  
  

3. Sample HDL File for Talent Profile Upload

Here’s a simplified HDL example to add a new skill for a worker’s profile:

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

MERGE|TalentProfile|HRC_SQLLOADER|TP_300000035700595|||PERSON|Pers_3000000357005|A|P|3000000357005

METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId(SourceSystemId)|DateFrom|DateTo|ContentItem|ContentItemId|ContentType|ContentTypeId|SectionId|ItemDate6|ItemText2404|FLEX:HRT_PROFILE_ITEMS|certificateName(HRT_PROFILE_ITEMS=PERSON_CERTIFICATION)|yearOfPassing(HRT_PROFILE_ITEMS=PERSON_CERTIFICATION)

MERGE|ProfileItem|HRC_SQLLOADER|TP_Certificate_3000000357005|TP_3000000357005|1951/01/01|4712/12/31|Certificate||Certification|103|3000000721158|||PERSON_CERTIFICATION|100|

Before we preparing the HDL file, you need to identify the Content Type id and Section ID that your data will be uploaded against. For example, if you’re uploading licenses, certifications, or skills, you must ensure that the codes you reference exist in Fusion HCM.

 SQL query to get Content Type id

SELECT

    HPTS.SECTION_ID

FROM

    HRT_PROFILE_TYP_SECTIONS HPTS

WHERE

    HPTS.CONTENT_TYPE_ID = 103

SQL query to get Section ID

SELECT

    HCT.CONTENT_TYPE_ID

FROM

    HRT_CONTENT_TYPES_VL HCT

where

    HCT.CONTENT_TYPE_NAME='Licenses and Certifications'

4. Uploading the HDL File in Fusion HCM

Steps to upload the HDL file:

1.     Login to Fusion HCM with an HCM Data Loader role.

2.     Navigate to Data Exchange → HCM Data Loader → Import and Load Data.

3.     Click + Import File, then upload your .zip package containing the .dat file.

o   Example: TalentProfile.dat → Compress into TalentProfile.zip.

4.     Click Submit to start the load process.

5.     Monitor progress in the Data Exchange → View Loader Results page.