My Oracle Support Banner

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

Last updated on MAY 28, 2020

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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