Apostrophe Not Validated in Search Match Utility and Results in SQL error in Exec. (2,280) Error (Doc ID 2036067.1)

Last updated on SEPTEMBER 07, 2015

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 the first name / last name contains an apostrophe, this is not validated by the Search match functionality , and a fatal SQL error occurs.

Error : SQL error in Exec. (2,280) DERIVED_HCR_SM.SM_SEARCH_BTN.FieldFormula Name:PersonSrchResult PCPC:67183 Statement:940

Steps to replicate :

1) Set Up HCM ; System Administration; Utilities; Search/Match; Search/Match.
2) Enter First name : "D'Andre" and Last Name : " Anderson" and search.

Error : SQL error in Exec. (2,280) DERIVED_HCR_SM.SM_SEARCH_BTN.FieldFormula Name:PersonSrchResult PCPC:67183 Statement:940

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