ORA-6502: PL/SQL: numeric or value error: NULL index table key value in Package IBY_FNDCPT_TRXN_PUB and should be Communication Error displayed to the users
Last updated on MARCH 12, 2018
Applies to:Oracle Payments - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Credit Card Authorization error message is misleading for users after applying patch 18053306. Before patch 18053306 , the users would see the generic Communication Error message when connection failed during credit card authorization.
After patch 18053306 the Communication Error not displayed for timeout / connection issues for the Receivables transactions. This is causing confusion to the users.
Error APP-IEX-240781:A cash receipt could not be created because
of ORA-6502: PL/SQL: numeric or value error: NULL
index table key value in Package IBY_FNDCPT_TRXN_PUB
Procedure Create_Authorization. Authorization of credit card
The log correctly show COMMUNICATION_ERROR, and that is what AR user is
expecting to see to know there was a connection problem.
The issue can be reproduced at will with the following steps:
1. Receivables Manager
3. Try to process credit card payment
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms