Thursday, November 3, 2016

HCM Data Loader in oracle HCM Cloud

For all the HDL documentation, Refer to Oracle HCM Data Loader: User Guide (Doc ID 1664133.1)

HCM Data Loader is a powerful tool for bulk-loading data from any source to Oracle Fusion Human Capital Management (Oracle Fusion HCM).

HCM Data Loader:

Supports important business objects belonging to key Oracle Fusion HCM products, including Oracle Fusion Global Human Resources, Compensation, Absence Management, Performance Management, Profile Management, Global Payroll, Talent and Workforce Management.
Is available in cloud, on-premises, and on-demand environments.
Supports one-time data migration, maintenance of Oracle Fusion HCM data via upload, and coexistence scenarios, where core HR data exists outside Oracle Fusion.
Provides a comprehensive user interface for initiating data upload, monitoring progress, and reviewing errors, with real-time information provided for both the import and load stages of its processing.
Supports multithreaded processing, which enables you to upload complete system extracts without severe performance impacts. HCM Data Loader manages references among objects that are processed on separate threads.
Includes a delimited-file reader that can identify file contents from metadata included in the file that you upload. This feature enables you to perform partial or incremental loads, thereby minimizing the related processing.
Supports user keys for integration-enabled objects. Knowledge of Oracle Fusion internal IDs is not required.
Enables bulk update and deletion of objects, regardless of whether they were created using HCM Data Loader.
Loads all data files from the Oracle WebCenter Content server, which provides a single point of entry to Oracle Fusion HCM.
Can be initiated using a web service call, which enables you to automate data upload.
Is function-rich. For example, you can upload:
o Current and historical records for date-effective objects. You determine the amount of history to load.
o End-dated, terminated, or inactive records.
o Translated attributes in multiple languages. The WE8ISO8859P1 character set (West European 8-bit ISO 8859 Part 1) with UTF-8 encoding is supported.
o Descriptive flexfields (DFFs) and extensible flexfields (EFFs).
o Data from multiple sources. You can include source-system references in uploaded data.

Steps to do after HDL Load:

Step1: The post load process 'Update Person Keyword Search' would need to be executed with the correct parameters to able to populate the Person Type Usage information otherwise the Person Type Usage would not be populated which will end up with the employee not being visible through Person Management.

1. Navigate to Scheduled Processes. (Navigator>Tools>Scheduled Processes)

2. Click Schedule New Process

3. Search for "Update Person Search Keywords" Process

4. Select the process and click OK

5. Leave the Name parameter blank and select 'Yes' for After Batch Load parameter.

6. Click Submit.

7. When the process completes successfully, Navigate to Person Management and search for the employee again.

Step 2: Once we load the user info through HDL, we need to run "Send Pending LDAP Request" first and then "Retrieve Latest LDAP Changes" processes. Please go through the below link for the same,


  1. your site is visible to see sir
    thank you for your valluable information sir

  2. Hey Really Thanks for sharing the best information regarding human capital management applications,hope you will write more great blogs.

    Oracle Fusion Financials Online Training