My Oracle Support Banner

E-BI/XMLP: Searching the Apostrophe Character Causes Multiple Search Pages to Error out (Doc ID 2227190.1)

Last updated on FEBRUARY 03, 2019

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.