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:

Symptoms

On : 11.13.24.01.0 version, Period Close Setup & Processing

When attempting to run Allocations, the following error occurs.

ERROR
-----------------------
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.


STEPS
-----------------------
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.

Cause

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