ECM: Bank Reconciliation Generates Reconciliation Status of Ambiguous Match for AR Deposits (Doc ID 2916971.1)

Last updated on DECEMBER 23, 2022

Applies to:

Symptoms

User is trying to reconcile AR Deposits. The Rule ID for DP_11_ALL_REF_02 (INDIVIDUAL DEPOSITS BY ID) is added to the Bank Account Reconciliation Rules. There is a perfect match (Date, Reference, and Amount) between the Bank Statement and the AR Deposits but the Bank Reconciliation process did not reconcile the Deposits.  Instead, the Reconciliation Status of "Ambiguous Match" was generated and can be seen on the Enter Bank Statement > Bank Transaction Entry page.

STEPS
1. Navigate to Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
2. Create a new Pending Item Group with 2 Items
3. Navigate to Accounts Receivable > Receivables Update > Request Receivables Update
4. Run AR Update
5. Navigate to Accounts Receivable > Payments > Online Payments > Regular Deposit
6. Create 1st Regular Deposit for one of the Items in Step 2
7. Create 2nd Regular Deposit for the other Item in Step 2
8. Navigate to Accounts Receivable > Payments > Apply Payments > Apply Payments Worksheet
9. Build a Payment Worksheet for the 1st Regular Deposit
10. Build a Payment Worksheet for the 2nd Regular Deposit
11 Run AR Update
12. Navigate to General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem
13. Run Journal Generator to pick up the Accounting Entries in Receivables with the Edit and Post boxes checked
14. Navigate to Banking > Administer Reconciliation > Bank Account Recon Rules
15 On the Bank Account Reconciliation Rules page for the Bank Account, associate Reconciliation Rule ID = DP_11_ALL_REF_02 to Source = Receivables Deposits
16. Navigate to Banking > Bank Statements > Enter Bank Statements
17. Create a Bank Statement with 2 Bank Transactions where each transaction has the same Date, Reference, and Transaction Amount and corresponds to the above Regular Deposits, respectively
18. Navigate to Banking > Reconcile Statements > Process Bank Reconciliation
19. Run Bank Reconciliation to reconcile the Bank Statement to the Deposits
20. Process will complete to Success
21. Navigate to Banking > Bank Statements > Enter Bank Statements
22. Display the Bank Statement
23. On the Bank Transaction Entry page under the Recon Information tab, both of the Bank Transactions have the Reconciliation Status of “Ambiguous Match”

Changes

Cause

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