Fatal SQL Error when Certain Values are Entered as a Prompt for a List of Values (Doc ID 2110065.1)

Last updated on JANUARY 30, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

In Set Up SACR > System Administration > Utilities > List of Values > List of Values, when selecting a prompt value containing an apostrophe or numeric value, the value will be accepted. However, manually typing the same value will result in a SQL error.

ERROR
-----------------------
Fatal PeopleCode SQL error occurred.
SQL error in Exec. (2,280) SCC_COMMON.Components.SCC_SL_LOV.OnExecute  
Name:SCC_SL_LOV_VAL_SCC_SL_LOV_VALUE_FieldChange  PCPC:14551  Statement:234
Called from:SCC_SL_LOV.GBL.SCC_SL_LOV_VAL.SCC_SL_LOV_VALUE.FieldChange  Statement:1 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Navigate to Set Up SACR > System Administration > Utilities > List of Values > List of Values and create a list for record NM_ROYPREF_TBL.
2.  Go to the bottom of the page.
3.  Click on the prompt lookup button in Excluded Values.
4.  Enter 'a or aan't.
5.  Get error "Fatal PeopleCode SQL error occurred." The value will be accepted if you just use the prompt, but if you manually type a value with an apostrophe or a numeric value, an error will appear.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users get an error when making this change.

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