Define Source System Owner in Oracle Fusion HCM (HDL Source Keys Explained)
Introduction
When loading data into Oracle Fusion HCM using HDL (HCM Data Loader), Source Keys play a critical role in uniquely identifying records across multiple data loads.
Without properly defining the Source System Owner, HDL loads will fail or behave inconsistently.
In this blog, you’ll learn:
-
What Source System Owner is
-
How it works with Source System ID
-
Step-by-step process to define Source System Owner in Oracle Fusion
-
Why it is mandatory for HDL loads
What Are Source Keys in Oracle Fusion HCM?
Source Keys are unique identifiers used by Oracle Fusion to track records loaded via HDL.
Source Keys consist of two components:
-
SourceSystemOwner
-
SourceSystemId
📌 These keys help Oracle Fusion:
-
Identify records uniquely
-
Support incremental loads
-
Prevent duplicate data
-
Enable updates using the same source reference
What Is Source System Owner?
Source System Owner represents the external or internal system from which the data originates.
Examples:
-
Legacy HR System
-
Payroll System
-
Custom Data Migration Source
-
Interface Program
Before using Source Keys in HDL files, the Source System Owner must be defined in Fusion.
Prerequisite
-
Access to Setup & Maintenance
-
Appropriate implementation privileges
Navigation to Define Source System Owner
Follow the steps below:
-
Navigator
-
Go to Setup & Maintenance
-
Open Task Panel tab
-
Click Search
-
Search for Manage Common Lookups
-
Open Manage Common Lookups
Search for Source System Owner Lookup
-
In the Meaning field, enter:
-
Click Search
-
In the results, you will see the Source System Owner lookup definition along with existing lookup values
Add a New Source System Owner
In the Lookup Code Values section, click Add (+) and enter the following details:
| Field | Value |
|---|---|
| Lookup Code | XXTEST |
| Display Sequence | 1 |
| Enabled | ✔ Checked |
| Start Date | 01/01/1951 |
| End Date | 12/31/4712 |
| Meaning | XXTEST |
| Description | XXTEST |
📌 Dates ensure the lookup remains valid indefinitely.
Save the Lookup
Click Save and Close.
✅ Your Source System Owner is now successfully defined.
How This Is Used in HDL
Once the Source System Owner is defined:
-
You can reference it in HDL files
-
Combine it with SourceSystemId to form Source Keys
-
Use Source Keys to create or update records
Example:
This combination uniquely identifies the record in Oracle Fusion.
Common Issues & Tips
-
❌ HDL fails if Source System Owner is not defined
-
❌ Typo in SourceSystemOwner causes load errors
-
✔ Always use consistent Source Keys across loads
-
✔ Avoid changing Source System Owner once data is loaded
Conclusion
Defining Source System Owner is a mandatory and foundational step when working with HDL in Oracle Fusion HCM.
It ensures data integrity, smooth incremental loads, and reliable record identification.
Once configured, you can confidently use Source Keys across all HDL objects.
What’s Next?
👉 In the next blog, we will cover:
How to Load Work Structure in Oracle HCM Fusion using HDL
Stay tuned 🚀
