Value of Research Topic (RTE) Field Gets Stored with HTML Tags in Database

(Doc ID 2358617.1)

Last updated on FEBRUARY 14, 2018

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Student Information

ACTUAL BEHAVIOR
---------------

In Candidate Management - Research Topic page, only 247 characters are allowed to save the page if length of the characters in the field is 254 then an error message appears.

 

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

"The value for the field 'Research Topic' (SSR_RS_TOPIC.SSR_RS_RSRCH_TOPIC) was over by 7 characters. Reduce to 254 or less characters. (126,141)
A long edit box on the page allows essentially unlimited text, but the record field specified that the field is of fixed length. You entered a value longer than that limitation, so the value requires truncation to fit the
record field."


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Records and Enrollment - Graduate Research Management - Candidate Management - Research Topic
2. Create Topic and enter characters greater than 247 in Research Topic field
3. Attempt to save the page, an error message pops up.


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