Automatic Remittance Gives "No Data Found" for Refund Receipts (Doc ID 1420743.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Payments - Version 12.1.2 and later
Information in this document applies to any platform.
Checked for relevance on 24-Jul-2013.

Symptoms

<Patch 11811748:R12.IBY.B> from Note 1309726.1 had already been applied which fixed the previous IBY_40000/ORA-01403 error during Automatic Remittance for the majority of refund receipts.

However Automatic Remittance still gives "No Data Found" for a few refund receipts.  The "AUTOREMAPI module: Automatic Remittances Creation Program (API)" log file shows the following error:

Entering payment processing...
Calling return for pmt_trxn_extn_id
l_payer_rec.Payment_Function CUSTOMER_PAYMENT
l_payer_rec.Party_Id 138122978
l_payer_rec.org_id 82
l_payer_rec.org_type OPERATING_UNIT
l_payer_rec.Cust_Account_Id 136220766
l_payer_rec.Account_Site_Id 14264197
l_trxn_entity_id 209147797
l_amount_rec.value: 6.95
l_amount_rec.currency_code: USD
settlement_date: 10-JAN-12
Enter
party id =138122978
account id =136220766
account site use id =14264197
org id =82
org type =OPERATING_UNIT
l_payer_level: CUSTOMER_SITE_LEVEL
l_payer_id: 147287551
Settlement_Date passed as: 10-JAN-12
Settlement_Due_Date passed as:
Enter
base url=http://<server.domain:port>/OA_HTML/ibyecapp?
Exit
Enter
Timeout setting at profile level = 60000
UTL_HTTP timeout set to 60 seconds.
Continuing after setting timeout ..
Input url = http://<server.domain:port>/OA_HTML/ibyecapp?OapfAction=oraPmtReturn&OapfECAppId=222&OapfTransactionId=3985127&OapfPrice=6.95&OapfCurr=USD&OapfMode=ONLINE
Enter
starting req
set headers
writing body
reading resp
resp status code:=200
Exit
Exit
Enter
Exit
Stamping the PSON on the extension as ONT199529797
Stamping 209147797 as the initiator_extension_idon the return record
Enter
Enter
Exit
Exit
x_response.Result_Code :=No Data Found
x_response.Result_Category :=SYSTEM_ERROR
x_response.Result_Message :=No Data Found
Exit
x_return_status :<E>
x_msg_count :<1>
x_msg #1 = <&MESSAGE_TEXT>
-------------------------------------
l_response_rec.Result_Code: No Data Found
l_response_rec.Result_Category: SYSTEM_ERROR
l_response_rec.Result_message : No Data Found
create_cash_126
lc_iby_msg_data: No Data Found: No Data Found
enter insert exceptions
value of p_batch_id128548
value of p_request_id82775890
value of p_cash_receipt_id2438240
value of p_payment_schedule_id
value of p_paying_customer_id
value of p_paying_site_use_id
value of p_due_date
value of p_cust_min_rec_amount
value of p_bank_min_rec_amount
value of p_exception_codeAR_CC_AUTH_FAILED
value of p_additional_messageNo Data Found: No Data Found

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