Web ADI Journal Line with Entered DR And Converted CR Uploads to GL But Fails Import

(Doc ID 1613111.1)

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

Symptoms

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

Note: Both entered and converted amounts are provided, but you should let the application calculate the converted amounts.

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)

Note: The Server Validation choice is not available based on profile options settings. This means that the spreadsheet is performing the validation. This also means that the upload should fail if there are any errors.

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.

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