Credit Card Receipts Remittance Is Failing and Automatic Error Correction Handling is Not Retrying to Process the Receipt
(Doc ID 1609370.1)
Last updated on JULY 10, 2020
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
The authorization of the credit card is success, but the remittance is not happening.
The comments on receipt is showing as "".
You have a Receipt Method setup to automatically retry for automatic error correction handling, but the receipt is never getting pulled.
In this case the Capture fails and the system does not select the correct row on IBY_TRXN_SUMMARIES_ALL. It does not automatically retry the receipt.
The following query has been identified as the faulty code:
Because the max(rowid) does not guarantee the most recent record, the inner query was actually returning the original authorization failure rather than the settlement failure. Because the authorization transaction type does not match with the settlement transaction that failed during the Submit Offline Transaction process, the receipt is never pulled for automatic error correction handling (as shown in the debug logs that were uploaded).
You have to manually take the "Retry" corrective action in the Correct Funds Transfer Errors form to get the receipts to progress. This should happen automatically as defined in the receipt class definition.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!