Automatic Remittance Approval Gives ORA-06502: PL/SQL: numeric or value error in IBY_FNDCPT_TRXN_PUB (Doc ID 1299559.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.
Article checked for currency on 13-SEP-2013.

Symptoms

Automatic Remittance fails for some receipts with the following error:

calling get_auth for pmt_trxn_extn_id
Before Call Create_Authorization()+
After Call Create_Authorization()-
x_return_status :<U>
x_msg_count :<1>
x_msg #1 = <ORA-06502: PL/SQL: numeric or value error: character to number conversion error en paquete IBY_FNDCPT_TRXN_PUB Cannot Create_Authorization>
----

This makes some receipts not selected for remittance.

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