Explain HCM Data Loader (HDL) in Oracle Applications

35 / 60

Integrationintermediate

HCM Data Loader (HDL)

Explain how HDL is used for bulk loading and updating HCM data using a flat-file, delta-friendly format

HCM Data Loader (HDL) is Fusion HCM's dedicated bulk-loading tool, similar in purpose to FBDI but purpose-built for HCM's more complex, deeply hierarchical data model (workers, assignments, work relationships, compensation, benefits). Unlike FBDI's Excel-template-per-object approach, HDL uses a structured, delimiter-separated DAT file format organized by 'business objects' and 'components' (METADATA and MERGE directive lines) that can express complex parent-child relationships (like a worker record with nested assignment and salary components) in a single file.

HDL is like a detailed family-tree import file for a genealogy website: rather than uploading disconnected individual records, you submit one structured file expressing exactly how each person (worker) relates to their associated records (assignments, addresses), and the system intelligently merges new information into existing family trees or creates new branches as needed.

Key Concepts

HDL supports true delta/incremental loading natively — you can supply just the changed attributes for an existing record (an update) alongside brand-new records (inserts) in the same load, using MERGE as the default action, which Oracle intelligently interprets as insert-or-update based on whether the record already exists. This is particularly important for recurring integrations like new-hire feeds from a recruiting system or nightly worker attribute syncs from an external HRIS.

delta/incremental loadingMERGE

HDL files are uploaded to UCM (same repository FBDI uses) and processed by the Load and Import background process, generating detailed logs identifying exactly which records succeeded, failed, or were skipped, with specific error messages traceable back to individual source rows — critical for high-volume HR data operations where a small subset of bad records shouldn't block an entire nightly load.

Load and Import

Interviewers often ask candidates to explain the METADATA/MERGE structure of an HDL file and how it differs conceptually from FBDI's more rigid Excel-template approach, plus practical scenarios like loading a new hire's Person, Work Relationship, Assignment, and Salary records together in one coordinated file.