Unable To Perform Auto Reconciliation With One To Many Matching Rule (Doc ID 2672559.1)

Last updated on JUNE 29, 2021

Applies to:

Symptoms

On : N/A version, Manage Banking-Manage Bank Statements

ACTUAL BEHAVIOR
---------------
The requirement is to auto reconcile one bank statement line to many Receipts for which user created matching rule with one to many option for Receivables.Groupinp happens on Transaction source, Transaction Type and Transaction currency.
The matching criteria defined is by Amount, Transaction Type and advanced criteria ( Statement.Reconciliation reference LIKE '%'||Transaction.Reconciliation reference||'%' )


EXPECTED BEHAVIOR
-----------------------
The auto Reconciliation should work for matching rule

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Matching Rules
2. Run Auto Reconciliation

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This is stopping Production functionality and it is creating significant operational issues and impact to the business as it requires manual reconciliation consuming a lot of time requiring to do manually.

Cause

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