Enterprise Capture Database Lookup Fails to Return Records in some Cases "%FE", "%CE", "O'D%", "%O%'%D"
Last updated on NOVEMBER 18, 2016
Applies to:Oracle WebCenter Enterprise Capture - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11g to 12c]
Information in this document applies to any platform.
When performing a database lookup in the Enterprise Capture client version 126.96.36.199.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
"%FE%" - fails to return any values
"%FE" - 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
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