HCM Data Loader is one of the most familiar Bulk Data Loading tool available in Fusion. Basics of HDL have been covered at HCM Data Loader. If you haven’t got a chance to look into it, please look into it and then continue reading this article.
Want to learn Fusion Technical tools? Check out this article
We can use User Keys/Source Keys when we load data for Business Objects. For using Source Keys, we first need to define the Source System Owner and then use the defined Source system owner in the HDL file.
Table of Contents
Configuring Source System Owner:
Login to Fusion Applications > Click on Navigator > Setup and Maintenance
Search for task “Manage Common Lookups” Search for the Lookup Type of “HRC_SOURCE_SYSTEM_OWNER“
We can create a new Source System Owner by Clicking the + sign and then save it.
By Default FUSION and HRC_SQLLOADER Source System Owners will be present by default. Whatever transactions that we do on the application will have the Source System Owner as FUSION by default.
Once the Source System Owner has been defined, we can use this Source System Owner in the HDL file.
Sample HDL file using Source Keys:
METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|PersonNumber|ActionCode|ReasonCode|StartDate|CountryOfBirth|CategoryCode
MERGE|Worker|HRC_SQLLOADER|PER_11111|1945/02/12|11111|HIRE|NEWHIRE|1945/02/12|US|PER_EIT
SQL Query to get the list of Source System Owners defined in a POD:
SELECT *
FROM fnd_lookup_values
WHERE lookup_type = 'HRC_SOURCE_SYSTEM_OWNER'
Summary: Configuring Source System owner is a one time setup that needs to be done before data load in Fusion HCM. Once we define it we can use it in any of the future data loads. Only if you are converting a new third party system information, there could be a need to create a new source system identifier to be used in HCM Data Loader.
Is there a value in creating the source system id/Source system owner?
Yes. Loading using Source Keys is very important as there are some cases where we cannot use the user keys to update data when the data that we want to update is also a user key. Source Keys will help in that scenario.
Thanks,
Sricharan