R12.1:CE: Bank Statement Line "Reconciled" But There Are No Reconcilied Transactions

(Doc ID 2257254.1)

Last updated on APRIL 20, 2017

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

Bank statement line is showing as "Reconciled" but there are no reconciled transactions for the line.

Expect to see reconciled transactions for the line.

The issue can be reproduced at will with the following steps:

1. Responsibility: Cash Management
Production instance

2. Path: Bank Statements -> Reconciliation/UnReconciliation

Bank statement line is showing as "Reconciled" but there are no reconciled transactions for the line.
The receipt was created as CLEARED. It is not reconciled against CE.
Cannot reproduce at this point.
The issue occurred for a specific Bank Statement Line. Not sure if others are affected.

NOTE: It appears that the AR Receipt Reconciliation trail is not proper after running the SQL statements in MOS Doc ID 2232553.1.

WORKAROUND: None


The issue has the following business impact:
Due to this issue, users cannot reconcile the bank statement for this date and account.



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