✅ Oracle HCM HDL: Load Seniority Hours (Create / Update / Delete) – Worker.dat Examples
For hourly paid workers, many organizations calculate seniority in hours instead of days. To support accurate seniority calculations in Oracle Fusion HCM, you can load seniority hours using HCM Data Loader (HDL).
In this post, you’ll learn how to create, update, and delete Seniority Hours using HDL with both:
-
Source Keys (SourceSystemOwner + SourceSystemId)
-
User Keys (AssignmentNumber + FromDate)
⭐ What are Seniority Hours in Oracle HCM?
Seniority Hours represent the number of hours worked that contribute to a worker’s length of service calculation.
This is mainly used for:
-
Hourly paid workers
-
Union or bargaining unit employees
-
Time & Labor based seniority
-
Payroll-driven seniority hours
📌 Sources of Seniority Hours Data
You can obtain seniority hours from:
-
Oracle Time and Labor (OTL)
-
Oracle Global Payroll
-
A third-party time system
-
External payroll system
✅ Important Prerequisites (Must Read)
Before loading seniority hours:
1) Assignment must exist
The assignment must already exist in Oracle HCM.
2) Assignment must be active
The assignment must be active as of the FromDate of the seniority hours.
3) Worker must be hourly paid
The worker must be paid hourly for the entire period you are loading hours.
🔍 How to Verify Loaded Seniority Hours
After loading, you can verify data from:
Option 1: UI Page
✅ Manage Seniority Dates page (worker level)
Option 2: Database Query
For multiple workers:
✅ Query table: PER_SENIORITY_HOURS
🧾 HDL Object Used
Seniority Hours are loaded using the HDL component:
✅ SeniorityHour (Worker.dat)
📂 File Name
📌 File Name:
Worker.dat
🔥 Examples of Loading Seniority Hours (HDL)
1) Create Seniority Hours Using Source Keys
📌 Notes:
-
SourceSystemOwner+SourceSystemIduniquely identify the record -
This is best for integrations from external systems
2) Create Seniority Hours Using User Keys
The user keys for SeniorityHour are:
✅ AssignmentNumber + FromDate
✏️ Updating Seniority Hours
3) Update Seniority Hours Using Source Keys
📌 The update happens because the same SourceSystemOwner + SourceSystemId exists.
4) Update Seniority Hours Using User Keys
📌 Oracle identifies the record using:
-
AssignmentNumber
-
FromDate
🗑️ Deleting Seniority Hours
5) Delete Seniority Hours Using Source Keys
6) Delete Seniority Hours Using User Keys
✏️ Updating Seniority Hours
✅ Example 1: Load Seniority Hours for Multiple Periods (Same Assignment)
Use this when you want to load hours month-wise / week-wise.
⚠️ Common HDL Errors and Fixes
❌ Error: Assignment not active for FromDate
✅ Fix: Ensure assignment is active as of the FromDate.
❌ Error: Worker not hourly paid
✅ Fix: Seniority Hours should only be loaded for hourly paid workers.
❌ Error: Duplicate user key record
✅ Fix: Ensure you don’t load the same AssignmentNumber + FromDate twice.
❌ Error: Invalid AssignmentNumber
✅ Fix: Verify assignment number from Person Management.
🧠 Best Practice Tips (Recommended)
✅ Always load seniority hours in clean date ranges (monthly or yearly)
✅ Keep FromDate and ToDate consistent (avoid overlapping ranges)
✅ Prefer user keys unless your integration requires source keys
✅ Use unique SourceSystemId values if using source keys
🔗 Internal Links
-
Oracle HCM HDL: Load Worker Data (Worker.dat)
-
Oracle HCM HDL: Seniority Date Adjustments (V3)
-
Oracle HCM HDL: Absence Entry Template (PersonAbsenceEntry.dat)
-
Oracle HCM HDL: Assignment Supervisor Template
-
Oracle HCM HDL: Assigned Payroll Template
-
Oracle HCM HDL: Element Entry Template
-
Oracle HCM HDL: Bank → Branch → External Bank Account → Personal Payment Method
❓ FAQ
Q1. What is Seniority Hours in Oracle HCM?
Seniority hours represent the number of hours used to calculate service length for hourly paid workers.
Q2. Which HDL object is used for loading seniority hours?
The HDL object is SeniorityHour in Worker.dat.
Q3. Can we load seniority hours using AssignmentNumber?
Yes. You can load seniority hours using user keys: AssignmentNumber + FromDate.
Q4. Can we update seniority hours using HDL?
Yes. Use MERGE with the same user key or source key values.
Q5. Can we delete seniority hours using HDL?
Yes. Use DELETE operation using either:
-
SourceSystemOwner + SourceSystemId
or -
AssignmentNumber + FromDate
Q6. How can I verify loaded seniority hours?
You can verify via:
-
Manage Seniority Dates page
-
Querying PER_SENIORITY_HOURS table
✅ Flow Diagram
 |
Seniority Hours in Oracle Fusion HCM |
💬 Feedback & Comments
If this Seniority Hours HDL post helped you, please drop a comment below 🙌
For troubleshooting, share:
Your assignment number (mask it if needed)
FromDate and ToDate
Your HDL error message
Whether worker is hourly paid
I’ll respond with the fix as quickly as possible.
No comments:
Post a Comment