EGL9.1+: IU Lines For Translate Ledger Are Created With Wrong Exchange Rate After Applying Fix From Bug 21348143 (Doc ID 2082962.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On :  9.1 version, Journal Edit

ACTUAL BEHAVIOR  
---------------
IU lines for translate ledger are created with wrong exchange rate after applying Bug 21348143 (9.1 Bundle#36)

Site tested fix from Bug 21348143, now see below issues:

For anchor business unit 00601, interunit line # 4 and 7 for ledger ACTUSD, base currency and foreign currency are different but the amounts are same, the amounts are not getting calculated based on exchange rate.

Before Edit - Journal 1105014
JOURNAL_LINE LEDGER CURRENCY_CD MONETARY_AMOUNT FOREIGN_CURRENCY FOREIGN_AMOUNT
1 ACTUSD USD 0 USD 0
2 ACTUSD USD 10 USD 10
3 ACTLCL GBP 0 USD -10

After Edit - 1105014
JOURNAL_LINE LEDGER CURRENCY_CD MONETARY_AMOUNT FOREIGN_CURRENCY FOREIGN_AMOUNT
1 ACTGBP GBP 0 GBP 0
1 ACTLCL GBP 0 GBP 0
1 ACTUSD USD 0 GBP 0
2 ACTUSD USD 10 USD 10
3 ACTGBP GBP 0 GBP 0
3 ACTLCL GBP 0 USD -10
3 ACTUSD USD 0 GBP 0
4 ACTGBP GBP 6.47 GBP 6.47
4 ACTLCL GBP 6.47 USD 10
4 ACTUSD USD 6.47 GBP 6.47
5 ACTUSD USD -10 USD -10
6 ACTGBP GBP 0 GBP 0
6 ACTLCL GBP 0 USD 10
6 ACTUSD USD 0 GBP 0
7 ACTGBP GBP -6.47 GBP -6.47
7 ACTLCL GBP -6.47 USD -10
7 ACTUSD USD -6.47 GBP -6.47
Please refer to file "POC test" attached.

EXPECTED BEHAVIOR
-----------------------
After edit

JOURNAL_LINE LEDGER CURRENCY_CD MONETARY_AMOUNT FOREIGN_CURRENCY FOREIGN_AMOUNT
1 ACTGBP GBP 0 GBP 0
1 ACTLCL GBP 0 GBP 0
1 ACTUSD USD 0 GBP 0

4 ACTGBP GBP 6.47 GBP 6.47
4 ACTLCL GBP 6.47 USD 10
4 ACTUSD USD 10 GBP 6.47

7 ACTGBP GBP -6.47 GBP -6.47
7 ACTLCL GBP -6.47 USD -10
7 ACTUSD USD -10 GBP -6.47

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply fix from Bug 21348143
2. Set up 3 Business Unit with ledger group as below:
    TGBP1 - Map to customer's BU 00601 Anchor - Base GBP, Ledger group ACTUALS with 3 ledgers, ACTLCL, ACTGBP (Translate in GBP) , ACTUSD (Translatein USD)
    TGBP2 - Map to customer's BU 00575 - Base GBP, Ledger group ACTUALS with 3 ledgers, ACTLCL, ACTGBP (Translate in GBP) , ACTUSD (Translate in USD)
    TUSD1 - Map to customer's BU 01460 - Base USD, Ledger group ACTUALS with 1 ledger, ACTLCL

3.. Create a spreadsheet interunit journal with below lines:
     Unit Ledger Account Dept ID Affiliate Foreign Currency Amount Base Amount
    TGBP1 ACTUSD 620000 10000        USD 0 0
    TGBP2 ACTLCL        630000 20000 TUSD1 USD 10 0
    TUSD1 ACTUSD 640000 31000 TGBP2 USD -10 -10

4. Run Spreadsheet Journal Import
5. Run batch Journal Edit
6. Journal Edit completes successfully, and the journal is marked to Valid
7. Check the journal lines that got created after edit.


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