Oracle HCM HDL – Loading Third-Party Organization Payment Method (Complete Guide with Examples)

 

📌 Overview

In Oracle HCM Payroll, you often need to make payments to external organizations, such as:

• Pension providers

• Professional bodies

• Courts (Child Support / Garnishment)

• Tax authorities

• Insurance providers

To enable this, you must:

1️⃣ Create a Third-Party Organization
2️⃣ Create Organization Payment Method
3️⃣ Load External Bank Account
4️⃣ Associate bank account to Third-Party
5️⃣ Add Calculation Card to employee

This blog explains how to load these using HCM Data Loader (HDL).

---

✅ Before You Begin

Make sure the following setup exists:

✔ Legislative Data Group (LDG)
✔ Payroll defined
✔ Third-Party Organization created
✔ Organization Payment Method defined
✔ Bank and Bank Branch created

---

✅ Step 1 – Load External Bank Account

You use the ExternalBankAccount and ExternalBankAccountOwner components.

This associates the bank account with the third-party organization.

---

📄 ExternalBankAccount.dat Example

METADATA|ExternalBankAccount|BankNumber|BankBranchNumber|CountryCode|AccountNumber|
IBAN|AccountName|CurrencyCode
MERGE|ExternalBankAccount|BNK9001|BR9001|US|9876543210|US64 SVBK 9876 5432 1098 76
|ABC Pension Trust|USD

METADATA|ExternalBankAccountOwner|BankNumber|BankBranchNumber|CountryCode|
AccountNumber|CurrencyCode|ThirdPartyNumber|PrimaryFlag
MERGE|ExternalBankAccountOwner|BNK9001|BR9001|US|9876543210|USD|TP30001|Y

Explanation

• ThirdPartyNumber = TP30001

• This links the bank account to the third-party organization

• PrimaryFlag = Y marks this as primary account

---

✅ Step 2 – Load Third-Party Organization Payment Method

Now associate payment method with third-party organization.

In this example:

• PartyNumber = TP30001

• Payment type = Direct Deposit

• Bank details provided

---

📄 ThirdPartyOrganizationPaymentMethod.dat Example

METADATA|ThirdPartyOrganizationPaymentMethod|EffectiveStartDate|
EffectiveEndDate|LegislativeDataGroupName|TimeDefinitionCode|
PartyNumber|BankName|BankBranchNumber|BankAccountNumber|BankCountryCode|
OrganizationPaymentMethodCode

MERGE|ThirdPartyOrganizationPaymentMethod|2022/01/01|
|US Legislative Data Group||TP30001|Wells Fargo Bank|121000248|
7894561230|US|OPM_US_DirectDeposit

---

🏦 Bank Details Used in Example

Field Values PartyNumber TP30001 BankName Wells Fargo Bank BankBranchNumber 121000248 BankAccountNumber 7894561230 OrganizationPaymentMethodCode OPM_US_DirectDeposit

---

🔄 How It Works in Payroll Processing

1️⃣ Employee has involuntary deduction
2️⃣ Deduction is configured in Calculation Card
3️⃣ Payroll calculates deduction
4️⃣ System uses Third-Party Organization Payment Method
5️⃣ Payment is generated via Direct Deposit
6️⃣ File (e.g., NACHA) is created

---

💡 Important Notes

1️⃣ Legislative Data Group must match Payroll LDG

2️⃣ OrganizationPaymentMethodCode

Example:
OPM_US_Nacha → Used for US direct deposit processing

3️⃣ External Bank Account Owner must exist before Payment Method load

---

🔗 Internal Linking Suggestions

• HDL Personal Payment Method Load

• External Bank Account HDL Guide

• Payroll YTD Balance Query

• HSDL vs HDL in Oracle HCM

---

🚨 Common Errors and Fixes

❌ Error: Bank account not found

✔ Ensure ExternalBankAccount is loaded before Payment Method.

❌ Error: PartyNumber invalid

✔ Confirm Third-Party Organization exists and number is correct.

❌ Error: LDG mismatch

✔ LegislativeDataGroupName must match payroll LDG.

---

🧠 Best Practice (From Project Experience)

✔ Always load bank first
✔ Validate ThirdPartyNumber from UI
✔ Keep Payment Method effective date aligned with Payroll
✔ Use separate HDL files for Bank and Payment Method
✔ Run “Validate” mode before final load

---

❓ FAQ Section

Q1. What is a Third-Party Organization Payment Method?

It defines how payroll payments are made to external organizations like courts or pension providers.

Q2. Is External Bank Account mandatory?

Yes, if payment method is Direct Deposit.

Q3. What component links bank to third-party?

ExternalBankAccountOwner component.

Q4. Can we pay via check instead of direct deposit?

Yes, then bank details are not required.

Q5. Where is this used in Payroll?

It is used when processing involuntary deductions like child support.

---

💬 Feedback & Comments Section

Have You Implemented Third-Party Payments?

If yes, share:

• Which country payroll?

• Was it Child Support, Pension, or Garnishment?

• Any HDL errors you faced?

• Did you use NACHA or SEPA format?

Drop your questions below 👇
I reply with solutions and corrected HDL samples.