GLPPOS Journals Have Been Posted Twice And GL_BALANCES Updated with Incorrect Amount (Doc ID 882302.1)

Last updated on JUNE 15, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Executable:GLPPOS - Posting

Symptoms

A journal appears to have been posted twice causing the gl_balances to show the wrong amount when you do an account inquiry. The correct amount is shown on drilldown where the journal lines are correct but do not add up to the balance total.
This means that the business reports are incorrect and it is not possible to tell the true accounting position at month end. 

The Account Analysis report does not have the correct movement to closing balance and gives a warning.

The Summary trial balance has an out of balance Cr to Drs movement for the period because only part of the journal got posted twice. This only gives a warning if all the accounts are shown in which case the total Dr's should match the total Cr's for the period.

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