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

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise FIN Staffing Front Office - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE:

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.

REPLICATION STEPS:

   - 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.

ERROR MESSAGE:

   " 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. "

BUSINESS IMPACT:

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.

EXPECTED BEHAVIOR:

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.
 

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