R12: WebADI Journals Partially Uploaded into GL Interface. Journal Import Gives Error: EU02 (Doc ID 980582.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

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>.

Cause

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