My Oracle Support Banner

UCM Matching With OEDQ Doesn't Use Address Information When Inserting a Record (Doc ID 1962707.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel Financial Services CRM - Version [IP2013] and later
Information in this document applies to any platform.


When using Siebel UCM version with QF2190 or with OEDQ 11 and try to insert a new record in Siebel the address information is not considered when it generates the matching keys.

This can cause existing records to not be found and also bad keys are getting generated at S_DQ_ORG_KEY where none of them contains address info.

Steps to reproduce this issue:

1 - Create a new account and a new address for the account using the Siebel UI > Accounts List View > new record: e.g.

Name: Siebel

Site: CA

Do not save or step off the the record yet, go to the bottom applet > open the address mvg > left side > New button > enter the new address information

2 - Then, step off the Account record to save it, it will get cleansed at this point.

3 - Check the keys at S_DQ_ORG_KEY and it will be observed about 4 records in this table (this may depend on the clusterlevel being used) but none of them contains address info.


If main0.log from OEDQ connector is analyzed it can be observed that during insert no address is considered and a line similar to this one can be noticed:

FINEST: 30-Oct-2014 13:52:46: get dedup keys in=<DriverRecord website= entityid=[ID] languages=ENU subname=CA phone= name=SIEBEL taxnumber= vatnumber=>

If an update is issued for the same record the address information can be observed:

FINEST: 30-Oct-2014 16:30:49: dedup in[1]=<DriverRecord website= entityid=[ID] languages=ENU subname=CA phone= name=Siebel taxnumber= vatnumber= <x <x city=London country=United Kingdom address1=80 Doverst Mayfair address2=80 Doverst Mayfair>>>




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

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