Balance Adjustments Load in Oracle Fusion HCM Payroll

 This guide provides a comprehensive walkthrough for creating and executing a Balance Adjustment using the HCM Data Loader (HDL) in Oracle Fusion HCM Payroll.

1. HDL File Construction

To perform a balance adjustment via HDL, you must prepare two specific .dat files. These files define the metadata and the actual data values to be adjusted.

A. BalanceAdjustmentHeader.dat

This file establishes the batch and the group parameters for the adjustment.

METADATA|BalanceAdjustmentHeader|BatchName|LegislativeDataGroupName

MERGE|BalanceAdjustmentHeader|BalanceAdjustmentsFITtoSITBatch_09092025_V1|US Legislative Data Group

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

MERGE|BalanceAdjustmentGroup|BalanceAdjustmentsFITtoSITBatch_09092025_V1|2025/07/10|US Legislative Data Group |US Consolidation Group|Biweekly|Y|N

B. BalanceAdjustmentLine.dat

This file defines the specific lines of the adjustment, including assignment details and the input values being modified.

Line Metadata: Defines the assignment number (E10020), the element name (Adjust Resident State), and the Tax Reporting Unit 

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

MERGE|BalanceAdjustmentLine|BalanceAdjustmentsFITtoSITBatch_09092025_V1|2025/07/10|1|US Legislative Data Group|US Consolidation Group|Biweekly|E10020|Adjust Resident State|Good Samaritan Hospital

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

MERGE|BalanceAdjustmentValue|BalanceAdjustmentsFITtoSITBatch_09092025_V1|2025/07/10|1|US Legislative Data Group|US Consolidation Group|Biweekly|Adjust Resident State|State|15

2. Importing the HDL Files

Once your .dat files are zipped, follow these steps to load them into the system:

Login to Fusion Applications.

Navigate to My Client Groups > Data Exchange.

Select Import and Load Data under the HCM Data Loader section.

Click Import File and choose Local File as the source.

Upload the BalanceAdjustmentHeader zip file first and click Submit.

Wait for the Header process to complete fully before submitting the BalanceAdjustmentLine zip file.

3. Executing the Balance Adjustment Flow

After the data is successfully loaded into the stage tables, you must run the payroll flow to apply the adjustments to the worker balances.

Navigation & Submission

Navigate to My Client Groups > Payroll > Submit a Flow.

Search for the flow Adjust Multiple Balances.

Enter a unique Payroll Flow name (e.g., Adjust Multiple Balances E10020).

Select the Batch Name that corresponds to your HDL load (e.g., BalanceAdjustmentsFITtoSITBatch_09092025_V1).

Set the Reason (e.g., Corrective Action) and click Submit.

Monitor the Payroll Checklist until the "Adjust Multiple Balances" task shows a status of Completed. Once finished, navigate to the worker's records to verify that the balances have been updated correctly.