My Oracle Support Banner

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

Last updated on MARCH 15, 2022

Applies to:

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


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.

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 

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.

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.