Update Source Keys using HDL for business objects
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
All posts of HCM Data Loader
How to send/stop welcome email notifications to users using HDL
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.
Invoke HCM Data Loader using SOAP Service
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?
SQL Query to get Scheduled Process Job History
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
Useful Excel to HDL DAT File Converter
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.
Resolving Assignment Name and Job Name not in sync issue
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
Generate HDL file for failed business object Lines
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.
New Deadline for Payroll Batch Loader 20D Nov 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 it by a release to…
Sample HCM Data Loader (HDL) files for all Business Objects
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.
Cancel an existing Work Relationship using HDL for employees
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): SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|HRC_SQLLOADER|1122334455|123456789_1|Legal Entity Two||2010/01/01|E|Y When we have a requirement to cancel multiple work relationships due to bad…