Configuring HCM Data Loader Parameters
Configuring HCM Data Loader Parameters

 1,558 total views

One of the first step to use HCM Data Loader is to Configure the HDL Parameters. In this article we will discuss available options and evaluate pros and cons for each.

Want to learn Fusion Technical tools? Checkout this article

Where to Configure the HCM Data Loader Parameters?

Navigate to Setup and Maintenance and Search for “Configure HCM Data Loader” and open the task

Configure HCM Data Loader parameters in Fusion HCM Oracle HCM Cloud HDL

We will discuss some of the important Parameters which impact the HDL loads.

HCM Data Loader Scope: Limited/Full.. This parameter was introduced in R10 and at that time FBL and HDL both were used for data loads. Now in R13 Oracle is decommissioning the FBL tool completely, this parameter is defaulted to Full for all new customers since R11 release.

Enable Audit Data: Yes/No – Specifies whether audit data is captured for business objects loaded using HCM Data Loader. If you set this parameter to Yes, then audit must also be enabled for Oracle Fusion Applications.

Enable Load Group Size Calculation: Specifies whether the load-group size is to be calculated automatically. Set to Yes to enable the optimal load-group size to be calculated based on the number of objects to process and the available concurrent threads. When Enable Load Group Size Calculation is Yes, the Load Group Size parameter doesn’t appear on the Schedule Request page. Also, the default value of the Load Group Size parameter is ignored.

Purge Person Enabled Key: Key value supplied by Oracle Support to enable the Purge Person Data in Test Environments process. You can’t enable and run this process in production environments.

Business Object Parameters:
Calculate Worker Full Time Equivalent: Yes/No – Set this Flag if the FTE needs to be calculated automatically for all worker assignments in Worker.dat
Create Worker Default Work Hour Pattern: Yes/No – Set this to Yes if the workers need to have a default Work Hour Pattern when they are loaded.

You can also validate the data in this configuration page using a SQL Query:

SELECT * FROM HRC_DL_PARAMETERS

HDL Coniguration settings
HDL Coniguration settings

For more details on all parameters, please check Oracle Documentation at https://docs.oracle.com/en/cloud/saas/applications-common/18c/faihm/preparing-to-use-hcm-data-loader.html#FAIHM2049232

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply