Fatal SQL Error when Certain Values are Entered as a Prompt for a List of Values
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.
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.
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