R12 - Prevent Duplicate Entries DQM Match Rule Is Not Working For TAXPAYER_ID Attribute

(Doc ID 1127671.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version: 12.1.1 and later   [Release: 12 and later ]
Information in this document applies to any platform.


After creating a custom match rule on Taxpayer ID and setting the profile HZ: Match Rule for Person Duplicate Prevention, the system is not working as desired.  For example:

-There are existing persons with Taxpayer ID '123456789'.  
-When users create a new person with Taxpayer ID '123456789', the system saves the person without prompting for the duplicates.

The match rule is working for Organization but not for Person.

Steps to reproduce:

1. Create a match rule that uses Attribute = Taxpayer ID (JGZZ_FISCAL_CODE)
-Customers Online Data Librarian responsibility, N: Administration : DQM
-Click on Setup : Match Rules.
-Select Go on Create Single Match Rule
-Enter Rule Name = XXSR_TAXPAYER_ID
-Description = XXSRI_TAXPAYER_ID
-Search Operator = Match Any. Click on Next button
-Under Party Entity tab, select Attribute = Taxpayer ID (JGZZ_FISCAL_CODE).
-Click on Next button.
-Enter Acquisition and Scoring on Usage column and Order = 1
-Click on Next button.
-Enter 100% on Match Threshold and Override Threshold.
-Under Transformations for attribute name Taxpayer ID, enter 100%.
-Add a transformation rule of EXACT SPECIAL for attribute Taxpayer ID with Weight = 100%. -Check the box for 'Use in Acquisition' and 'Use in Scoring'.

2. Change the profile option HZ: Match Rule for Person Duplicate Prevention on the Site level to XXSRI_TAXPAYER_ID.

3. Bounce the server.

4. Personalize 'Create Person' page to show the field 'Taxpayer ID'
-Receivables Manager, N: Customers : Customers
-Select Type = Person
-Click on Create button
-Click on the link 'Personalize Person Information'
-Click on the Pencil icon for 'Message Text Input: Taxpayer ID'
-Set Render = True at the Responsibility Level
-Click on Apply.

5. Test the match rule
-Receivables Manager, N: Customers : Customers
-Click the Create button to enter a new customer
-Enter Customer Name and a Taxpayer ID that already exists.
-Click Apply. The system saved the new customer without prompting for the duplicates.


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