All posts on HCM Data Loader

SQL Query to get Source System IDs for all Business Objects

  • Post category:BI Publisher
  • Post comments:2 Comments
  • Post last modified:June 12, 2020
  • Reading time:16 mins read

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 ReadingSQL Query to get Source System IDs for all Business Objects

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…

Continue ReadingNew Deadline for Payroll Batch Loader 20D Nov 2020

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…

Continue ReadingCancel an existing Work Relationship using HDL for employees

Redesigning PBL to HDL Transformation Formula

  • Post category:Fast Formula
  • Post comments:0 Comments
  • Post last modified:June 12, 2020
  • Reading time:4 mins read

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 ReadingRedesigning PBL to HDL Transformation Formula