My Oracle Support Banner

WEBADI: Web ADI Journal Line with Entered DR And Converted CR Uploads to GL But Fails Import (Doc ID 1613111.1)

Last updated on JULY 29, 2021

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

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

The total of the WebADI file has: (i.e., the Journal balances both entered and converted)

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 and patch:10254013 have been applied.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.