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 FusionTotal Visits: 10 Todays Visits: 10 In 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 ParametersWho Can Load Data Using HCM […]
- Sample CostAllocationAccountV3.dat HDL fileSample 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 ParametersTotal Visits: 3 Todays Visits: 3 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 […]
- Defining Source System Owner for HCM Data LoaderDo 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 FusionDo 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 AssignmentDo 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 employeesTotal Visits: 2 Todays Visits: 2 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 […]
- Sample HCM Data Loader (HDL) files for all Business ObjectsAre 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 2020Total Visits: 2 Todays Visits: 2 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 […]
- Generate HDL file for failed business object LinesDo 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 issueDo 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 ConverterHow 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 HistoryDo 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 ServiceDo 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?
- Send notifications to users to reset password using HDLDo 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 objectsDo 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 QuestionsTop 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?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 1Do 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 SampleDo 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 fileDo 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 20CDo 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 LoadDo 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 ReportHave 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 20DDo 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?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.
The above list keeps refreshing whenever latest content is being added on HCM Data Loader. Keep checking for latest updates.