R12.1: WebADI Journals Partially Uploaded into GL Interface. Journal Import Gives Error: EU02
Last updated on OCTOBER 20, 2017
Applies to:Oracle General Ledger - Version 18.104.22.168 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Web Applications Desktop Integrator - Version 22.214.171.124 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Includes Merged Docs 1271540.1, 873412.1, 1276549.1, 969335.1, 1161264.1
Executable:GLLEZL - Journal Import
WEBADI - Journal Wizard Upload
In some situations the WebADI Journal Wizard upload randomly skips some lines and not all lines are uploaded into the GL_INTERFACE table without justification.
In other situations uploading invalid WebADI journal may get partially uploaded into the GL_INTERFACE, even when checking the ''Validate before upload'' and unchecking the ''Upload unbalanced journals''. It is expected that the batch is validated and nothing is uploaded when not valid, however in some cases the system is able to upload partial incorrect journal data into the gl_interface table. This may happen when different errors occur in the same batch, for example a line with invalid account and unbalanced journal.
In any of the above cases an incomplete journal is created, although Web ADI it shows the message that all the rows were uploaded successfully. But, when checked from the back end , some rows are missing, which may cause EU02 error (This journal entry is unbalanced and suspense posting is not allowed) in Journal Import when it is executed and suspense accounting is not enabled. If suspense accounting is enabled the journal is automatically balanced and the user may not notice that there are missing lines in the journal.
Similar situations may be observed with other integrators than GL, for example in FA as shown in <Document 957848.1>.
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