DeDuplication BS Value Match Method Threshold Argument When Called From Script Defaults To DQ Third-party Setting In EDQ (Doc ID 2027442.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Symptoms

On : 8.2.2.4.9 [IP2013] version, Client Functionality

ACTUAL BEHAVIOR
---------------
DeDuplication BS Value Match method threshold argument defaults to DQ third-party setting in EDQ

The Value Match method of the Deduplication business service can be used to find potential matching records in the Siebel application.

This Business Service can called from Siebel eScript.

The threshold can be specified to override the corresponding setting information obtained by the service from the administration screens, vendor properties, and so on.

Some discrepancy was noticed when the Value Match Method for the DeDuplication BS is invoked through script.

Changes

Following set up was done to test this behavior in GCS environment -

Case 1

Administration Data Quality > Data Quality Setting> Match Threshold - 60
Administration Data Quality > Third Party Administration > Vendor - EDQ , Vendor Parameter - "session", "matchthreshold", "50"
Value passed in Script - Match Threshold - 50

Created New Record with Last Name – KUMAR, First Name - RAJESH

Deduplication business service invoked from from UI - 1 records returned - with Match scores - 65
Deduplication business service invoked through script simulation - 1 record returned - with Match scores – 65

This was an Expected outcome

Case 2

Administration Data Quality > Data Quality Setting> Match Threshold - 50
Administration Data Quality > Third Party Administration > Vendor - EDQ , Vendor Parameter - "session", "matchthreshold", "50"
Value passed in Script - Match Threshold - 64

Created New Record with Last Name - INFA, First Name - TSE

Deduplication business service invoked from from UI - 2 records returned - with Match scores - 63 and 65
Deduplication business service invoked through script simulation - 1 records returned - with Match scores - 65

Once again this was an expected outcome

Case 3

Administration Data Quality > Data Quality Setting> Match Threshold - 60
Administration Data Quality > Third Party Administration > Vendor - EDQ , Vendor Parameter - "session", "matchthreshold", "90"
Value passed in Script - Match Threshold - 50

Created New Record with Last Name – KUMAR, First Name - RAJESH

Deduplication business service invoked from from UI - 0 records returned
Deduplication business service invoked through script simulation - 0 records returned

  This was  unexpected

The script should return 1 record as the value 50 passed in script must overwrite the value 90 in the Third Party Admin - EDQ - Vendor Parameter - "session", "matchthreshold", "90".

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.