R12.1:CE: Error "Missing matching criteria" Reconciling Payment Batch Due to NULL Bank Reference Number

(Doc ID 2274483.1)

Last updated on JUNE 07, 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

When attempting to run the AutoReconciliation,
the following error occurs.

Missing matching criteria.

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

1. Responsibility: Cash Management
2. Path: Other -> Requests -> Run
3. Run the AutoReconciliation
The following error is showed:

Missing matching criteria.

Note:
Bank Statement Detail Report shows the payment batch 29MAR17-NL-CCC-ELEC-UTI as Unreconciled.
The batch in question is not available for reconciliation as per Batches Available for Reconciliation Report.

Payment Batch Name 29MAR17-NL-CCC-ELEC-UTI continues to be Unreconciled (amount includes the payment for $85K that was corrected with data fix).



The issue has the following business impact:
Due to this issue, users cannot reconcile the payment.

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