✅ Oracle HCM HDL: Load Worker Absence Entry (PersonAbsenceEntry.dat) – Template + Examples
Absence management is one of the most common business requirements in Oracle Fusion HCM. If you need to load absence entries for employees in bulk (Sick leave, Earned leave, Casual leave, etc.), Oracle provides the HDL object:
👉 PersonAbsenceEntry (and its child object PersonAbsenceEntryDetail)
This post provides a complete HDL template with real working examples, along with prerequisites, common issues, and FAQ.
⭐ What is PersonAbsenceEntry in Oracle HDL?
PersonAbsenceEntry is an HDL business object used to create or update worker absence entries in Oracle Fusion HCM.
It supports:
-
Absence Type (Sick, Annual Leave, etc.)
-
Absence dates and time
-
Absence status + approval status
-
Assignment-level detail (via PersonAbsenceEntryDetail)
✅ Prerequisites (Important)
Before loading absence entry using HDL, verify:
1) Worker must exist
The PersonNumber must be valid.
2) Absence Plan must be enrolled first
If the worker is not enrolled in the absence plan, the absence entry load may fail.
✅ Example errors:
-
Plan not enrolled
-
Absence type not eligible
-
No accrual available
3) Absence Type must exist
Absence Type should be configured in:
Absence Administration → Absence Types
4) Employer / Legal Entity should match worker
Use correct employer name.
📂 HDL File Name
📌 File Name:
PersonAbsenceEntry.dat
🧾 HDL Sample Template: PersonAbsenceEntry
This is the main absence entry record.
🔍 Explanation of Key Fields
-
AbsenceType: Example: Sick, Annual Leave, etc.
-
AbsenceStatus: Usually SUBMITTED
-
ApprovalStatus: APPROVED / PENDING
-
StartDatetime / EndDatetime: Used for date+time entry
-
StartDate / EndDate: Used for date only entries
-
SourceSystemOwner / SourceSystemId: Must be unique per absence record
🧾 HDL Sample Template: PersonAbsenceEntryDetail
This object is used when you want to load daily/time details and connect absence to assignment.
⭐ Why PersonAbsenceEntryDetail is required?
You should use PersonAbsenceEntryDetail when:
✅ Absence is hourly
✅ Absence spans multiple dates
✅ You need assignment-level mapping
✅ You want exact daily breakdown
🧠 Recommended HDL Zip Structure
Your zip should look like this:
Upload from:
Data Exchange → HCM Data Loader → Import and Load
⚠️ Common Errors and Fixes
❌ Error: Worker is not enrolled in absence plan
✅ Fix: Enroll the worker first in the plan.
❌ Error: Invalid Absence Type
✅ Fix: Verify Absence Type spelling and configuration.
❌ Error: SourceSystemId already exists
✅ Fix: Use unique SourceSystemId for each absence entry.
❌ Error: AssignmentNumber invalid
✅ Fix: Confirm assignment number from Person Management.
🔗 Internal Links
HDL Load Worker Data (Person/Assignment)
HDL Bank → Branch → External Bank Account → Personal Payment Method
💬 Feedback & Comments
If this absence entry HDL template helped you, drop your feedback in the comment section 🙌
If you face any issue, share:
-
HDL error message
-
Absence Type name
-
Whether plan enrollment exists
-
Your sample Worker.dat snippet (remove sensitive data)
❓ FAQ
Q1. Can we load absence entries using HDL in Oracle HCM?
Yes. You can load worker absences using the HDL objects PersonAbsenceEntry and PersonAbsenceEntryDetail.
Q2. Is absence plan enrollment required before loading absence entry?
Yes. In most cases, the worker must be enrolled in the absence plan first.
Q3. Which file is used to load absence entry in HDL?
The commonly used HDL file is PersonAbsenceEntry.dat.
Q4. What is the purpose of PersonAbsenceEntryDetail?
It provides daily/hourly absence details and connects the absence entry to assignment.
Q5. Can we load hourly absences using HDL?
Yes. Hourly absences are supported by providing StartTime and EndTime in PersonAbsenceEntryDetail.
Q6. What should be the AbsenceStatus and ApprovalStatus?
Typically:
-
AbsenceStatus = SUBMITTED
-
ApprovalStatus = APPROVED (or PENDING depending on workflow)
