What is AssignedPayroll HDL in Oracle HCM?

AssignedPayroll HDL assigns a payroll definition to a worker’s assignment for accurate payroll processing.

Which file is required for Assigned Payroll load?

AssignedPayroll.dat is mandatory.

Can I assign multiple payroll definitions to one assignment?

No, each assignment can have one active payroll definition at a time.

How to correct 'Payroll not created' error?

Verify AssignmentNumber exists, validate PayrollDefinitionCode, and check LegislativeDataGroupName.

How to overwrite an existing assigned payroll?

Update the EffectiveStartDate with MERGE. Ensure dates do not overlap previous assignments.

Showing posts with label HDL. Show all posts

Thursday, 19 January 2023

HDL Template to Absence Entry of Worker

Please find the below sample template :

File Name - PersonAbsenceEntry.dat

Note :- Please verify Absence plan must be enrolled first to load absence entry.

MERGE|PersonAbsenceEntry|US3 Legal Entity|XXTEST2|Sick||SUBMITTED|APPROVED||2021/07/12 08:00:00|2021/07/12|08:00|2021/07/12|16:30|XXTEST|XXTEST2_SICK1

MERGE|PersonAbsenceEntryDetail|2021/07/12|US3 Legal Entity|XXTEST2|Sick|XXTEST_ASSIGN2-1|2021/07/12|08:00|1|06:00|16:30|XXTEST|XXTEST2_SICK1

Note - For any doubts or additional information, please reach out in the comment section.

HDL Template to Accrual Plan Enrollment of Worker

Please find the below sample template :

File Name - PersonAccrualPlanEnrollment.dat

Wednesday, 18 January 2023

HDL Template for Salary of Worker

Salary Of Worker using HDL.

For this use Salary.dat

Please find the below sample template :

MERGE|Salary|ORACLE_ASG12|1991/01/01||10000|US1 Annual Salary|HIRE|Y

Wednesday, 28 December 2022

HDL Template for Global Temporary Transfer of Worker

For this use Worker.dat

Please find the below sample template :

MERGE|WorkRelationship|XXTEST9|US1 Legal Entity|2018/01/01||Y|XXTEST9|E|Y|N|GLB_TEMP_ASG||

MERGE|WorkRelationship|XXTEST9|UK Legal Entity|2019/01/01||N|XXTEST9|E|Y|N|GLB_TEMP_ASG||

MERGE|WorkTerms|GLB_TEMP_ASG|XXTEST9|US1 Legal Entity|2018/01/01|E|XXTEST_WRKTERM9|2019/01/01|4712/12/31|Y|1|ET|Employee|SUSPEND_PROCESS|US1 Business Unit|Y|EMP|

MERGE|WorkTerms|GLB_TEMP_ASG|XXTEST9|UK Legal Entity|2019/01/01|E|XXTEST_WRKTERM9-2|2019/01/01|4712/12/31|Y|1|ET|Employee|ACTIVE_PROCESS|UK Business Unit|Y|EMP|

MERGE|Assignment|GLB_TEMP_ASG|XXTEST9|UK Legal Entity|2019/01/01|E|XXTEST_ASSIGN9-2|XXTEST_WRKTERM9-2|2019/01/01|4712/12/31|Y|1|E|Employee|ACTIVE_PROCESS|UK Business Unit|XXTEST_GRADE1|ADM|XXTEST_LOC12|XXTEST Department1|Y|N|

Friday, 20 August 2021

HDL Template for Candidate

For this use Candidate.dat file.

You can see step by step video to load Candidate data using this Link

Please find the below sample template :

MERGE|Candidate|CT123|US|2019/03/20|Y||1980/08/05||direct Source|||Y

MERGE|CandidateAddress|CT123|2019/03/20|1257 Test1|HOME|Test|US|12576|NC|Wayne|Pikeville|

MERGE|CandidatePhone|CT123|2019/03/20|H1|9605804|1|262|4712/12/31||US|||

MERGE|CandidateName|2019/03/20||CT123|GLOBAL|US|Amar|Test

MERGE|CandidateProfile|CT123|DEGREE|BA - Bachelor of Arts|PERSON_DEGREE|2019/03/20|2019/03/20|||US|US|122

Monday, 28 June 2021

HDL Template for Documents Of Record

For this use DocumentsOfRecord.dat file.

