Payments Transaction Is Shown As Failed When User's Name Is More Than 25 Characters In Length But The Transaction Is Posted Successfully To Core Banking, Logs Show Error ORA-12899: value too large for column (Doc ID 2465242.1)

Last updated on JUNE 16, 2021

Applies to:

Symptoms

Payment transaction shows error on screen when the user's name is more than 25 characters in length but the transaction gets posted to Core Banking.

ERROR
-----------------------
Below error is shown in the logs :
ORA-12899: value too large for column "OBDX_GIB"."DIGX_AP_TRANSACTION"."CREATOR_FIRST_NAME" (actual: 29, maximum: 25).


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Initiate a payment transaction using a user whose first name is more than 25 characters in length.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.