Enterprise Capture Database Lookup Fails to Return Records in some Cases "%FE", "%CE", "O'D%", "%O%'%D"
(Doc ID 2201469.1)
Last updated on NOVEMBER 22, 2023
Applies to:Oracle WebCenter Enterprise Capture - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11g]
Information in this document applies to any platform.
When performing a database lookup in the Enterprise Capture client version 22.214.171.124.0, there are certain search strings that will not return any records even though the same search in SQL Developer on that column will return records. Some examples of the behavior are searching on the column that contains a record with value "FEED". Performing the searches below in Enterprise Capture:
"FE%" returns the value.
"%F%" returns the value
"%F" - returns the value
"þ%" - fails to return any values
"þ" - fails to return any values
In another case when attempting to search for a record with value "O'Driscoll" where the apostrophe character is included in the search string fails:
"O%" - returns the value
"%O%’" - fails to return any values
"%O'D%" - fails to return any values
"%O%'%D" - fails to return any values
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