My Oracle Support Banner

Data Quality Management (DQM) Issue: Duplicate Prevention Not Working With Custom Attribute (Doc ID 1348468.1)

Last updated on NOVEMBER 07, 2019

Applies to:

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


In R12.0.6, duplicate prevention with DQM match rule using a custom attribute, e.g. 'Tax Registration Number' is not working.  Duplicate 'Tax Registration Number' can still be assigned to different customers.

Note: This issue was reported for a match rule using the custom attribute Tax Registration Number, hence the illustration below on how to reproduce the issue uses this attribute. Take note however, that the same issue/behavior exists when using other custom attributes.

Steps to reproduce:

1) Create a DQM match rule using a custom attribute = 'Tax Registration Number'
Responsibility: Trading Community Manager
Navigation: Administration > Match Rule

-Click on Create Single Match Rule
  Search Operator = Match All
  Match Threshold = 100
  Attribute Name = Tax Registration Num (TAX_REFERENCE), Usage = Acquisition
  and Scoring, Score = 100
  Transformation = EXACT SPECIAL, Weight = 100, Adjust Score = 100, Use in Acquisition = Yes, Use in Scoring = Yes
-Click on 'Save and Compile' button.

2) Set the profile options:
Responsibility: System Administrator
Navigation: Profile > System

-HZ: Match Rule for Organization Duplicate Prevention = XXXHZ_ORG_DUPLICATE_ONLINE
-HZ: Match Rule for Person Duplicate Prevention = XXXHZ_ORG_DUPLICATE_ONLINE

3) Enter Duplicate Tax Numbers for different customer records

Responsibility: Customers Online Superuser
Navigation: Customers > Organizations subtab
-Query for a customer.
-Click on Update icon
-Under Tax and Financial Information region, enter the Tax Registration Number = 987654321.
-Save. Receive confirmation saying "The value has been updated."
-Query for another customer.
-Enter the same Tax Registration Number = 987654321
-Save. Receive confirmation saying "The value has been updated."




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.