My Oracle Support Banner

Prevent Duplicate Entry With DQM Match Rule For Email Attribute Not Working For Organization (Doc ID 1519241.1)

Last updated on JUNE 25, 2018

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.


Release 12.1.3

We have created a DQM matching rule for organizations with attribute Email (

We expected to receive the warning message that duplicate email exists when user is entering an email address with the same for another organization.

This does not work and end-user can create duplicates without any warning.

But DQM does warn of duplicate when using match rule for  person party type.
The  application is generating  a warning when entering a duplicate Email.

Example data

The data is seen in

604401 EMAIL A


Also seen in the hz_staged_contact_points table under tx columns

select party_id, contact_point_id, contact_point_type, tx5, tx6, tx12 from hz_staged_contact_points where contact_point_id = 604401
585190 604401 EMAIL  INF ABST ES  A

Does not kick in when using duplicate exact email address

To reproduce issue
Create a single match rule with just the email address attribute
with match threshold of 100 and exact.
Works for only creation of a party type person - just not an




Create a new match rule for duplicate prevention on email field.


Match Rule Name - EMAIL_DUP_FOR_ORG
 Used only  Party Name and e-mail address attributes.
 Name (PARTY_NAME) Party Acquisition and Scoring   30
 E-Mail Address (EMAIL_ADDRESS) Contact Point Acquisition and Scoring 30
 Match threshold  is low 30 set
 Assigned EMAIL_DUP_FOR_ORG match rule to profile HZ: Match Rule for
 Organization Duplicate Prevention at the Responsibility level

Create a Organization that has a duplicate email address already existing in the TCA Registry

A warning is not generated that email already exists.



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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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