Field Length Issue - DTYPE_NOTE
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 220.127.116.11  to 8.1.1 SIA  [Release V7 to V8]
Information in this document applies to any platform.
- - -
Product Release: V7 (Enterprise)
Version: 18.104.22.168 
Database: Oracle 22.214.171.124
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""
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms