My Oracle Support Banner

'ORA-06502 PL/SQL: Character String Buffer Too Small' in Create Settlement Batches (Doc ID 1157783.1)

Last updated on JULY 03, 2019

Applies to:

Oracle Payments - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

Find that "Create Settlement Batches" concurrent request fails with the following error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The log file showed the following:
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character
  string buffer too small
  ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 2818
  ORA-06512: at line 1
  
   at
  oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
   at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
...
  
  exception occured for  : <here a list of more than 10 Paymentech accounts with format ptk_xxxx are shown>
  SQLException occurred: ORA-06502: PL/SQL: numeric or value error: character
  string buffer too small
  ORA-06512: at "APPS.IBY_TRANSACTIONCC_PKG", line 2818
  ORA-06512: at line 1
### Steps to Reproduce ###
1. Run Create Settlement Batches (the number of payment system accounts for Paymentech should be more than 10).

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.