Oracle Fusion HCM: Element Entry HDL – Complete Template & Examples (ElementEntry.dat)

🔹 Introduction: What is Element Entry HDL?

Learn how to load element entry details for workers in Oracle Fusion HCM using ElementEntry.dat and ElementEntryValue.dat files. Complete HDL templates, step-by-step guide, common errors, troubleshooting, and FAQ included.

In Oracle Fusion HCM, element entries allow you to define payroll elements such as allowances, deductions, or benefits for employees.

Using ElementEntry and ElementEntryValue via HCM Data Loader (HDL) enables you to:

• Load bulk element entries for multiple workers

• Maintain consistency in payroll calculations

• Avoid manual data entry errors

• Manage repetitive or complex payroll elements efficiently

You can see step by step video to element entry details of worker using this ElementEntry.dat

---

🔹 Prerequisites

Before loading Element Entry HDL, ensure:

1. Worker/assignment exists (AssignmentNumber must be valid)

2. Element names are configured in Oracle HCM

3. Legislative data groups are correctly set

4. Source system identifiers are unique for each entry

---

🔹 Objects Required

Object	Purpose
ElementEntry	Defines the payroll element entry for an assignment
ElementEntryValue	Defines specific values for each element entry (amount, periodicity, flags)

---

🔹 Sample HDL Templates

ElementEntry

METADATA|ElementEntry|EffectiveEndDate|EffectiveStartDate|ElementName|LegislativeDataGroupName|MultipleEntryCount|EntryType|AssignmentNumber|SourceSystemOwner|SourceSystemId|ReplaceLastEffectiveEndDate

MERGE|ElementEntry|4712/12/31|2021/04/06|Housing Allowance Expat|US Legislative Data Group||E|XXTEST_ASSIGN1|XXTEST|XXTEST_ENTRY2|

ElementEntryValue.dat

METADATA|ElementEntryValue|EffectiveEndDate|EffectiveStartDate|InputValueName|ScreenEntryValue|AssignmentNumber|ElementName|LegislativeDataGroupName|ElementEntryId(SourceSystemId)|SourceSystemOwner|SourceSystemId|ReplaceLastEffectiveEndDate
MERGE|ElementEntryValue|4712/12/31|2021/04/06|Periodicity|PRD|XXTEST_ASSIGN1|Housing Allowance Expat|US Legislative Data Group|XXTEST_ENTRY2|XXTEST|XXTEST_ENTRYVALUE4|
MERGE|ElementEntryValue|4712/12/31|2021/04/06|Amount|100|XXTEST_ASSIGN1|Housing Allowance Expat|US Legislative Data Group|XXTEST_ENTRY2|XXTEST|XXTEST_ENTRYVALUE5|
MERGE|ElementEntryValue|4712/12/31|2021/04/06|Process Separately|Y|XXTEST_ASSIGN1|Housing Allowance Expat|US Legislative Data Group|XXTEST_ENTRY2|XXTEST|XXTEST_ENTRYVALUE6|

---

🔹 Field Explanation (Infographic Ready)

Element Entry Key Fields

---

🔹 Step-by-Step Process to Load Element Entries Using HDL

1. Prepare ElementEntry.dat and ElementEntryValue.dat

2. Validate AssignmentNumber and element reference data

3. Zip the files into a single HDL package

4. Go to Tools → HCM Data Loader → Upload

5. Submit the load process and monitor status

6. Verify element entries in the employee’s assignment

---

🔹 Common Errors & Resolutions

Common Errors in Element Entry Load

---

🔹 FAQ – Oracle Fusion HCM Element Entry HDL

1️⃣ What is ElementEntry HDL in Oracle HCM?

It allows bulk loading of payroll element entries such as allowances, deductions, and benefits.

2️⃣ Which files are required for element entry load?

ElementEntry and ElementEntryValue metadata are mandatory.

3️⃣ How to load multiple elements for one assignment?

Include multiple ElementEntry records with unique SourceSystemId. Use ElementEntryValue for specific amounts/flags.

4️⃣ Can I overwrite previous entries using HDL?

Yes, set ReplaceLastEffectiveEndDate = Y to overwrite older entries.

5️⃣ Why am I seeing “element not created” error?

• Invalid AssignmentNumber

• Element not configured in Oracle HCM

• Dates not valid

• Duplicate SourceSystemId