Encrypt Credit Card Transaction Data: ORA-06502: PL/SQL: numeric or value error (Doc ID 1121900.1)

Last updated on JANUARY 16, 2015

Applies to:

Oracle Payments - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Getting error when running Encrypt Credit Card Transaction Data: 
   

IBY_TX_CREDITCARD_ENCRYPTION module: Encrypt Credit Card Transaction Data
+---------------------------------------------------------------------------+

Current system time is 28-FEB-2011 13:36:49

+---------------------------------------------------------------------------+

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.IBY_SECURITY_PKG", line 535
ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 194
ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 6684
ORA-06512: at line 1

Also similar error is seen when running Encrypt Transaction Extension Data:

IBY_TRXN_EXTENSION_ENCRYPTION module: Encrypt Transaction Extension Data
+---------------------------------------------------------------------------+

Current system time is 28-FEB-2011 13:28:41

+---------------------------------------------------------------------------+

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.IBY_SECURITY_PKG", line 606
ORA-06512: at "APPS.IBY_FNDCPT_TRXN_PUB", line 5433
ORA-06512: at line 1
 

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