My Oracle Support Banner

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 APRIL 04, 2025

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

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
Symptoms
Cause
Solution


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