ORA-01400: cannot insert NULL into ("IBY"."IBY_TRXN_SUMMARIES_ALL"."INITIATOR_EXTENSION_ID") and ("IBY"."IBY_TRXN_CORE"."ENCRYPTED") (Doc ID 1675558.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

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

Symptoms

When adding a prepayment with a payment type of "Credit Card" to an order in OM, the following error is received:

ERROR
-----------------------
Pre-payment Credit Card Authorization for Payment Line Number 1 failed with error
SQLException occurred: ORA-01400 cannot insert NULL into ("IBY"."IBY_TRXN_SUMMARIES_ALL"."INITIATOR_EXTENSION_ID")
ORA-06512 : at "APPS.IBY_TRANSACTIONCC_PKG", line 1395
ORA-06512: at line 1 (IBY_40000)


When patch 18379316:R12.IBY.C was applied to fix this issue, a new error occured with a different NULL problem:

ERROR
-----------------------
Pre-payment Credit Card Authorization for Payment Line Number 1 failed with error SQLException occured:
ORA-01400: cannot insert NULL into ("IBY"."IBY_TRXN_CORE"."ENCRYPTED")
ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 1413
ORA-06512: at line 1 (IBY_40000).

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