Receipt Reconciliation Fails With APP-AR-999967188 The Receipt is in the Process Of Funds Capture Settlement

(Doc ID 1283597.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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:
=====
Create, approve and format an automatic AR receipt.
Run Remittance
Go to Payments | Funds Capture Process Manager
Create settlement batch.
Verify the receipt is selected by the settlement batch (iby_trxn_summaries_all.status = 0)
Cash Management | Reconcile bank statement | Enter a manual line for remitted receipt with receipt number and status = unreconciled Available
Reconcile the cash management line
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms