My Oracle Support Banner

Reverse Receipt gives APP-AR-999967187: The receipt is in the process of funds capture settlement (Doc ID 829034.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Receivables - Version 12.0.4 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payments - Version 12.0.4 to 12.1.1 [Release 12.0 to 12.1]
Oracle Payments - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
 



Symptoms

When attempting to reverse a receipt in AR (that has been previously settled in Payments), the following error occurs:

APP-AR-999967187: The receipt is in the process of funds capture settlement. Receipt reversal is allowed only after settlement is processed in Payments module.

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


1) Create an Automatic Receipt Batch eligible for processing via Bank Account Transfer.

2) Create a Remittance Batch for this Receipt.

3) Run required programs to process the receipts in Oracle Payments (i.e. "Create Settlement Batches" and "Fetch Settlement Batch Clearing" for processor payment systems and "Submit Offline Transactions" for Gateway payment systems).

4) Data has been verified in iby_trxn_summaries_all table, showing that the Funds Capture Settlement has been completed

select * from iby_trxn_summaries_all
where transactionid in (select transactionid
from iby_fndcpt_tx_operations
where trxn_extension_id in (select
payment_trxn_extension_id from
ar_cash_receipts_all where RECEIPT_NUMBER = '&number'));

Expected Result: All transactions are in STATUS 0 (which means completed).

5) Attempt to reverse the receipt in AR. Unable to do so because of the above message.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

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