HCM Data Loader

 HDL is a robust and powerful tool to load data in Fusion. It is flexible file format .dat with pipe-delimited to structure the data to import. It handles complex data structures, such as parent child relationships.

It allows complete data load and incremental data load. It provides detailed error log for each object if we have any failures at Import stage or during Load stage.

HDL supports different keys User Keys, Source Keys and GUID. 

User Keys are preferred for manual HDL or updates with known values. 

Source Keys are preferred for initial data loads, automated integration and to update existing information people will use these keys.

GUID - Globally Unique Identifier, this is system generated and rarely used in Data Migration activities.

User Keys: 

• These are business-meaningful keys used by users.

• Typically, these are combinations of fields that uniquely identify a record.

• Example (for Worker.dat), PersonNumber, EffectiveStartDate

Source Keys:

• These are used to support data loads from external systems.

• Comprise SourceSystemOwner and SourceSystemId

• You must set them when you're maintaining integration from an external system.

Use case: Best when loading data from an external source system that has its own identifiers (e.g., from SAP, Workday, or legacy HRMS).

SourceSystemOwner value can be configured in HRC_SOURCE_SYSTEM_OWNER lookup to identify what is the actual source of data.

Navigation: 

Login and navigate to Setup and Maintenance area and search for the task Manage Common Lookups and search for HRC_SOURCE_SYSTEM_OWNER in lookup type field.