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

Last updated on MAY 06, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Web Applications Desktop Integrator - Version 11.5.10.0 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

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms