When Upload WebADI Journal Fails Valid Lines Do Not Appear to Upload Causing Subsequent Upload To Create Duplicate Lines
Last updated on DECEMBER 28, 2017
Applies to:Oracle Web Applications Desktop Integrator - Version 12.1.1 and later
Oracle General Ledger - Version 12.1.1 and later
Information in this document applies to any platform.
Executable:GLLEZL - Journal Import
When uploading a WebADI Journal, if the Code Combination id (CCID) is invalid on one row, then it is not uploaded, but all the valid rows are uploaded.
The invalid rows have a red sad face, but the valid rows have the green smilie face missing.
When the invalid row is corrected and the journal uploaded again, it uploaded all rows which results in the valid rows being duplicated and causes an unbalanced journal to be created.
Create a journal template with 4 journal lines.
Of the 4 lines 3 are correct but 1 has an issue that creates an error that should stop upload of the journal data.
The upload is run and the erroring line fails validation - import shows no rows upload, 1 rows invalid.
Checking the gl_interface shows the 3 lines that passed validation did in fact get uploaded though the message indicates they have not.
After correcting the one invalid line, re-upload and all 4 lines get uploaded again.
The original upload of 3 lines should not have occurred as it causes duplication.
The issue can be reproduced at will with the following steps:
1. upload an webadi journal that has an invalid CCID
2. correct the invalid CCID on the row with the red sad face
3. upload the journal again.
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