Siebel ODQ (IIR 9.5.3 HF2) Fuzzy Query Only Returns Exact Matches In UI
Last updated on MARCH 09, 2016
Applies to:Siebel Data Quality - Version 15.5 [IP2015] and later
Information in this document applies to any platform.
On : 15.5 [IP2015] version, SQL statement generated to show fuzzy search results includes the values specified by the user which leads to displaying only exact matches:
(NLS_UPPER(T44.LAST_NAME,'NLS_SORT=GENERIC_BASELETTER') = NLS_UPPER(:6,'NLS_SORT=GENERIC_BASELETTER') AND NLS_UPPER(T44.FST_NAME,'NLS_SORT=GENERIC_BASELETTER') = NLS_UPPER(:7,'NLS_SORT=GENERIC_BASELETTER')
AND T11.ROW_ID IN (:8,:9))
where the bindings for ":6" and ":7" are last and first name as specified by the user, ":8" and ":9" are the match candidates returned by IIR.
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