SOT Fails. Conc Log shows "Internal error to CreditCardProcessor: No Data Found" (Doc ID 2630436.1)

Last updated on FEBRUARY 07, 2022

Applies to:

Symptoms

On Dev/Test: 12.2.6 version, FC Core

SOT Program Errors

ERROR (Submit Offline Transactions Wkr)
-----------------------
Processing CREDITCARD operations ..
oracle.apps.iby.exception.PSException: No Data Found
at oracle.apps.iby.payment.PaymentUtils.queryTrxn(PaymentUtils.java:707)

oracle.apps.iby.exception.CreditCardProcessorException: Internal error to CreditCardProcessor: No Data Found
at oracle.apps.iby.payment.CreditCardProcessor.processTrxn(CreditCardProcessor.java:1992)

Enter
Calling Get_CC_Issuer_Range (6 params)
Enter
CC is alpha numeric
Exit
l_ecappTab.COUNT:2
Fetching records for ECAPPID:673
Fetching records for ECAPPID:222
application_short_name:IBY
record counter:2
Crash in inner exception block=ORA-06550: line 1, column 21:
PLS-00302: component 'UPDATE_STATUS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
update_status has been executed for :IBY


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

1. Run Submit Offline Transaction (SOT) program from Payments UI
2. Check Concurrent Program Log
3. See..the settlement record in iby_trxn_summaries_all has status = 10 and BEPCODE= IBY_50320 and BEPMESSAGE = Internal error to CreditCardProcessor: No Data Found

Changes

Cause

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