Learn HCM Data Loader online

In this article I will guide you through learning HCM Data Loader and some of the advanced features of HDL including the configuration, SET commands, Source System Owner, Sample HDL Files, etc.

Links to the HCM Data Loader articles:

• Basics of HCM Data Loader in FusionJanuary 29, 2019
  Total Visits: 178In this article we will go through the basics of HCM Data Loader aka HDL which is one of the most familiar data loading tools in Fusion HCM. Here is the Agenda for this post: What is HCM Data Loader? Configure HCM Data Loader Parameters Who Can Load Data Using HCM Data Loader?…
• Sample CostAllocationAccountV3.dat HDL fileJanuary 30, 2019
  Sample HDL file to load Cost Allocation Accont details. Also look into how the cost allocation details are setup and check details on it.
• Configuring HCM Data Loader ParametersJanuary 31, 2019
  Total Visits: 54One 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…
• Defining Source System Owner for HCM Data LoaderJanuary 31, 2019
  Do you know how to configure Source System Owner in Fusion HCM for HCM Data Loader? Read on to know more details and how to use it in HDL files
• SET Operations on HDL file in FusionJanuary 31, 2019
  Do you know all possible SET Commands that can be used in HDL? If not go through this article it lists all possible SET commands for HCM Data Loader
• SQL Query to get Supervisor Change HDL for AssignmentFebruary 8, 2019
  Do you know how to create the supervisor update HDL file using SQL Query? Within a few minutes you will be able to update supervisor for a bunch of employees. Read on to know more details.
• Cancel an existing Work Relationship using HDL for employeesApril 15, 2020
  Total Visits: 45In this article we will look into cancelling an existing Work Relationship of an employee using HDL process. We can prepare the HDL file with the required user keys to delete the work relationship. Sample HDL to delete Work Relationship(Worker.dat): When we have a requirement to cancel multiple work relationships due to bad…
• Sample HCM Data Loader (HDL) files for all Business ObjectsApril 20, 2020
  Are you facing issues with loading dat files to HCM Data Loader and need help with the sample files? You can get sample HDL files for most of the business objects in this article.
• New Deadline for Payroll Batch Loader 20D Nov 2020April 23, 2020
  Total Visits: 41In this post we will look into the PBL to HDL mapping for business objects and things that we need to take care of before the PBL is decommissioned by 20D. If you check the previous article Oracle has provided a deadline of 20C for decommissioning Payroll Batch Loader aka PBL. However they have…
• Generate HDL file for failed business object LinesMay 2, 2020
  Do you know that we can generate the failed business object file lines in the format of dat file by clicking the “Extract Failed Lines” feature from 20B. Read on to know the configuration required for it.
• Resolving Assignment Name and Job Name not in sync issueMay 8, 2020
  Do you know how to fix the Job Name and Assignment Name are not in sync issue on Employment page? What could be the reasons for this corruption of data and how to correct it? Read on to know more details
• Useful Excel to HDL DAT File ConverterMay 19, 2020
  How do you create DAT files? Manually? If yes then you are wasting your time doing that? Check out the Excel to HDL Converter which saves your time.
• SQL Query to get Scheduled Process Job HistoryMay 23, 2020
  Do you know how to get the Scheduled Processes history from underlying tables? How to get the BI Report Job History? Read on to know more details
• Invoke HCM Data Loader using SOAP ServiceMay 26, 2020
  Do you know how to invoke HCM Data Loader using SOAP Service? What should be passed in the payload and how to get status of the process?
• How to send/stop welcome email notifications to users using HDLMay 27, 2020
  Do you know how to send Password Reset Notifications to Users using HCM Data Loader? Do you require any post processes to run? Read on to know more details.
• Update Source Keys using HDL for business objectsJune 2, 2020
  Do you know that we can update the Source Keys after they are loaded? Which DAT file to use? How does the sample DAT file look like? Read on to know more details
