Introduction to Oracle Fusion HCM Data Loader

HCM Data Loader aka (also known as ) HDL is the next generation Data Loading Tool used in Fusion Applications.

Mostly used in all new implementation starting July 2015 this tool has tremendously advanced features compared to its predecessor FBL (File Based Loader).

In this article we would try to understand what HDL is and also a brief understanding of key concepts associated with the same.

Role required for using HCM Data Loader is Human Capital Management Integration Specialist

So without much ado let’s begin….

Major Enhancements Over FBL

1. Bulk loading of HCM data from any source

2. Data-migration or incremental updates

3. Flexible, pipe-delimited file format

4. Comprehensive bulk loading capabilities

5. Automated and user managed loading

6. Stage Table Maintenance

While the above 6 are the ones mostly stated and popularly advertised features I have a slightly different view and they are :

1. Bulk Loading of HCM Data from any source

This point to me doesn’t seems valid as FBL also used to do the same thing and hence I will discard this

2. Data Migration or incremental updates

FBL does the same but if you have say ‘N’ records for an employee and you want to add one more records you need to pass all N+1 records

Using HDL you would be required to just pass the (N+1) Th record so a major enhancement  

3. Flexible, pipe-delimited file format

Available in FBL too hence discarded again.

4. Comprehensive bulk loading capabilities

A very new advanced and enhanced feature.

5. Automated and user managed loading

FBL can also be automated using web service call hence again discarded.

6. Stage Table Maintainenace

This again was in FBL too hence discarded again.

So now we will primarily discuss about 2 points namely :

1. Data Migration or Incremental Updates

2. Comprehensive Bulk Loading Capabilities.

Data Migration Or Incremental Updates

We will take an example of various events in an individual’s life and co-relate the same as Data Transactions.Details of same explained below :

Hire an Employee

Ms. Sandra Mora is a lady who joins a company and becomes employee on 15 Jun 2003. She gets a unique identifier (Like SSN for US , PAN Card for India to uniquely identify a individual, similarly each company has a unique identifier to identify an employee this unique identifier is referred to as Employee Number ) no 12345.

Marital Status Change

She gets married on 21st Aug 2006 and undergoes following changes in her employee record:

1. Title: Gets changed from Ms to Mrs.

2. Last Name :  Her Last Name gets changed from “Mora” to “Bjork”

3. Email Address :Her email address gets changed from This email address is being protected from spambots. You need JavaScript enabled to view it. to This email address is being protected from spambots. You need JavaScript enabled to view it.

She as a result of this change the previous record (Hire an Employee) gets end-dated on 20th Aug 2003 and a new record gets created on 21st Aug 2006

Middle Name Change

She gets a middle name added (she decided to have her husband’s first name added in her name on 16th July 2008) and a new record gets created.

1. Middle Name: Gets changed from     to Albert.

FTE Capacity Change

Starting 25th Sep 2009 she starts working only on 4 days a week instead of initial 5 days a week so her Full Time Equivalent (FTE) gets changed from 1 ( Actual Days Worked in a Week (5) / Total Working Days in a Week (5) ) to New Value 0.8 ( Actual Days Worked in a Week (4) / Total Working Days in a Week (5))

1. FTE Capacity Change: Gets changed from 1 to 0.8

Email Address Change

She undergoes a email address change as on 17th March 2012  

1. Email Address: Gets changed from This email address is being protected from spambots. You need JavaScript enabled to view it. to This email address is being protected from spambots. You need JavaScript enabled to view it.

Middle Name Change

She gets a middle name added (she decided to have her father’s first name added in her name on 12th Dec 2003) and a new record gets created.

1. Middle Name: Gets changed from Albert to Frank.

The same details represented in a Tabular Format for easier understanding.

Comprehensive Bulk Loading Capabilities

HCM Data Loader Supported Business Objects

Flexible Pipe-Delimited File Format

Automated Or User Managed Processing

Import and Load Data

Progress Icons

File Line Counts

Object Counts

Object Errors

Stage Table Maintainenance

HDL Feature Guidelines

While Performing Conversion : Step 1 -> Configure Source System Owner

There could be multiple sources from which data can be migrated to Fusion , hence a Source System Owner needs to be configured for unique identification of Legacy Data Source. Below screenshot shows how to configure the same.

While Performing Conversion: Step 2 -> Configure Hcm Data Loader

HCM Data Loader : Error Reports Generation Using Delivered HCM Extracts

As with all delivered HCM Extracts, it is recommended that you make a copy of the HCM Data Loader Data Set Summary extract and alter the output to your requirements.

Navigate to the Manage Extract Definitions task available from the Data Exchange work area.

Query the HCM Data Loader Data Set Summary extract.

You click the copy icon to copy the seeded extract, supply your name for the copied extract.

Once your copy is successfully created you can retrieve it by searching for it by name.  Click on the name in the Search Results to make your required changes

Implementation Decision Points

Last but not the least “Human Capital Management Integration Specialististhe Role Required to Perform Conversion.” . That brings me to end of the topic.

Thanks a lot for all your time .. Have a Nice Day!!!!!!!!!!!!!

Ashish Harbhajanka

Add comment