R12:CE: Automatic Bank Reconciliation Not Working - Missing Matching Criteria (Doc ID 2138821.1)

Last updated on JUNE 11, 2024

Applies to:

Goal

Autoreconciliation is not matching due to missing matching criteria.

How to populate the check number in the Number column of the Bank Statement Line during the Bank Statement loader and Import program.

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

1. Submit a new request in Cash Management module.
2. Select the Bank Statement Loader and hit OK.
3. In the Process Option, select Load, Import and Auto Reconciliation, fill in the mapping name and the file name  and the GL date.
4. Once completed, go to Enter/Reconcile Bank Statements to see them out there. They should be in reconciled status, but are not.

Solution

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