You can see step by step video to load Documents Of Record using this Link

Please find the below sample template :

MERGE|DocumentsOfRecord|XXTEST|XXTEST_DOCREC01||XXTEST2||Passport||XXTEST_DOCREC01|Passport|XXTEST2123|||||US|||||||

MERGE|DocumentAttachment|XXTEST|XXTEST_DOCREC01|XXTEST2|Passport||XXTEST_DOCREC01|passport.png|passport.png|FILE|passport.png

Friday, 23 April 2021

Sample Templates for eText BI Publisher Reports (Delimiter & Fixed Position)

Introduction to eText BI Publisher Reports

Oracle BI Publisher (BIP) provides eText report templates to generate text-based output files such as .txt, .dat, or interface files required for integrations with external systems.

Unlike PDF or Excel outputs, eText reports are mainly used when:

Data must follow a specific layout
Files are consumed by external payroll, banking, or legacy systems
Strict formatting rules (delimiter or fixed length) are required

In this blog, we’ll cover:

What eText BI Publisher reports are
how to create eText report in BI Publisher
Differences between Delimiter-Based and Fixed Position-Based eText
BI Publisher eText report example
how to create fixed position eText report
common errors in BI Publisher eText report

Difference Between Delimiter & Fixed Position eText

Delimiter VS Fixed Position eText

You can see step by step video to develop eText BIP Report using this Link

🔹 Sample 1: Delimiter-Based eText Template

This template generates output with values separated by a delimiter (for example, |).

You can see step by step video to develop eText BIP Report using this Link

<TEMPLATE TYPE>	DELIMITER_BASED
<OUTPUT CHARACTER SET>	iso-8859-1
<CASE CONVERSION>	UPPER
<NEW RECORD CHARACTER>	Carriage Return

<LEVEL>	DATA_DS
<MAXIMUMLENGTH>	<FORMAT>	<DATA>	<COMMENTS>
<NEW RECORD>	TableHeader
20	Alpha	'Person Id'
1	Alpha	'\|'
20	Alpha	'Title'
1	Alpha	'\|'
20	Alpha	'First Name'
1	Alpha	'\|'
20	Alpha	'Last Name'

<LEVEL>	G_1
<MAXIMUMLENGTH>	<FORMAT>	<DATA>	<COMMENTS>
<NEW RECORD>	CLRDAta
20	Alpha	PERSON_ID
1	Alpha	'\|'
20	Alpha	TITLE
1	Alpha	'\|'
20	Alpha	FIRST_NAME
1		'\|'
20	Alpha	LAST_NAME
<END LEVEL>	G_1

<END LEVEL>

DATA_DS

This format is useful when the target system expects delimiter-separated text files.

HDL Template for Personal Payment Method Details

Prerequisite:

1. Bank and Bank Branches data should be loaded. Click here to find the sample bank details.

2. External bank Account should be loaded. Click here to find the sample file.

For this use PersonalPaymentMethod.dat file.

You can see step by step video to load Personal Payment Method Details using this Link

Please find the below sample template :

MERGE|PersonalPaymentMethod|XXTEST|XXTEST_PAYMETHOD2|US Legislative Data Group|XXTEST_ASSIGN2|XXTEST_PAYMETHOD2|2021/04/19|P||100|1|Direct Deposit|American Bank|000000123|US|3456|Checking

Tuesday, 20 April 2021

HDL Template for External Bank Account Details

Prerequisite:

1. Bank and Bank Branches data should be loaded. Click here to find the sample bank details.

For this use ExternalBankAccount.dat file.

You can see step by step video to load External Bank Account Details using this Link

Please find the below sample template :

HDL Template for Bank and Bank Branch Details

For this use Bank.dat and BankBranch.dat file.

You can see step by step video to load Bank and Bank Branch Details using this Link

Please find the below sample template :

Bank :

Bank Branch:

MERGE|BankBranch|American Bank|123|AMC123|US||XXTEST|XXTEST_BANKBRANCHAM123

Tuesday, 13 April 2021

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:

Worker assignment exists (AssignmentNumber)
Payroll definitions are configured in Oracle HCM
Legislative data groups are correctly set
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

🔹 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

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:

Worker/assignment exists (AssignmentNumber must be valid)
Element names are configured in Oracle HCM
Legislative data groups are correctly set
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

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

