ECM: Bank Statement Status Is Not Updated Correctly When Using Semi-Manual Reconciliation And Multiple Statements Are Involved (Doc ID 2827001.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When a bank statement contains ACH payment and is reconciled, and then an ACH return is received, un-reconcile it using the semi-manual recon page and then when these bank statements are reconciled along with others, then the bank statement status is not updated correctly.

STEPS
---------
1. Create an ACH voucher (Accounts Payable - Vouchers - Add / Update - Regular Entry) to be processed through Financial Gateway
2. Pay the voucher (Accounts Payable - Payments - Pay Cycle Processing - Pay Cycle Manager)
3. Dispatch the payment (Financial Gateway - Process Payments - Payment Dispatch)
4. Create a bank statement (Banking - Bank Statements - Enter a Bank Statement)
5. Reconcile the bank statement with the voucher (Banking - Reconcile Statements - Process Bank Reconciliation)
6. Create a bank statement with ACH return (Banking - Bank Statements - Enter a Bank Statement)
7. Using semi-manual reconciliation, un-reconcile the voucher. (Banking - Reconcile Statements - Semi-Manual Reconciliation)
8. Verify the bank statement in step 4 to be ready status (Banking - Bank Statements - Enter a Bank Statement)
9. Create another ACH voucher (Accounts Payable - Vouchers - Add / Update - Regular Entry)
10. Pay the voucher in step 9 (Accounts Payable - Payments - Pay Cycle Processing - Pay Cycle Manager)
11. Dispatch the payment (Financial Gateway - Process Payments - Payment Dispatch)
12. Create a bank statement for voucher in step 9 (Banking - Bank Statements - Enter a Bank Statement)
13. Using semi-manual recon page, reconcile bank statement in step 4, 6, 12, and voucher in step 9 (Banking - Reconcile Statements - Semi-Manual Reconciliation)
14. Observe that the bank statements in step 4, 6 are not updated to complete (Banking - Bank Statements - Enter a Bank Statement)

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.