Oracle HCM Data Loader (HDL) Example: Loading Payroll Costing Using CostAllocationV3

Introduction

Oracle Fusion HCM Payroll Costing enables organizations to allocate payroll expenses to General Ledger (GL) accounts for accurate financial reporting and accounting. Using HCM Data Loader (HDL), payroll costing can be loaded in bulk, making implementation and data migration activities significantly easier.

In this article, we'll walk through a complete HDL example for loading Payroll Costing, including:

• Payroll Costing Overview

• Cost Allocation Components

• Mock HDL Templates

• Payroll Costing Hierarchy

• Validation Checklist

• Troubleshooting Guide

• Best Practices

---

What is Payroll Costing in Oracle HCM?

Payroll Costing determines how payroll expenses are distributed to accounting segments and eventually transferred to the General Ledger.

Costing can be configured at various levels:

1. Payroll Level

2. Department Level

3. Position Level

4. Element Eligibility Level

5. Person Level

The Payroll Level is generally used for segments that rarely change across employees such as:

• Company

• Business Unit

• Fund

• Line of Business

---

Why Configure Costing at Payroll Level?

Organizations often maintain multiple payrolls such as:

• Weekly Payroll

• Biweekly Payroll

• Monthly Payroll

Instead of assigning identical costing information to every employee, Payroll Level Costing allows common accounting segments to be configured once and inherited by all workers within that payroll.

Benefits

✔ Simplifies costing setup

✔ Reduces maintenance effort

✔ Supports General Ledger integration

✔ Improves payroll accounting accuracy

✔ Supports suspense and default accounts

---

Business Scenario

A fictional organization, GlobalTech Solutions, maintains a monthly payroll named:

GlobalTech Monthly Payroll

The Payroll team wants to:

• Cost all payroll expenses to a predefined cost account.

• Configure Default Account.

• Configure Suspense Account.

• Transfer payroll costing to General Ledger.

---

Payroll Costing Structure

Cost Account

Segment	Description	Value
Segment1	Company	2001
Segment2	Cost Center	3001
Segment3	Fund	4001
Segment4	Department	5001
Segment5	Business Unit	6001
Segment6	Program	7001
Segment7	Natural Account	8001
Segment8	Project	9001

Suspense Account

All segments:

0000.0000.0000.0000.0000.0000.0000.0000

Default Account

All segments:

0000.0000.0000.0000.0000.0000.0000.0000

---

Step 1: Create Cost Allocation Record

CostAllocationV3.dat

METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType
|PayrollCode|LegislativeDataGroupName

MERGE|CostAllocationV3|4712/12/31|2025/01/01|PAY|GlobalTech Monthly Payroll
|GlobalTech US LDG

Explanation

Field	Description
SourceType	PAY = Payroll Level Costing
PayrollCode	Payroll Name
LDG	Legislative Data Group
EffectiveStartDate	Costing Effective Date

---

Step 2: Load Payroll Costing Accounts

CostAllocationAccountV3.dat

METADATA|CostAllocationAccountV3|SourceType|PayrollCode|LegislativeDataGroupName
|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment
|Segment1|Segment2|Segment3|Segment4|Segment5|Segment6|Segment7|Segment8

MERGE|CostAllocationAccountV3|PAY|GlobalTech Monthly Payroll|GlobalTech US LDG
|2025/01/01|COST|1|1||2001|3001|4001|5001|6001|7001|8001|9001

MERGE|CostAllocationAccountV3|PAY|GlobalTech Monthly Payroll|GlobalTech US LDG
|2025/01/01|SUSP|1|1|0000.0000.0000.0000.0000.0000.0000.0000||||||||

MERGE|CostAllocationAccountV3|PAY|GlobalTech Monthly Payroll|GlobalTech US LDG
|2025/01/01|DFLT|1|1|0000.0000.0000.0000.0000.0000.0000.0000||||||||

---

Understanding Source Sub Types

COST

Primary payroll expense account.

Used to charge payroll expenses.

Example:

2001.3001.4001.5001.6001.7001.8001.9001

---

SUSP (Suspense Account)

Used when payroll costing cannot determine a valid account combination.

Example:

0000.0000.0000.0000.0000.0000.0000.0000

---

DFLT (Default Account)

Used when account information is missing during payroll costing.

Example:

0000.0000.0000.0000.0000.0000.0000.0000

---

Payroll Costing Flow

Payroll costing process flow diagram

---

HDL Upload Steps

Step 1

Create CostAllocationV3.dat

Step 2

Create CostAllocationAccountV3.dat

Step 3

Zip HDL files

Payroll_Costing.zip

Step 4

Navigate to:

My Client Groups
→ Data Exchange
→ Import and Load Data

Step 5

Upload ZIP file.

Step 6

Submit HDL Process.

Step 7

Verify Status:

Completed Successfully

---

Validation Checklist

Before Upload

• Cost Allocation Key Flexfield configured

• Payroll exists

• LDG exists

• Accounting segments validated

