AGIS Unbalanced Journal Gets Transfered To GL Interface And Is Stuck With "EU02" Error

(Doc ID 1480183.1)

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
  11)Press enter
  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

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