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 laterInformation 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
The total of the WebADI file has: (i.e., the Journal balances both entered and converted)
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 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 |