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 11.13.24.01.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |