E-AD: 'Find In' Feature In Application Designer Gives SQL Error When Searching for Single Quote ' Characters

(Doc ID 2251256.1)

Last updated on APRIL 03, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Find in in Application Designer doesn't work if search string has Single quotes. For example: if you try to search for hard coded value of 'test, you will get the following error.

File: E:\pt856-107-R1-debug\peopletools\src\pside\PSFindInDlg.cppSQL error. Stmt #: 4669 Error Position: 28 Return: 8012 - Invalid syntax in SQL statement Failed SQL stmt: SELECT COUNT(*) FROM PSPCMTXT P ,PSRECDEFN D WHERE P.OBJECTID1 = :1 AND P.OBJECTVALUE1 = D.RECNAME AND D.RECTYPE IN (0,1,2,3,5,6,7) AND UPPER(PCTEXT) LIKE UPPER('%'test%')

Similarly, on the Oracle platform:

File: E:\pt85510b-retail\peopletools\src\pside\PSFindInDlg.cppSQL error. Stmt #: 4669 Error Position: 165 Return: 907 - ORA-00907: missing right parenthesis
Failed SQL stmt: SELECT COUNT(*) FROM PSPCMTXT P ,PSRECDEFN D WHERE P.OBJECTID1 = :1 AND P.OBJECTVALUE1 = D.RECNAME AND D.RECTYPE IN ( 0,1,2,3,5,6,7) AND UPPER(PCTEXT) LIKE UPPER('%'test%')

 

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