Receipt Reconciliation Fails With APP-AR-999967188 The Receipt is in the Process Of Funds Capture Settlement (Doc ID 1283597.1)

Last updated on JULY 22, 2024

Applies to:

Symptoms

When Oracle Payments is integrated with a Processor Payment System (i.e. a real-time processor such as
Paymentech or a Dummy processor to interact directly with the Bank), the reconciliation of a receipt in
Cash Management gives following error:

APP-AR-999967188 the receipt is in the process of funds capture settlement

Alternatively, the error message may be:

AR_IBY_SETTLEMENT_PENDING_CLR(Receipt_number=??)

Steps:

1. Create, approve and format an automatic AR receipt.
2. Run Remittance
3. Go to Payments | Funds Capture Process Manager
4. Run "Create Settlement Batches" program.
5. Verify the receipt is selected by the settlement batch: Status of transaction in iby_trxn_summaries_all must be 0. Refer to note 1955533.1 for instructions.
6. Cash Management | Reconcile bank statement | Enter a manual line for remitted receipt with receipt number and status = unreconciled Available
7. Reconcile the cash management line
8. Gives following error for remitted automatic receipt with cash management line status = Unreconciled.

‘APP-AR-999967188 the receipt is in the process of funds capture settlement’

FACTS

$Header ARREREVB.pls 120.23.12010000.8 2009/11/06 08:36:16 spdixit ship

Cause

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