Formula Allocations Produce Unbalanced Journal Entries
Last updated on MAY 30, 2018
Applies to:Oracle Fusion General Ledger Cloud Service - Version 188.8.131.52.0 and later
Oracle Fusion General Ledger - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Capture Transactions-Define Allocations and Period Entries
Generate Formula Allocation creates unbalanced journal entries.
In the following formula allocation use case a source/pool amount is allocated via some sort of pro-rata basis or uplift percentage.
Many times, these allocations will run and create multiple lines that are inserted into the gl_interface table debit/credit amounts that are balanced,
but when journal import runs, the process fails due to imbalanced journals (i.e. entered debit amount <> entered credit amount).
For example, we have an allocation (using a formula component) that allocates 1/3 of $100 across three code combinations (CCID's) ("X","Y","Z") and a single offset
to another CCID ("O").
The resulting data inserted into the GL_INTERFACE table looks as follows:
CCID Entered Debit Entered Credit
---- -------------- --------------
The allocation runs to success, but the import journal process goes to "Warning" with a EU02 error - journal isn't balanced - debits <> credits
because the amounts in CCID "X","Y", and "Z" are rounded to 33.33 (which sums to a total of 99.99) and the offset amount in CCID "O" is rounded to 100.00.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms