Siebel ODQ (IIR 9.5.3 HF2) Fuzzy Query Only Returns Exact Matches In UI (Doc ID 2112875.1)

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.

Symptoms

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.

 

Cause

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