Web ADI Journal Line with Entered DR And Converted CR Uploads to GL But Fails Import
Last updated on JUNE 08, 2017
Applies to:Oracle Web Applications Desktop Integrator - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLLEZL - Journal Import
GL WebADI Line with Entered DR and Converted CR uploads to GL but fails Journal Import
User has created a GL Journal WebADI file where one line has the following:
"Debit" amount of 0.01
"Converted Credit" amount of 0.02
And the total of the WebADI file has: (i.e., the Journal balances both entered and converted)
total "Debit" = 211469.24
total "Credit" = 211469.24
total "Converted Debit" = 277972.33
total "Converted Credit" = 277972.33
The user uploads the Web ADI file using the following parameters:
• Automatically Submit Journal Import checked (i.e., = Yes)
• Upload Unbalanced Journals = Unchecked (i.e., = No)
The WebADI validation succeeds and the user receives a message noting the Group ID and the number of rows successfully uploaded.
The Journal Import Execution Report shows a status of "Error" and does not import the Journal.
The Error Codes are:
• EU02 This journal entry is unbalanced and suspense posting is not allowed in this ledger.
• EC03 A conversion rate type or an accounted amount must be supplied when entering foreign currency journal lines.
Since the Journal fails Journal Import, it should have failed the WebADI validation prior to even being uploaded to the GL_INTERFACE table.
Both <Patch:9090447>:R12.BNE.B and <patch:10254013>:R12.BNE.B have been applied.
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