AGIS Unbalanced Journal Gets Transfered To GL Interface And Is Stuck With "EU02" Error
Last updated on DECEMBER 05, 2013
Applies to:Oracle Financials Common Modules - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle General Ledger - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Customer created an Outbound AGIS transaction with balanced amounts and submitted the batch. The recipient approved the batch, but somehow the Recipient Distribution lines totals are not balanced: the total credit is not equal to the total debit in the Recipient Accounting side. Now, the AGIS batch was submitted for transfer to GL and it is stuck in GL_INTERFACE with EU02 error status.
Steps to reproduce :
1)Create an Outbound transaction for Amount 100
2)Give the Initiator Accounting for Amount 100
3)Give the Recipient Accounting for Amount 100
4)Click on Submit!
5)Outbound Transaction 7589 is created
6)Go to inbound Transaction Query Above Transaction Created
7)Select Update for an Inbound batch which is in Received state.
8)Change the Recipient Accounting amount from 100 to 10
9)Add line for amt 10
10)Add 1 more line for 10
12)You will go back to the search screen
13)Click on update transaction
14)You will only see 1 row of amount 10
15)You will not see Amount you added in step 9 and 10
15)Add 1 row for amount 90
16Click on approve
17)The Inbound Transaction is approved
18)Go to Outbound transaction Query Above Transaction Created
19)Click on Update
20)From the screen Click on View Details
21)Check the Recipient Account Debit and Credit Does not match
It is possible to change recipient accounting on credit and debit side.
Test cases executed:
a. While attempting to change the accounting lines, example delete some segments from the flex accounts, or change the bsv, it gets approved,
b. While attempting to change the Recipient Accounting, the following error appears when Approve :
The total Recipient Distribution Amount does not match the Transaction Amount. If the Transaction Amount is a Credit Amount then the Distribution Amount must be a Debit Amount and vice versa.
It would be expected to see this error for newly inserted lines too, but this does not happen, causing the issue.
EU02: This journal entry is unbalanced and suspense posting is not allowed in this ledger,for the data in the interface table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms