My Oracle Support Banner

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.


On : 12.1.3 version, Reconciliation and Clearing

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. 



To view full details, sign in with your My Oracle Support account.

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

In this Document

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