E-BI/XMLP: Searching the Apostrophe Character Causes Multiple Search Pages to Error out
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