HDL Template to Disability of Worker

 HDL Template to Person Disability

Please find the below sample template :

File Name- PersonDisability.dat

METADATA|PersonDisability|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|LegislationCode|PersonId|PersonNumber|SelfDisclosedType|Category|QuotaFTE|Status

MERGE|PersonDisability|XXTEST|XXTEST_DIS21|2021/07/07|4712/12/31|US|100000609337422|XXTEST21|ORA_PER_YES_US|NA|1|A

 

Oracle Fusion HCM: Assigned Payroll HDL – Complete Template & Example (AssignedPayroll.dat)

🔹 Introduction: What is Assigned Payroll HDL?

In Oracle Fusion HCM, assigned payroll determines the payroll schedule and payroll definition for an employee’s assignment.

Using AssignedPayroll.dat via HCM Data Loader (HDL) allows you to:

• Assign payroll definitions like Weekly, Monthly, or Biweekly

• Link legislative data groups for country-specific payroll rules

• Ensure accurate payroll processing

• Avoid manual assignment errors

You can see step by step video to load Assigned Payroll details of worker using this Link

---

🔹 Prerequisites

Before loading Assigned Payroll HDL, ensure:

1. Worker assignment exists (AssignmentNumber)

2. Payroll definitions are configured in Oracle HCM

3. Legislative data groups are correctly set

4. Unique Source System identifiers are used

---

🔹 Objects Required

Object	Purpose
AssignedPayroll	Assigns payroll definitions to a worker’s assignment and links to legislative data groups

---

🔹 Sample AssignedPayroll.dat Template

File Name - AssignedPayroll.dat

METADATA|AssignedPayroll|EffectiveStartDate|AssignmentNumber|PayrollDefinitionCode|LegislativeDataGroupName|StartDate

MERGE|AssignedPayroll|2021/04/09|XXTEST_ASSIGN1|Weekly|US Legislative Data Group|2021/04/09

---

🔹 Field Explanation (Infographic Ready)

Assigned Payroll Keyfields

---

🔹 Step-by-Step Process to Load Assigned Payroll Using HDL

Step 1️⃣ Prepare AssignedPayroll.dat

• Use correct AssignmentNumber

• Validate PayrollDefinitionCode

Step 2️⃣ Upload File in Oracle HCM

Navigation:
Tools → HCM Data Loader → Import and Load Data

Step 3️⃣ Monitor HDL Process

Check status:
✔ Completed
❌ Error

Step 4️⃣ Validate in Oracle HCM UI

Person Management → Payroll Relationship 

---

🔹 Common Errors & Resolutions

Common Issues in Assigned Payroll Load