EGL9.1+: Allocation Creates Unbalanced Journal With Header Error "Journal is not Balanced on Journal Totals or Balancing Chartfield (5860,48)" (Doc ID 1903861.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
****Checked for Currency on 09-Dec-2015****

Symptoms

On :  9.1 version, Allocations

ACTUAL BEHAVIOR  
---------------
Inter-Unit Allocation creates unbalanced journal.
After edit, journal got header error "Journal is not balanced on journal totals or balancing chartfield (5860,48)"

This is inter-unit allocation
- Pool data is in USD  (with currency code USD explicitly defined on the pool) and is from USD BU with single ledger.
- Target entry is for non-USD BU with multiple ledgers and its translate ledger is in USD.
- Offset entry is for USD BU with single ledger.

Target lines created by Allocation have foreign currency = currency code = base currency of the target BU,which is non USD currency.
This is incorrect. Since pool data is in USD. It is expected target and offset lines are created in foreign currency USD.
Because target lines are created in wrong currency, the interunit lines are also created in wrong currency. This leads to unbalanced interunit lines.


EXPECTED BEHAVIOR
-----------------------
Journal from allocation is created in correct foreign currency and is balanced on both currency code and interunit transactions.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create GL BU 90000 – USD single ledger BU
2. Create GL BU 15000 – CAD multi ledger BU
3. Create detail ledgers and ledger groups.
        > Single ledger group ACTUALS under SHARE setid ( with primary ACTUALS ledger only) - used by USD BU 900000
        > Multibook ledger group ACTUALS under setid CAN01 ( with primary ACTLOCAL & translate ACTUALS ledger) - used by CAD BU 15000.
4. Create ACTG_AL05 allocation step, group, and run control
        > Pool = USD BU 90000, ACCOUNT = 635000, Currency Code = USD
        > Target = CAD BU 15000, ACCOUNT =  650000
        > Offset = USD BU 90000, ACCOUNT = 682000
5. Create journal entry in April 2013 to populate pool
6. Process Allocation group generating calc log and output
7.    Journal has more than one line created
        JOURNAL_LINE BUSINESS_UNIT LEDGER ACCOUNT AFFILIATE CURRENCY_CD MONETARY_AMOUNT FOREIGN_CURRENCY FOREIGN_AMOUNT     RT_TYPE
        1                    15000                CADLOCAL 650000                                        CAD       13000         CAD                         13000                       CRRNT
        2                    90000                ACTUALS    682000                                        USD      -10000        USD                        -10000                      CRRNT
8.    Run journal edit separately and additional IU and translate ledger lines created but journal is not balanced on currency code.
        > Additional IU lines created as below ( incorrect)
        3                    15000                CADLOCAL  200200              90000                 CAD      -13000        CAD                         -13000                      CRRNT
        4                    90000                ACTUALS    100100              15000                 USD       10000         CAD                          13000                      CRRNT
        > Additional translate ledger lines created as below ( incorrect)
        1                    15000                ACTUALS    650000                                        USD       10400         CAD                          13000                       AVG
        3                    15000                ACTUALS    200200             90000                  USD       -10400        CAD                         -13000                       AVG

       (Running edit in separate batch or with allocation create same result)

9. Expected journal ( per 8.9 release and analysis).
  > Expected lines from allocation process
       JOURNAL_LINE BUSINESS_UNIT LEDGER ACCOUNT AFFILIATE CURRENCY_CD MONETARY_AMOUNT FOREIGN_CURRENCY FOREIGN_AMOUNT     RT_TYPE
        1                    15000                CADLOCAL 650000                                        CAD       13000         USD                           10000                      CRRNT
        2                    90000                ACTUALS    682000                                        USD      -10000        USD                          -10000                      CRRNT
  > Expected IU lines created by journal edit
        3                    15000                CADLOCAL 200200            90000                   CAD     -13000          USD                           -10000                     CRRNT
        4                    90000                ACTUALS    100100            15000                   USD      10000          USD                            10000                     CRRNT
       > Expected translate ledger lines created by journal edit
        1                    15000                ACTUALS 650000                                          USD       10400          CAD                            13000                     AVG
        3                    15000                ACTUALS 200200             90000                     USD     -10400          CAD                           -13000                     AVG



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete allocation process.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms