Formula Allocations Produce Unbalanced Journal Entries (Doc ID 2257441.1)

Last updated on AUGUST 11, 2020

Applies to:

Symptoms

On : 11.1.11.1.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
---- --------------   --------------
X     33.3333333333
Y     33.3333333333
Z     33.3333333333
O                           99.999999999

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.

Cause

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