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
-
Bulk loading of HCM data from any source
-
Data-migration or incremental updates
-
Flexible, pipe-delimited file format
-
Comprehensive bulk loading capabilities
-
Automated and user managed loading
-
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 :
-
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
-
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
-
Flexible, pipe-delimited file format
Available in FBL too hence discarded again.
-
Comprehensive bulk loading capabilities
A very new advanced and enhanced feature.
-
Automated and user managed loading
FBL can also be automated using web service call hence again discarded.
-
Stage Table Maintainenace
This again was in FBL too hence discarded again.
So now we will primarily discuss about 2 points namely :
-
Data Migration or Incremental Updates
-
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:
-
Title: Gets changed from Ms to Mrs.
-
Last Name : Her Last Name gets changed from “Mora” to “Bjork”
-
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.
-
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))
-
FTE Capacity Change: Gets changed from 1 to 0.8
Email Address Change
She undergoes a email address change as on 17th March 2012
-
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.
-
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!!!!!!!!!!!!!