Defining Source System Owner for HCM Data Loader
Defining Source System Owner for HCM Data Loader

 1,897 total views

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.

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

Configuring Source System Owner in Fusion HCM for HCM Data Loader HDL Source System Keys oracle hcm data loder
Configuring Source System Owner in Fusion

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.

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 2 Comments

  1. Anonymous

    Is there a value in creating the source system id/Source system owner?

  2. 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

Leave a Reply