0
0
HCM Data Loader (HDL) is Oracle’s primary tool for uploading and updating data in the HCM Cloud system. It allows users to handle bulk data, such as employee information, assignments, documents, and other HR-related records, all in one go.
HDL works with pipe-delimited files where all required information for a business object (like employee details, assignments, and relationships) is included in one file. These files are then zipped and uploaded to the system. HDL automatically understands the correct order to process the data, ensuring everything is loaded correctly.
Users can monitor the upload status using the "Import and Load Data" page and quickly review errors and messages through a detailed error management interface. This helps quickly identify and fix any issues with the data.
HDL also supports automation using web services so that files can be uploaded and processed without manual steps. This makes the process faster and more efficient.
These examples demonstrate how HDL supports loading different types of data — not just employee core data, but also related details like contacts, documents, citizenship, and addresses.
Example 1 – Person, WorkRelationship, Assignment (Basic Employee Data)
METADATA|Person|SourceSystemId|PersonNumber|FirstName|LastName|Sex|DateOfBirth
MERGE|Person|EMP2001|EMP2001|David|Brown|M|1987/07/18
METADATA|WorkRelationship|SourceSystemId|PersonNumber|LegalEmployerName|StartDate|WorkerType
MERGE|WorkRelationship|WR2001|EMP2001|Vision Corporation|2023/04/01|Employee
METADATA|Assignment|SourceSystemId|PersonNumber|AssignmentNumber|BusinessUnit|JobName|Department|Grade|AssignmentStatusType|EffectiveStartDate
MERGE|Assignment|AS2001|EMP2001|ASG2001|Vision Business Unit|Technical Analyst|IT Department|G4|Active|2023/04/01
Example 2 – Contact (Emergency Contact or Dependent)
METADATA|Contact|SourceSystemId|PersonNumber|ContactType|ContactFirstName|ContactLastName|Relationship|DateOfBirth|Gender
MERGE|Contact|CNT2001|EMP2001|Emergency Contact|Emma|Brown|Spouse|1988/09/10|F
Example 3 – Document of Record
METADATA|DocumentOfRecord|SourceSystemId|PersonNumber|DocumentType|DocumentName|DocumentNumber|IssueDate|ExpirationDate
MERGE|DocumentOfRecord|DOC2001|EMP2001|Employment Agreement|EmpAgreement2023|EA12345|2023/04/01|2026/04/01
Example 4 – Citizenship
METADATA|Citizenship|SourceSystemId|PersonNumber|Country|CitizenshipStatus|StartDate
MERGE|Citizenship|CTZ2001|EMP2001|United States|Citizen|1987/07/18
Example 5 – Address (Home Address)
METADATA|Address|SourceSystemId|PersonNumber|AddressType|AddressLine1|City|PostalCode|Country|StartDate
MERGE|Address|ADDR2001|EMP2001|Home|123 Elm Street|San Francisco|94107|US|2023/04/01
Example 6 – Work Terms (Optional, if managed separately from Assignment)
METADATA|WorkTerms|SourceSystemId|PersonNumber|WorkTermsNumber|LegalEmployerName|StartDate|BusinessUnit|JobName|Department
MERGE|WorkTerms|WT2001|EMP2001|WTEMP2001|Vision Corporation|2023/04/01|Vision Business Unit|Technical Analyst|IT Department
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.