R12.1:CE: Bank Statement Line "Reconciled" But There Are No Reconcilied Transactions (Doc ID 2257254.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

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