My Oracle Support Banner

ESFO 9.2: Fatal PeopleCode SQL Error When Accessing User Preferences From User ID With Apostrophe (Doc ID 2008120.1)

Last updated on JULY 08, 2020

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.




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.