EGL 9.1+ : GL Journal Inter Unit Lines Pick Up Incorrect Exchange Rate Causing An Out-of-balance Condition

(Doc ID 1983417.1)

Last updated on FEBRUARY 15, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

Interunit journal Lines pick up incorrect exchange rate causing an out-of-balance condition. Specific exchange rate was manually entered on the anchor business unit line but this exchange rate was not used by IU Processor while generating interunit journal line (system generated lines).

User's Scenario -
------------------

1. Create business unit 21000; base currency USD
2. Create another business unit 21150; base currency SGD
3. Setup rounding adjustment options for both the business units.
4. Setup exchange rates for SGD / USD.
5. Create an inter unit journal. Anchor BU should be 21150 (jrnl_ln.iu_anchor_flg is Y) and non-anchor as 21000.

Journal should like –

Journal Header 21150

Journal Line 1 / BU 21150 / Foreign Currency SGD / Base Currency SGD
Journal Line 2 / BU 21150 / Foreign Currency SGD / Base Currency SGD
Journal Line 3 / BU 21150 / Foreign Currency USD / Base Currency SGD - Override the exchange rate as well (notice rate type is not populated now).
Journal Line 4 / BU 21000 / Foreign Currency USD / Base Currency USD.

6. Run journal edit.

Notice - 3 additional lines were generated by journal edit / IU Processor (interunit lines) as below -

Journal Line 5 / BU 21000 / Foreign Currency USD / Base Currency USD
Journal Line 6 / BU 21150 / Foreign Currency USD / Base Currency SGD > notice exchange rate is not the same as journal line # 3 (not same as overridden exchange rate).
Journal Line 7 / BU 21150 / Foreign Currency USD / Base Currency SGD > Rounding adjustment line generated since journal was not balanced by base currency.

Solution

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