My Oracle Support Banner

Text Area Control Doesnt Count Carriage Return And Special Characters (Doc ID 2787653.1)

Last updated on JULY 04, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Web UI

ACTUAL BEHAVIOR
---------------
Text Area control doesnt count carriage return and special characters

When a text area control (Type 39) has a field limit set in V_CONTROL_SPECIFIC_1 set to 4000

Here when the entered text have multiple carriage return or special characters the system doesn't count them while showing the error message "There are too many characters".

However when we try to save them to a database field with 4000 character we get ORA-12899: value too large for column error

EXPECTED BEHAVIOR
-----------------------

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
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.