My Oracle Support Banner

Settlement Failure Is Not Reversing The Receipt Status From Remitted To Confirmed (Doc ID 2758190.1)

Last updated on MARCH 24, 2021

Applies to:

Oracle Fusion Payments Cloud Service - Version 11.13.20.10.0 and later
Oracle Fusion Receivables Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Goal

Settlement failure is not reversing the receipt status from remitted to confirmed.
Expectation is for the functionality to work as follows:

1. Create a credit card invoice in Receivables
2. Run Automatic Receipt Creation job. This will authorize for the invoice amount by contacting Cybersource
3. Run receipt remittance batch process. This will send the payment details to IBY for settlement. Rceceipt status is updated to REMITTED
4. Now run Submit Offline Transactions job to send settlement to Cybersource
5. If the settlement fails on Cybersource end, IBY table will be updated with failure details
  IBY_TRXN_SUMMARIES_ALL.TRXNTYPEID = 8
  IBY_TRXN_SUMMARIES_ALL.STATUS = 4
  IBY_TRXN_SUMMARIES_ALL.BEPCODE = 102 (returned by CYBS)
  IBY_TRXN_SUMMARIES_ALL.BEPMESSAGE = One or more fields in the request contains invalid data.

At this stage, we expect IBY to make a call to AR and update the receipt status from REMITTED to CONFIRMED, so we can fix the issue that caused settlement failure and reprocess the payment.
This does not happen. Instead we see following error in ESS log for Transmit Settlement (Submit Offline Transactions) job

Sqlerrm ORA-06502: PL/SQL: numeric or value error: character to number
conversion error
ORA-06512: at "FUSION.AR_AUTO_RCPT_RVRSL_PKG", line 803
ORA-01403: no data found

Exception AR_ECAPP_PUB.correct_settlement_error ORA-06502: PL/SQL: numeric or
value error: character to number conversion error
ORA-06512: at "FUSION.AR_AUTO_RCPT_RVRSL_PKG", line 803
ORA-01403: no data found

Without this automatic reversal of the receipt, user cannot fix root cause and reprocess the settlement. 

Solution

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
Goal
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.