Receipt refund fails with error: Internal PL/SQL error, Debug shows Error in AP_CUSTOM_INV_VALIDATION_pkg.AP_Custom_Validation_Hook()

(Doc ID 2342079.1)

Last updated on DECEMBER 27, 2017

Applies to:

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

Symptoms

Applying Receipt to Refund activity fails with error:

ERROR
Internal PL/SQL error

FND Debug log shows below error message:

AP.PLSQL.AP_CUSTOM_INV_VALIDATION_PKG.AP_Custom_Validation_Hook 2 Begin of procedure AP_Custom_Validation_Hook
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 4 "APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_CUSTOM_INV_VALIDATION_PKG.AP_Custom_Validation_Hook<-AP_APPROVAL_PKG.Approval<-Submit_Payment_Request<- AR_REFUNDS_PVT.create_refund
with parameters (Invoice_id = 14645844)

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