A week ago I started to learn new bulk loader feature HCM Data Loader which was recently released (You can see details here HCM Data Loader: Notice of General Availability (Doc ID 2022629.1))
I got ready to spend a lot of time, but I was wrong. It wasn’t very difficult to understand how it works.
HCM Data Loader is very flexible and easy in use. And I would like to share a little experience working with HDL.
Some additional features available in HDL in comparison with FBL
- Finally you don’t need to think about internal GUIDs of business objects. (Supports user keys for all objects. Knowledge of Oracle HCM Cloud internal IDs is not required)
- HDL can both create/update records and DELETE records. (Of course if you don’t have references from dependent objects)
- You can use |SourceSystemOwner|SourceSystemId| Attributes to hold references from third-party systems
- Now you can load translations for translatable business objetcs
- You can load attachments
- You can bulk load photos for employees
How it works
First of all you need to check HCM Data Loader Configuration Parameters. As far as I know starting from Release 10 HDL will be the main tool for bulk loading data into the system. In Release 9 you can still decide what tool you wish to use (FBL or HDL). To make sure that HDL will be accessible you have to set HCM Data Loader Scope parameter to Full.
To load data using HCM Data Loader, you must have the Human Capital Management Integration Specialist job role.
In addition you have to add the HCM Data Loader Duty to the Human Capital Management Integration Specialist Job Role.
Preparation of DAT File
You can download template files for every business object supported by HDL form the system.
You can use HCM Data Loader: Business Object Documentation (Doc ID 2020600.1) as a start point for preparation of DAT files.
There are a lot of instructions and features you can use in DAT file. You can read complete list of features in documentation. But I’d like to note: Never put MERGE and DELETE instructions into one DAT file.
Please see my Worker.dat sample:
As you can see the structure of HDL file is quite simple in comparison with the FBL file structure. Attachments and photos you have to put into separate directory (BlobFiles, ClobFiles) in ZIP file.
HCM Data Validator
And for validation of DAT file we can use Data Validator tool. You can read about it here: Data File Validator Tool for HCM Data Loader (Doc ID 2022617.1)
Import and Load
Finally you need to upload zip file to WebCenter Content Server and submit Import and Load Process.
To achieve full automation you can use tools for transferring HDL files to content Server and invoke web service (https://<url-to-your-environment>/hcmCommonDataLoader/HCMDataLoader?WSDL ) to submit import process.
See details here: Automating HCM Data Loader
Submit Import and Load process you can from Data Exchange Work Area:
And finally you can see my successfully loaded worker with the personal photo:
After loading workers, you usually need to run ESS jobs to perform specific operations:
- Update Person Search Keywords
- Synchronize Person Records
- Refresh Manager Hierarchy
Good Luck and remember:
“When you find your path, you must not be afraid. You need to have sufficient courage to make mistakes. Disappointment, defeat, and despair are the tools God uses to show us the way.” – (Paulo Coelho)
If you have any questions don’t hesitate to ask me.
I appreciate your time and ready to continue our discussion/collaboration in this area.