Credit Card Receipts Remittance Is Failing. (Doc ID 1609370.1)

Last updated on MARCH 08, 2017

Applies to:

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

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

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