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 (Doc ID 2071137.1)

Last updated on OCTOBER 12, 2016

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.

Symptoms

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
-----------------------
Error displayed:

Error(s):
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
transaction failed

The log correctly show COMMUNICATION_ERROR, and that is what AR user is
expecting to see to know there was a connection problem.


 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receivables Manager
2. Transactions
3. Try to process credit card payment

Changes

 Recent patching.

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