R12:CE: Reconciliation Of Bank Statement Line Shows Line Reconciled but Amount Reconciled is Blank (Doc ID 2062167.1)

Last updated on OCTOBER 20, 2015

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

 
ACTUAL BEHAVIOR
---------------
A Bank Statement line shows Reconciled with the  ‘Amount Reconciled’ field displayed.  But, for some unknown reason, the  ‘Amount Reconciled’  has disappeared and the line status remains Reconciled.
The Bank Statement line was manually reconciled .

Statement Line has a Bank Transaction Code with a Source = Journal, when the transaction is to be reconciled with is actually a Payment.  When viewed CE_STATEMENT_RECONCILS_ALL, there are no rows indicating it was ever reconciled to either Journal or Payment.   It appears some data corruption has occurred during the manual Reconciliation.  Table CE_RECONCILIATION_ERRORS shows the Statement Line tried to match to a Journal, as the source is Journal.  Issue does not occur all the time, and is not easily re-produced. 

 

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