Prepare ElementEntry.dat and ElementEntryValue.dat
Validate AssignmentNumber and element reference data
Zip the files into a single HDL package
Go to Tools → HCM Data Loader → Upload
Submit the load process and monitor status
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

🔹 Introduction: Why Load Person Contact Using HDL?

In Oracle Fusion HCM, person contact details include email addresses, phone numbers, emergency contacts, dependents, and beneficiaries.
Loading these contacts using HDL allows bulk updates and avoids manual entry.

This is essential for:

Employee onboarding
Emergency contact management
Payroll and benefits integration
Accurate HR reporting

You can see step by step video to load person contact details using this Link

🔹 Prerequisites

Before loading Contact.dat, ensure:

Worker/person exists in Oracle HCM (PersonNumber must be valid)
Source system codes are configured correctly
Legislation codes are set (e.g., US, GLOBAL)
Contact types and relationships are defined in reference data

🔹 Objects Required for Person Contact HDL

Object	Purpose
Contact	Loads person contact records (start date, end date)
ContactName	Loads names for the contact (first, middle, last, title)
ContactRelationship	Defines relationships (emergency, dependent, beneficiary, bondholder)

🔹 Sample HDL Templates (Contact.dat hdl template)

Contact Metadata - Covers Start Date,End Date of Contact

ContactName Metadata - Covers Name of the Person contact
METADATA|ContactName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|LegislationCode|NameType|FirstName|MiddleNames|LastName|Title
MERGE|ContactName|XXTEST|XXTEST_CNTNM2|XXTEST_PERCNT2|2019/09/01|4712/12/31|US|GLOBAL|ADAM||TEST|MR.

ContactRelationship Metadata - Covers Relation of Person Contact with Worker
METADATA|ContactRelationship|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|RelatedPersonId(SourceSystemId)|ContactType|BeneficiaryFlag|DependentFlag|EmergencyContactFlag|BondholderFlag
MERGE|ContactRelationship|XXTEST|XXTEST_CREL_CNT2|2019/09/01|4712/12/31|XXTEST_PERCNT2|XXTEST_PER1|Emergency|||Y|

🔹 Field Explanation (Infographic Ready)

Field	Description
SourceSystemOwner	Source system that owns the record
SourceSystemId	Unique ID from source system
PersonNumber	Oracle Fusion employee number
EffectiveStartDate	Start date of contact record
EffectiveEndDate	End date of contact record
LegislationCode	Country/region (e.g., US, GLOBAL)
NameType	Type of contact name (GLOBAL, LOCAL)
ContactType	Emergency, Dependent, Beneficiary, Bondholder
EmergencyContactFlag	Y = Yes, this is emergency contact
DependentFlag	Y = Yes, this is dependent
BeneficiaryFlag	Y = Yes, this is beneficiary
BondholderFlag	Y = Yes, this is bondholder

🔹 Step-by-Step Process to Load Person Contact Using HDL

Prepare Contact , ContactName , and ContactRelationship metadata
Validate PersonNumber and reference data
Zip files in a single HDL upload package
Go to Tools → HCM Data Loader → Upload
Submit process and monitor load status
Verify contact records

🔹 Common Errors & Resolutions

Issue	Resolution
Contact not created	Verify `PersonNumber` exists
No change after load	Check `EffectiveStartDate` and `EffectiveEndDate`
Invalid ContactType	Validate reference data setup
Missing Name	Ensure `ContactName` loaded correctly
Emergency/Dependent flag not updated	Verify flags (Y/N)

🔹 Best Practices

Always test in test environment first
Validate PersonNumber before upload
Use unique SourceSystemId for each contact
Keep EffectiveStartDate/EndDate consistent
Use separate files for Contact, ContactName, ContactRelationship

🔹 Internal Linking (SEO Boost)

Link this post to:

HDL Template for Person Profile Photo

For this use Worker.dat

You can see step by step video to upload the profile photo of worker using this Link

Please find the below sample template :

Save the Blob images in BlobFiles folder and make zip of both .dat and BlobFiles folder

Oracle Fusion HCM Global Transfer Using HDL – Complete Template, Examples & Errors

🧩 Introduction (SEO + User Intent)

