Refund Error: "FRM-40734: Internal Error: PL/SQL error occurred" and ORA-06512: at "APPS.AR_REFUNDS_PVT"

(Doc ID 888845.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.0 [Release 12.0]
Information in this document applies to any platform.

FORM:ARXRWMAI.FMB - Receipts


Symptoms

When attempting to save a Refund application on a receipt, the following error is raised:
FRM-40734: Internal Error: PL/SQL error occurred

The FND Debug Log shows:


An Unexpected Error -6510 has occured. An alert has been sent to the system administration.
ORA-06510: PL/SQL: unhandle user-defined exception
ORA-06512: at "APPS.AR_REFUNDS_PVT", line 389
ORA-06502: PL/SQL: numeric or value error
...
Exit : import_Ext_Payee_Relationship
ar.plsql.AR_REFUNDS_PVT.Create_refund
EXCEPTION: AR_REFUNDS_PVT.Create_refund()ORA-06502: PL/SQL: numeric or value error


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