My Oracle Support Banner

Allocations Generates Unbalance Error Even After Setting Rounding To 0 In Formula Block Small Difference Due To Rounding (Doc ID 3010632.1)

Last updated on MARCH 25, 2024

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Period Close Setup & Processing

When attempting to run Allocations, the following error occurs.

The Allocation job ends in warning and the output shows

Error Total
Code Batch Name --------------------------Total Debits --------Total Credits
EU02 Batch Name AllocationRule Name-- 211,019,475,046-- 211,019,475,047
EU02 The journal entry is unbalanced and suspense posting isn't allowed in the ledger.

The issue can be reproduced at will with the following steps:

1. The currency is set to 0 precision decimals.

2. STAT currency is set to 3 precision decimals.

3. Create an elimination allocation rule with several formulas.  Some generic calculation on each block uses STAT balances/100 and End Balance PTD and the last step uses Allocated balance. Each formula block does have rounding set to 0

Sample of the source calculation: "1-213,All Empresa Values"->"All Product Values"->"All Cost Center Values"->"Ending Balance"->"PTD"->"CLP"->"[Currency Type].[Total]"->"6-T " * (("1-211,All Department Values"- "2-430500001,All Account Values"->"All Product Values"->"All Cost Center Values"->"6-213,All Intercompany Values"->"Ending Balance"->"PTD"->"STAT"- >"[Currency Type].[Total]" ) / 100) * - 1

4. Run the allocation and the journal generated has 1 unit amount unbalance, really small unbalance difference.

5. The journal lines generated show Entered DR and CR with multiple decimals , when rounded to the Accounted DR and CR creates the unbalance.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.