Single Quote On Non Person Profile Search Page Causes Fatal SQL Error - "SQL error in DescribeCol. (2,279) JPM_COMMON_PROFILE_SEARCH.CommonProfileSearch.OnExecute Name:doSearch PCPC:6783 Statement:85"
(Doc ID 2985926.1)
Last updated on NOVEMBER 14, 2023
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When a single quote is entered into a search field on Non Person Profile Search page a fatal sql error occurs.
The issue can be reproduced with the following steps:
Navigate to Workforce Development > Profile Management > Profiles > Non person profile Enter search criteria containing a single quote ‘ and search
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |