R12:CE: Reconciliation Of Bank Statement Line Shows Line Reconciled but Amount Reconciled is Blank
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms