E-AD: 'Find In' Feature In Application Designer Gives SQL Error When Searching for Single Quote ' Characters
(Doc ID 2251256.1)
Last updated on FEBRUARY 01, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4]
Information in this document applies to any platform.
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.
Similarly, on the Oracle platform:
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%')
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