Skip to main content

Supported Keys in Oracle Fusion HCM Data Loader(HDL)

Today we will go through the few concepts of HCM Data Loader (HDL).

HDL is data loading tool for Oracle fusion HCM. It helps us to do bulk loads during implementation projects or also for on going work. HDL works on predefined template provided by  Oracle. 

Keys supported by HDL:

1) Source Key: Source Key is combination of  Source System Id and Source System Owner. 

It can be used for both Create and Update.

    Source System Id: It is key to represent record uniquely. It can be one column or concatenation of column. 

    Source System Owner: It generally represents the source of data. We add the source name in Lookup type: HRC_SOURCE_SYSTEM_OWNER.

2) User Key: These are columns available at object level which are user friendly.  It can be one column or combination of column. e.g Job Code and Set Code are user keys for Job.

It can be used for both Create and Update.

3) GUID: It is Integration Key Generated by Fusion when record got created . It is a hexadecimal value. It is held in integration key map table.

4) Surrogate Id: It is unique id generated in fusion. It is a numeric  value. Generally the primary id of HDL object. eg. Job Id for Job object.

Please find the summary of keys:

Hope fully this will be useful.

Please subscribe if you like the post. It will prompt me to write more article.

Labels:

Comments

Post a Comment

Popular posts from this blog

Dynamic Password Protected report output (Part 2)

This post is in continuation of  Password protected report output (Part 1) post where we discussed about generating the static password protected output. In this post we will go through steps to have dynamic password protected report output. This is a common requirement when a company send offer letter, payslips, appraisal letter etc in HCM. We might have also similar requirement when we send some bills to users. Let's go through the required steps to enable the password protected report output. 1) Create a SQL Data Model which should have one column password like below query have NID :   Note: We can have combination of one or more than one column as password. 2) Create a report for which we have to create a RTF template. While creating the RTF template we need to setup word properties to enable the password for PDF. Please follow the navigation: File > Info > Advance Properties > Custom 3) Add the below two properties: Name Value
Post a Comment
Read more

Loading External Bank Account Using HDL

There are general requirements for loading the External Bank Account for employees during the project implementation which will be used either for expenses or Payroll.  Let's go through the pre-requisite and steps for loading the External bank account using HDL Pre-Requisite: There is pre-requisite to generate party id before loading the External Bank Account.  1) We need to run the " Synchronize Person Records "  scheduled process by entering the details: This process should generate the Party Id for employee which have been migrated using HDL. 2) If Party Id is still not generated even after running the above process then run the " Maintain Party and Location Current Record Information " This process should generate the Party Id for employee which have been migrated using HDL. Once the Party Id is generated run Load the External Bank Account HDL file. Below is sample ExternalBankAccount.dat file: METADATA|ExternalBankAccount|BankNumber|BankName|BankBranchNumbe
Post a Comment
Read more

Loading Worker object using Fusion HCM Data Loader(HDL)

This post is going to be first part of loading different objects using HCM Data Loader (HDL). In this post we will Hire Worker using the HDL. Before starting with steps to load worker data using HDL , please go through the post Supported Keys in Fusion HCM Data Loader   Now we will go through the steps to prepare Worker file and load data: 1)  Generate the Template:           Please follow the Navigation to generate the worker template          Navigator > My Client Group > Data Exchange> View Business Objects > Search for Worker                Select the business object and Click on " Refresh Business Object " 2)   Download the template 3)  Populate the worker file and worker file will look like as below. 4)  zip the Worker.dat file. 5)  Run HDL using the following Navigation:  Navigator > My Client Group > Data Exchange> Import and Load  > Import file  6)   Browse file from you local machine and Submit as shown in below screenshot: 7)  You can verif
Post a Comment
Read more