• Suspense account defined

• Default account defined

After Upload

• HDL completed successfully

• Cost Allocation created

• Cost Accounts loaded

• Payroll Costing verified

• GL Transfer validated

---

Common HDL Errors

Error: Payroll Not Found

Cause:

Incorrect Payroll Code.

Solution:

Verify Payroll Name exactly matches Oracle Payroll.

---

Error: LDG Not Found

Cause:

Invalid Legislative Data Group.

Solution:

Validate LDG configuration.

---

Error: Invalid Segment Combination

Cause:

GL account combination not valid.

Solution:

Validate accounting flexfield combinations.

---

Error: Cost Allocation Already Exists

Cause:

Duplicate costing record.

Solution:

Use MERGE instead of CREATE.

---

Best Practices

• Always configure Suspense Account.

• Always configure Default Account.

• Validate account combinations before migration.

• Test in lower environments first.

• Reconcile payroll costing with Finance team.

• Maintain version-controlled HDL templates.

• Document all segment mappings.

---

Frequently Asked Questions (FAQ)

Can Payroll Costing be loaded using HDL?

Yes. Oracle supports payroll costing using CostAllocationV3 and CostAllocationAccountV3 business objects.

Why should I configure Suspense Accounts?

Suspense Accounts prevent payroll costing failures when valid costing information is unavailable.

Can multiple payrolls have different costing accounts?

Yes. Each payroll can have its own costing configuration.

What is SourceType PAY?

PAY indicates Payroll Level Costing.

What is the difference between COST, DFLT, and SUSP?

• COST = Primary Cost Account

• DFLT = Default Account

• SUSP = Suspense Account

Can payroll costing be updated later?

Yes. Use HDL MERGE statements to update costing records.

Oracle Payroll Balance Adjustments Using HDL (HCM Data Loader) – Complete Guide

Oracle HCM Payroll Balance Adjustments Using HDL – Complete Guide

Overview

In Oracle Fusion HCM Payroll, organizations sometimes need to adjust payroll balances after payroll has already run. This commonly happens during system migrations, acquisitions, third-party payments, or retroactive tax corrections.

Using HCM Data Loader (HDL), payroll administrators can adjust payroll balances for a worker as of a specific date. The adjustment process creates a run result that updates one or more balances depending on the element input values used in the adjustment.

During balance adjustment, administrators can decide:

• Whether the adjustment results should be costed

• Whether the adjustment should be paid to the employee

• Whether the adjustment should be included in the next pre-payment process

When payment is enabled, the system assigns the adjustment results to the appropriate payment method configured for the worker.

---

Common Scenarios for Payroll Balance Adjustments

1. Corrections After Balance Initialization

During payroll migration or acquisitions, employees may already have earnings and taxes processed in the legacy system.

When those balances are initialized in Oracle Cloud Payroll, mistakes can occur.

Example Scenario

A company acquires employees mid-year.

Worker Name	Issue	Adjustment Required
Alex Johnson	Federal tax withheld initialized 200 less	Increase balance by 200
Maria Patel	Missing balance initialization	Load adjustment balances

The payroll manager loads balance adjustments using an element that feeds the required balance.

---

2. Third-Party Gross-to-Net Payroll Reporting

Organizations sometimes outsource payments such as:

• Disability benefits

• Stock option payouts

• Relocation allowances

Even though the third-party pays employees, the employer still needs to report wages and taxes in payroll balances.

Example Scenario

Worker Ravi Sharma receives disability payments handled by a third-party provider.

Component Amount Gross Disability Payment 6,000 Federal Tax Withheld 1,200 Social Security 450 Medicare 250 Net Payment 4,100

The payroll administrator loads these amounts as balance adjustments so reporting remains accurate.

---

3. Retroactive Changes Not Supported by RetroPay

Sometimes payroll changes occur after payroll processing, but RetroPay does not support the impacted element.

Example: Tax deductions.

Example Scenario

Worker David Miller was taxed incorrectly.

Location Tax Withheld California 600 Texas (correct location) 250

Payroll manager performs balance adjustments:

• Add 250 Texas state tax

• Reverse 600 California tax

---

4. Zeroing Out Balances for Terminated Employees

Balance adjustments can also clear arrears balances for terminated workers.

Example Scenario

Worker James Carter terminated on 30-Sep-2025.

Outstanding deductions:

Deduction Type	Balance
Car Loan	2000
Education Loan	750

Payroll administrator loads:

Car Loan Adjustment = -2000
Education Loan Adjustment = -750

This resets inception-to-date arrears balances to zero.

---

Prerequisites Before Loading Balance Adjustments

Before performing adjustments, verify the following:

• Element eligibility links exist

• Required balances are identified

• Balance dimensions are confirmed

• Payroll and consolidation group are correct

• Balance date column is populated if required

---

Steps to Adjust Payroll Balances Using HDL

Step 1: Identify Required Balances

Determine which payroll balances require adjustment.

Step 2: Prepare HDL Batch Header File