Learn how to perform Global Transfer in Oracle Fusion HCM using HDL with complete WorkRelationship, WorkTerms, and Assignment templates. Includes sample .dat files, common errors, troubleshooting, and best practices.

Global Transfer in Oracle Fusion HCM is used when an employee moves from one legal employer to another within the organization.
This process can be automated using HDL (HCM Data Loader) by updating WorkRelationship, WorkTerms, and Assignment objects.

In this blog, you will learn:

What is Global Transfer in Oracle Fusion HCM
Prerequisites for Global Transfer using HDL
Complete HDL template with examples
Explanation of each HDL object
Common errors and troubleshooting
Best practices for Global Transfer

✅ Prerequisite for Global Transfer using HDL

Before performing Global Transfer, ensure the following:

Worker data must already exist in the system. Worker Sample Load
PersonNumber must be valid.
Legal Employer must exist in the target country.
Business Unit, Job, Grade, Location, Department must be configured.
Worker.dat file should be loaded earlier.

👉 Worker.dat is mandatory before performing Global Transfer.

You can see step by step video to do global transfer of worker using this Link

🧠 What Objects Are Required for Global Transfer?

For Global Transfer, you must load:

Object	Purpose
WorkRelationship	Creates new legal employer relationship
WorkTerms	Updates employment terms
Assignment	Updates assignment details

✅ For Global Transfer, all three objects are required.

📄 HDL Template for Global Transfer of Worker

1️⃣ WorkRelationship (Global Transfer Flag)

MERGE|WorkRelationship|XXTEST2|US3 Legal Entity|2021/01/05||Y|XXTEST2|E|Y|N|GLB_TRANSFER|||Y

🔍 Explanation

ActionCode = GLB_TRANSFER → Indicates global transfer
GlobalTransferFlag = Y → Mandatory for global transfer
LegalEmployerName → New legal employer

Thursday, 19 January 2023

HDL Template to Absence Entry of Worker

HDL Template to Accrual Plan Enrollment of Worker

Wednesday, 18 January 2023

Wednesday, 28 December 2022

Friday, 20 August 2021

Monday, 28 June 2021

Friday, 23 April 2021

Sample Templates for eText BI Publisher Reports (Delimiter & Fixed Position)

Introduction to eText BI Publisher Reports

Difference Between Delimiter & Fixed Position eText

🔹 Sample 1: Delimiter-Based eText Template

HDL Template for Personal Payment Method Details

Tuesday, 20 April 2021

HDL Template for External Bank Account Details

Tuesday, 13 April 2021

🔹 Introduction: What is Assigned Payroll HDL?

🔹 Prerequisites

🔹 Objects Required

🔹 Sample AssignedPayroll.dat Template

File Name - AssignedPayroll.dat

🔹 Field Explanation (Infographic Ready)

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

Step 1️⃣ Prepare AssignedPayroll.dat

Step 2️⃣ Upload File in Oracle HCM

Step 3️⃣ Monitor HDL Process

Step 4️⃣ Validate in Oracle HCM UI

🔹 Common Errors & Resolutions

Thursday, 8 April 2021

🔹 Introduction: What is Element Entry HDL?

🔹 Prerequisites

🔹 Objects Required

🔹 Sample HDL Templates

ElementEntry

ElementEntryValue.dat

🔹 Field Explanation (Infographic Ready)

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

🔹 Common Errors & Resolutions

🔹 FAQ – Oracle Fusion HCM Element Entry HDL

1️⃣ What is ElementEntry HDL in Oracle HCM?

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

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

4️⃣ Can I overwrite previous entries using HDL?

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

🔹 Introduction: Why Load Person Contact Using HDL?

🔹 Prerequisites

🔹 Objects Required for Person Contact HDL

🔹 Sample HDL Templates (Contact.dat hdl template)

Contact Metadata - Covers Start Date,End Date of Contact

🔹 Field Explanation (Infographic Ready)

🔹 Step-by-Step Process to Load Person Contact Using HDL

🔹 Common Errors & Resolutions

🔹 Best Practices

🔹 Internal Linking (SEO Boost)

🧩 Introduction (SEO + User Intent)

✅ Prerequisite for Global Transfer using HDL

🧠 What Objects Are Required for Global Transfer?

📄 HDL Template for Global Transfer of Worker

1️⃣ WorkRelationship (Global Transfer Flag)

🔍 Explanation