E-BI/XMLP: Searching the Apostrophe Character Causes Multiple Search Pages to Error out
(Doc ID 2227190.1)
Last updated on FEBRUARY 05, 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