E-BI/XMLP: Searching the Apostrophe Character Causes Multiple Search Pages to Error out

(Doc ID 2227190.1)

Last updated on DECEMBER 18, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.


When attempting to use the apostrophe character in the search box from BI Publisher > Data Source page, the following error occurs:

"SQL Error in Exec (2,280) PSXPDSSRCH_WRK.FUNCLIB.FieldFormula"

The issue can be reproduced at will with the following steps:
1. Log in to PIA
2. Navigate to Reporting Tools > BI Publisher > Data
3. In the search box, type : R'CP'
4. Notice the error

Note: The same problem occurs in BI Publisher Template Translation search page, Query Report Viewer search page and Connected Query Viewer search page.


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