Example data:

METADATA|BalanceAdjustmentHeader|LegislativeDataGroupName|BatchName
MERGE|BalanceAdjustmentHeader|US Legislative Data Group|Payroll_Adjustment_Batch

METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName
|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag
|BalanceAdjCostFlag

MERGE|BalanceAdjustmentGroup|US Legislative Data Group|
Payroll_Adjustment_Batch|2025/03/01|Monthly Payroll|US Consolidation
|N|N

---

Step 3: Prepare Balance Adjustment Lines

Example worker data:

METADATA|BalanceAdjustmentLine|LegislativeDataGroupName|BatchName
|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence
|AssignmentNumber|ElementName|TaxReportingUnitName

MERGE|BalanceAdjustmentLine|US Legislative Data Group|
Payroll_Adjustment_Batch|Monthly Payroll|US Consolidation|
2025/03/01|1|ETXXTEST1|Federal Income Tax Adjustment|
US Tax Reporting Unit
MERGE|BalanceAdjustmentLine|US Legislative Data Group|
Payroll_Adjustment_Batch|Monthly Payroll|US Consolidation|
2025/03/01|2|ETXXTEST2|Federal Income Tax Adjustment|
US Tax Reporting Unit

---

Step 4: Prepare Balance Adjustment Values

METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName
|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence
|InputValueName|EntryValue|ElementName

MERGE|BalanceAdjustmentValue|US Legislative Data Group
|Payroll_Adjustment_Batch|Monthly Payroll|US Consolidation|
2025/03/01|1|Tax Calculated|200|Federal Income Tax Adjustment
MERGE|BalanceAdjustmentValue|US Legislative Data Group|
Payroll_Adjustment_Batch|Monthly Payroll|US Consolidation|
2025/03/01|2|Tax Calculated|150|Federal Income Tax Adjustment

---

Step 5: Upload HDL Files

Upload the files through HCM Data Loader → Import and Load Data.

---

Step 6: Run Payroll Process

Navigate to:

Payroll Calculation Work Area
→ Run Process
→ Adjust Multiple Balances

Provide the batch name used in HDL.

---

Step 7: Validate Results

Verify results in:

• Person Process Results

• Payroll Process Results

• Balance Results

---

Balance Adjustment Components

Component	Description
Balance Adjustment Header	Batch header for balance adjustments
Balance Adjustment Group	Defines payroll and consolidation group
Balance Adjustment Line	Worker-level adjustment entries
Balance Adjustment Value	Actual balance values loaded

---

Internal Links (For Your Blog)

Use internal links to improve SEO:

• Oracle Payroll YTD Balance Query Guide

• Payroll Balance Initialization Using HDL

• HCM Data Loader Complete Guide

• Payroll Balance Checklist in Oracle HCM

• HDL for Benefit Enrollments

---

FAQ Section

1. What is Payroll Balance Adjustment in Oracle HCM?

Payroll Balance Adjustment in Oracle HCM allows administrators to correct payroll balances for employees using HCM Data Loader (HDL) without rerunning payroll. The adjustment creates run results that update payroll balances such as tax withheld, earnings, or deductions.

---

2. When should Payroll Balance Adjustments be used?

Payroll Balance Adjustments should be used when:

• Balance initialization was incorrect

• Employees were missed during payroll migration

• Third-party payments need to be recorded

• RetroPay does not support the element

• Terminated employees require arrears balance cleanup

---

3. Which HDL objects are used for balance adjustments?

The following HDL objects are used:

• BalanceAdjustmentHeader

• BalanceAdjustmentGroup

• BalanceAdjustmentLine

• BalanceAdjustmentValue

These objects allow bulk payroll balance corrections.

---

4. Can payroll balances be adjusted after payroll is processed?

Yes. Payroll balances can be adjusted after payroll is processed using Balance Adjustment HDL files and the Adjust Multiple Balances process.

---

5. What is the Adjust Multiple Balances process?

The Adjust Multiple Balances process creates payroll element entries based on HDL batch data and adjusts payroll balances accordingly.

---

6. Can payroll balance adjustments be costed?

Yes. Payroll balance adjustments can optionally be included in payroll costing. If costing overrides are required, cost allocation HDL files must be loaded.

---

7. Can balance adjustments be included in employee payments?

Yes. If the PrepayFlag is enabled, balance adjustment results can be included in the next Pre-Payments process.

---

8. How do you fix incorrect tax withholding using balance adjustments?

Payroll managers can create balance adjustment records to:

• Increase the correct tax balance

• Negate incorrect run results

• Reassign tax amounts to the correct jurisdiction

---

9. Can balance adjustments be used for third-party payments?

Yes. Balance adjustments are commonly used when third-party providers calculate employee earnings and taxes but the employer must report those balances in Oracle Payroll.

---

10. What happens if a balance adjustment is incorrect?

If an adjustment is incorrect, administrators can:

• Roll back the batch

• Correct HDL files

• Reload balance adjustments