EGL9.2: Receiving Journal Edit Header Error (5860,77) "System cannot Perform Rounding Adjustment to Ledger XXXXX (Translate Ledger) for Option Adjust Last Journal Line." (Doc ID 1936400.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

After upgrading to 9.2 PI#5, running batch journal edit on an imported spreadsheet journal returns below error:

ERROR
-----------------------
Error Set 5860 Msg 77 - System cannot perform rounding adjustment to ledger ACT_USD for option Adjust Last Journal Line.      

SETUP
-----------------------
Ledger Group is mutibook ledger with LOCAL as primary and ACT_USD as translate ledger. 

 

WHAT IS WORKING
------------------------------
Same journal was loaded and edited in 9.1 without error.  
In 9.1, the last ACT_USD line has RT_TYPE blank and the rounding works.  
In 9.2, RT_TYPE still says CRRNT, and it produces the error noted.
The only way to fix this is open the journal on-line and manually update the last line of the journal after blanking out the RT_TYPE manually.    



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Import a spreadsheet journal with 4 lines to LOCAL ledger of business Unit ( no IU transaction). 

    LOCAL 33.34 AUD (Base)
    LOCAL 33.33 AUD (Base)
    LOCAL 33.33 AUD (Base)
    LOCAL -100.00 AUD (Base)

2. Run Batch Journal edit.

3. Journal Errors out with Error (5860, 77)

    Here are the translate ledger lines after journal edit. Exchange Rate: 1AUD = 0.27226442USD. Last line needs to be adjusted to  -27.22 to ensure journal is balanced.

    ACT_USD 9.08 USD (Base)
    ACT_USD 9.07 USD (Base)
    ACT_USD 9.07 USD (Base)
    ACT_USD -27.23 USD (Base)




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