Oracle Fusion HCM Data Loader (HDL)

Oracle Fusion HCM Data Loader

HCM Data Loader is a powerful tool for bulk-loading and maintaining data. The data can be from any source. You can use HCM Data Loader for data migration, ongoing maintenance of HCM data, and coexistence scenarios, where core HR data is uploaded regularly.

HCM Data Loader Process

 

The steps of this process are:

1. You place a .zip file containing your .dat files on the Oracle WebCenter Content server.
   
2. You submit a request to HCM Data Loader to import and load the .zip file. For this step, you can use either the HCM Data Loader interface or the HcmCommonDataLoader web service.
   
3. HCM Data Loader decompresses the .zip file and imports individual data lines to its stage tables. In the stage tables, related data lines are grouped to form business objects.
   Any errors that occur during the import phase are reported on the HCM Data Loader interface.
   
4. HCM Data Loader calls the relevant logical object interface method (delivered in product services) to load valid objects to the application tables.
   Any errors that occur during the load phase are reported in the HCM Data Loader interface.
   
5. You review any errors from the import and load phases. You can perform this step either on the HCM Data Loader interface or using the HCM Data Loader Data Set Summary extract.
   
6. You correct errors from the import and load phases in your source data.
   
7. You load a new .zip file containing the corrected data to the WebCenter Content server.
   

You repeat this process from step 2 until all of the data is successfully loaded.