My Oracle Support Banner

ORA-01400 When Submitting Authorizations For VISA Cards (Doc ID 1500332.1)

Last updated on JANUARY 24, 2020

Applies to:

Oracle Payments - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

When performing an authorization (to FDC) from the iPayment Test UI using a Visa card, the following error is seen:
  
  Authorization operation failed. SQLException occurred: ORA-01400: cannot insert NULL into "IBY"."IBY_TRXN_EXTENSIBILITY"."EXTEND_VALUE") ORA-06512:
  at "APPS.IBY_TRANSACTIONCC_PKG", line 235 ORA-06512:
  at "APPS.IBY_TRANSACTIONCC_PKG", line 595 ORA-06512: at line 1
  
 Authorizations are successful for Mastercard from iPayment Test UI.
  
IBY Debug log shows the following exception:

STATEMENT:[iby.payment.CreditCardPayment.insertAuthResults]:phase 4: executing update
EXCEPTION:[iby.payment.CreditCardPayment.insertAuthResults]:java.sql.SQLException:

ORA-01400: cannot insert NULL into
  ("IBY"."IBY_TRXN_EXTENSIBILITY"."EXTEND_VALUE")
  ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 235
  ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 595
  ORA-06512: at line 1
  
  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
  at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)

Changes

 

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
Changes
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.