ESFO 9.2: Fatal PeopleCode SQL Error When Accessing User Preferences From User ID With Apostrophe
Last updated on JANUARY 11, 2018
Applies to:PeopleSoft Enterprise FIN Staffing Front Office - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When trying to configure the User Preferences of a new User ID, whose value contains the apostrophe symbol, the system throws a fatal SQL Error Message when trying to open the delivered OPR_DEFAULT Component.
The nature of the Error Message involves delivered Staffing Front Office Application Package PeopleCode FO_HOT_LISTS.HotCategory.OnExecute.
- Log into the FSCM Online Application as User ID VP1
- Navigate to: PeopleTools > Security > User Profiles > Copy User Profiles
- Define User ID VP1, and click on Search button
- In the 'Copy User Profiles' page (USER_SAVEAS), define the below lusted values:
- New User ID = GCS'TEST
- Description = GCS Test
- New Password = GCS1
- Confirm Password = GCS1
- Copy ID Type Information = N
- Click on Save button
- Navigate to: Set Up Financials/Supply Chain > Common Definitions > User Preferences > Define User Preferences
- Set a User ID = GCS'TEST
- Click on the Search button
- Confirm how the system triggers a series of Error Messages
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
" A fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL error in Exec. (2,280) FO_HOT_LISTS.HotCategory.OnExecute Name:CategoryInUse PCPC:1671 Statement:31
Called from:FO_HOT_LISTS.UserHotListCategories.OnExecute Name:DisplayHotListCat Statement:48
Called from:OPR_DEFAULT.GBL.FO_USRHOTCAT_TL.RowInit Statement:3
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed. "
Unable to configure the User Preferences of new User IDs, and as such, this causes further problems when those Employees need to access further functionality within the FSCM Online Application, as defaults are not efficiently working.
If the system allows User ID values containing the apostrophe symbol within, then it should also be able to configure the User Preferences of such new User IDs without any problems.
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