My Oracle Support Banner

Account Statement is Not Getting Generated for Account which has Transaction Description Length Beyond 255 (Doc ID 2573858.1)

Last updated on AUGUST 16, 2019

Applies to:

Oracle FLEXCUBE Direct Banking - Version DB 5.3 to DB 12.0.3 [Release DB 5 to DB 12]
Information in this document applies to any platform.

Symptoms

ERROR:

--------------

For accounts which has description length beyond 255 will get this exception as below while downloading account statement :

ERROR java.sql.BatchUpdateException: ORA-12899: value too large for column "FCDBADMINLIVE"."ACCTACTIVITY"."DESCRIPTION" (actual: 264, maximum: 255) 

ACTUAL BEHAVIOR 
---------------
Account Statement is not getting generated for account which has transaction description length beyond 255.

EXPECTED BEHAVIOR
-----------------------
Account statement should get generated even for such account which has transaction description length beyond 255

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to User application
2. Navigate to Account Summary
3. Select account for which statement need to download (typically having transaction description length beyond 255)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users who have transactions in their account with description length beyond 255 are unable to view account statement and unable to generate account statement

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.