My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.

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

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
References


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