HDL (HCM Data Loader)

 

HDL stands for HCM Data Loader. It provides the flexible and efficient way to load data into Oracle Fusion HCM.

àIt performs complex data transformations.

àUsing HDL, we can load data into various HCM objects such as:

Locations,

Job Profile,

Worker or Employee,

Assignments and more.

It supports various formats such as: CSV,XLS,XLSX

==============================================

Features of HDL are:

Managing and Validating of your data,

Data Transformation,

Data Mapping,

Data Validation,

Error Handling.

We can use HDL to perform batch uploads(import), updates, deletions and export data from oracle Fusion HCM.

Process:

àLog in to HCM implementation user,click on “My Client Groups”-à”Data Exchange”.

àIn Data Exchange, click on “View Business Objects”.

         

Search for the Business Object called "Location."

è Download the template called “Location.dat”

è Right click on Location.dat file and open with Notepad++.

You will be getting the data and from that choose the attributes in which you want to load the data:

Save the file in the same path without changing the name.

è Right click on “Location.dat”àChoose “Send To ”à Compressed (zipped folder) and rename it.

Now, go back to “Data Exchange” and click on “Import and Load Data”.

àClick on “Import File”

àChoose the file and browse the (Zipped) folder.

Once you upload the folder, click on “Refresh."

àImport is successfully when you see green check mark under import/load status.

àNow, click on “Recent File Loads”.