E-AD: 'Find In' Feature In Application Designer Gives SQL Error When Searching for Single Quote ' Characters
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.
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%')
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