Field Length Issue - DTYPE_NOTE (Doc ID 545331.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.2.216 [16084] to 8.1.1 SIA [21111] [Release V7 to V8]
Information in this document applies to any platform.
- - -
Product Release: V7 (Enterprise)
Version: 7.5.2.216 [16084]
Database: Oracle 8.1.7.4
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8

This document was previously published as Siebel SR 38-1436801761.

""Checked for Relevance on 10-Dec-2009""
""Checked for Relevance on 25-Nov-2013""


Symptoms

Hi,

We have a requirement to have a text field that holds 5000 characters. We have created a new long column on the S_OPTY_X extension table and mapped a new DTYPE_NOTE field to the column.

We have displayed the new field in a form applet with control HTML type = TextArea. Currently, the users are allowed to enter in 16383 characters. We need to limit users to only entering in 5000 characters. We have tried the following:

1. Text Length Override field user prop on the new field. Does not work.

2. HTML attribute (i.e. 'cols=50 rows=3 wrap=hard'). This attribute limits the text area of the box, but does not limit the number of characters. The format of the content will vary, so setting the text area limits is unacceptable.

3. Writing script on PreSetFieldValue using "len(FieldValue)" function. This does not meet the business requirement because it only checks the length AFTER the user steps off the record. The requirement is to limit the user from entering in over 5000 characters.

Please advise on how we can limit the number of characters entered to 5000.

Regards.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms