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 MAY 20, 2024

Applies to:

Symptoms

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.

Cause

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