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:

• How to load CostAllocationAccountV3.dat HDL file?January 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
  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…
• 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
  In 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 data load/some…
• 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
  In 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 now postponed…
• 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.
• Comparison of HDL, HSDL, and APIs for Data LoadOctober 27, 2021
  Do you know which tool among HDL, HSDL and REST API is best suited for Data Conversions? Which tool is best suited for which type of user? Read on to know more details.
• How to load Element Entry and Costing Info using ElementEntryWithCosting HDL file?December 2, 2021
  Do you know how to load the Element Entry and Costing Information using ElementEntryWithCosting HDL file? This object has been introduced from 21A and Oracle is working on enhancements to this object with every release. Have you used this object? Are you aware of what this object can do and what this object can’t do? Read on to know more details.
• How to resolve HDL Error – HRC-1035375A Connection To The WebCenter Content Server Couldnt Be Established?December 6, 2021
  Have you faced error “HRC-1035375A Connection To The WebCenter Content Server Couldn’t Be Established” during the HDL upload? Do you know how to resolve this issue? Read on to know more details
• How to delete Calculation Cards using HDL?December 24, 2021
  Do you know how to delete the Calculation Cards using HDL? Does it delete all Calculation Card Components as well? Read on to know more details.
• How to modify the Person Number after hiring the employee?December 27, 2021
  Do you know the importance of Person Number Generation Method? Can we modify the Person Numbers if the Person Generation Method is set to Automatic? Can we modify the Person Numbers using HDL? Read on to know more details.
• How to set field values to NULL using HSDL?January 4, 2022
  Do you know how to set the BLANK value for a field using HSDL? Does passing blank value work? Read on to know more details.
• How to load Pipeline Requisitions using HDL?May 12, 2022
  Do you know how to load the pipeline requisitions using HDL? Read on to know more details.
• How to load and delete AssignedPayroll information using HDL?October 4, 2022
  Do you know how to load the AssigedPayroll information? Can we delete the AssignedPayroll information using HDL? Read on to know more details.
• How to load Time Card Required Flag on the Payroll Relationship screen using HDL?October 4, 2022
  Do you know how to set the Time Card Required field at both Assigned Payroll and Payroll Assignment levels? Can we do it using HDL? Read on to know more details.
• SQL Query to pull the HDL Loaded and Error RecordsNovember 23, 2022
  Do you know how to pull the loaded and errored records processed by HDL? Can we pull the individual chunk details processed internally by the HDL process? Read on to know more details.
• How to Schedule HCM Data Loader HDL Files?February 13, 2023
  Do you know if we can schedule HCM Data Loader files? How to check if there are any files scheduled for execution? Read on to know more details.
• How to bulk inactivate the Document Types using HDL?February 27, 2023
  Do you know how to inactivate the document types in bulk using hdl? Read on to know more details,
• How to load Payroll Elements using PayrollElementDetails.dat HDL?April 10, 2023
  Do you know how to create elements using HDL? Have you anytime used PayrollElementDetails.dat to load payroll elements? Read on to know more details.
• Resolve HDL Error: The values Element Name, LDG are not valid for the attribute ElementTypeId.April 27, 2023
  Do you know how to resolve the error “The values Element Name, Legislative Data Group Name aren’t valid for the attribute ElementTypeId.”. Read on to know more details.
• How to update Element attributes/properties using PayrollElementDefinition.dat HDL?May 18, 2023
  Do you know how to update Element details using HDL? Have you anytime used PayrollElementDefinition.dat?Read on to know more details.
• How to load Worker.dat with minimum objects and attributes for Non-HCM?May 18, 2023
  Do you know what are the minimum required business objects in Worker without which the Worker upload will fail? Read on to know more details.
• How to load Calculation Card for US legislation?May 19, 2023
  Do you know how to load the Calculation Card for US Legislation? Read on to know more details.
• How to resolve AdjustedFTE change on Worker HDL post 23B upgrade?May 30, 2023
  Have you loaded Worker business object post 23B upgrade? Have you noticed any difference in the behaviour in the assignment history section? How to resolve the Adjusted FTE change? Read on to know more details.
• How to Bulk Load Educational Establishments using HDL?May 31, 2023
  Do you know how to bulk load the educational establishments into Oracle HCM Cloud? Read on to know more details.
• How to load/delete the status processing rule for elements using HDL?July 13, 2023
  Do you know how to load the status processing rules for elements using HDL? Do we also have to load Fast Formula Rules along with Status Processing Rules? Read on to know more details.