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.
All posts on HCM Data Loader
Continue Reading Send notifications to users to reset password using HDL
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?
Continue Reading Invoke HCM Data Loader using SOAP Service
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.
Continue Reading Useful Excel to HDL DAT File Converter
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
Continue Reading Resolving Assignment Name and Job Name not in sync issue
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.
Continue Reading Generate HDL file for failed business object Lines
In one of our previous articles, we have seen how to configure Source System Owner in Fusion.Defining Source System Owner for HDL in Fusion Source System Owner and Source System ID are the Source Keys which we use to load/update data using HCM Data Loader (HDL). HRC_INTEGRATION_KEY_MAP is the underlying base table which stores the Source Keys for all business…
Continue Reading SQL Query to get Source System IDs for all Business Objects
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…
Continue Reading New Deadline for Payroll Batch Loader 20D Nov 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.
Continue Reading Sample HCM Data Loader (HDL) files for all Business Objects
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 NMETADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlagDELETE|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 data load/some…
Continue Reading Cancel an existing Work Relationship using HDL for employees
As we all know that PBL (Payroll Batch Loader) is getting decommissioned by Oracle from 20C release. Client PODs are currently on 20A and some of them are getting 20B on their TEST PODs now. So in another four months from now, the 20C would be available and with it the PBL era would end. For the new clients provisioned…
Continue Reading Redesigning PBL to HDL Transformation Formula