All posts on HCM Data Loader
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
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.
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…
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…
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.
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…
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…
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.
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
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