• Top 50 HCM Data Loader Interview QuestionsJune 5, 2020
  Top 50 Interview Questions on HCM Data Loader with real time scenarios in Fusion HCM. Can you answer them if you were asked during an interview? Read on to know more details.
• How to ROLLBACK Element Entry HDL Load?June 12, 2020
  Do you know that from 19D Oracle has released ROLLBACK feature for HDL Business objects starting with Element Entry Business Object? Read on to know more details.
• Basics of HDL Transformation Formula Part 1June 16, 2020
  Do you know the HDL Transformation Formula in Fusion HCM? What are the use cases of it? How to use it? FAQs on it? Read on to know more details.
• How HDL Transformation Formula works with ElementEntry SampleJuly 30, 2020
  Do you know the HDL Transformation Formula and how it works? What are the building blocks of it? Read on to know more details.
• How to use escape and new line characters in HDL fileJuly 31, 2020
  Do you know that you can use escape characters to load the | and new line characters using the HDL file? Can you override the default settings? Read on to know more details.
• HDL transformation Formula Flow changes in 20CAugust 10, 2020
  Do you know that Upload File option has been added to the “Load Data from File” flow which uses the HDL Transformation Formula? Read on to know more details.
• HDL Transformation Formula using HSDL Template for UDT LoadSeptember 8, 2020
  Do you know that we can use HSDL Template in HDL Transformation Formula? What are the advantages of this approach? Read on to know more details.
• HCM Data Loader Error ReportNovember 10, 2020
  Have you used HCM Data Loader Error Report earlier to extract all errors from the HDL Load? Old version of the report doesn’t work for protected data sets post 20C upgrade. Read on to know more details.
• Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20DNovember 12, 2020
  Do you know that you can fetch the HDL Imports and HCM Extract Run Details using OTBI from 20D? Read on to know more details.
• How to load Global and Local Names using HDL?December 28, 2020
  Do you know how to load Global and Local Names for employees using HDL? What are the pre-requisites for it? Check our for more details.
• Ready to use Worker Sample HDL files for multiple scenariosMarch 6, 2021
  Do you have the Worker HDL files handy for multiple scenarios? Are you aware of which attributes are required for global transfer/ termination/ rehire etc? Read on to know more details.
• How to Convert Pending Worker to Employee using HDL?April 8, 2021
  Do you know how to convert Pending Worker to Employee using HDL? Read on to know more details.
• How to Reverse Terminate employees using HDL?May 7, 2021
  Do you know how to reverse terminate employees using HDL? Can you use SQL Query to generate the HDL file for reverse termination? Read on to know more details.
• How to update Termination Record using HDL?June 29, 2021
  Do you know how to correct the termination record with new termination date and new action/ action reason combination? Read on to know more details.
• How to Scramble the Salary information post P2T Refresh?June 30, 2021
  Do you know how to scramble/mask the salary information post P2T refresh? Salary information is sensitive and confidential and it’s better to mask this information in lower environments. Read on to know more details.
• How to add SET commands in HDL file using HDL Transformation Formula?July 23, 2021
  Do yo know how to add the SET instructions to the HDL file using HDL Transformation formula? Read on to know more details.
• We can still load ElementEntry business object using PBL till 22AJuly 23, 2021
  Do you know that you can still use the Element Entry Business Object in Payroll Batch Loader (PBL) till 22A update? All other business objects will get decommissioned with 21B update. Read on to know more details.
• How to load Payroll Balance Definition using HDL?August 24, 2021
  Do you know what’s the importance of Payroll Balance Definitions? Can we load them in bulk using HDL? Read on to know more details.
• Have you used HCM Data Loader Dashboard?September 20, 2021
  Do you know the features of HCM Data Loader Dashboard? What all does it cover? From which release can we use it? Read on to know more details.
• SQL Query to fetch HCM Data Loader Load SummarySeptember 28, 2021
  Do you know how to fetch the HCM Data Loader status from backend tables? Does it pull both HDL and HSDL data loads? Read on to know more details.