My Oracle Support Banner

While updating comment in address details Error Value Too Large For Column "OFSLL"."ADDRESS"."ADR_COMMENT" (actual: 350, Maximum:240 (Doc ID 2676601.1)

Last updated on JUNE 03, 2020

Applies to:

Oracle Financial Services Lending and Leasing - Version 14.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

while funding the application, system failed with error. Address comment column value is large for existing column. 

ERROR
-----------------------

Ora Error Code : 12899 - Value too large for column OFSLL ADDRESS ADR_COMMENT (actual: 350, maximum: 240)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Origination application entry screen
2. Go to address details 
3. Enter comment more than 240 characters.
4. System fails with error 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users not able to process the application. since there is no maximum number of characters support information, user entered more than 240 characters

On : 14.6.0.0.0 version, Implementation Support

while funding the application, system failed with error. Address comment column value is large for existing column.

ERROR
-----------------------

Ora Error Code : 12899 - Value too large for column "OFSLL"."ADDRESS"."ADR_COMMENT" (actual: 350, maximum: 240)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Origination application entry screen
2. Go to address details
3. Enter comment more than 240 characters.
4. System fails with error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users not able to process the application.. since there is no maximum number of characters support information, user entered more than 240 characters

Error : aaiacc_en_111_01.insert_customer

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


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