首页 > Linux操作系统 > Linux操作系统 > Duplicate Customer Name Prevention Is Not Working

Duplicate Customer Name Prevention Is Not Working

原创 Linux操作系统 作者:leoa_z 时间:2012-02-17 15:52:30 0 删除 编辑
Duplicate Customer Name Prevention Is Not Working [ID 1302995.1]

  修改时间 10-MAR-2011     类型 HOWTO     状态 PUBLISHED  

In this Document

Applies to:

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


In R12.1.2, AR allows us to enter customers with exact same name.  Users just need to prevent multiple customers with the EXACT name.

How can this be achieved?


To prevent the multiple customer with exact same name to be created, please perform. the following:

1.) Turn on DQM (Data Quality Management) by setting the profile option HZ: Enable DQM Party Search to Yes.

2.) Create a custom match rule as follows:

-Trading Community Manager, N: Administration > DQM > Setup > Match Rules

-Query for the seeded match rule: HZ_ORG_ADV_SEARCH_RULE

-Click on Copy icon

-Define a new match rule with the following transformations changed for Attribute = Name (PARTY_NAME) under Party Entity tab:

a) Transformation = EXACT SPECIAL + WRNAMES
     Weight = 100
     Check the checkbox 'Use in Acquisition' and 'Use in Scoring' 

b) Transformation = EXACT STRING 
     Weight = 100
     Check the checkbox 'Use in Scoring'

-Click Save and Compile. Ensure the match rule compiles successfully.

2.) Set the following profile options:

HZ: Duplicate Allowed = No
HZ: Enable Duplicate Prevention at Party Creation = Person and Organization
HZ: Match Rule for Organization Duplicate Prevention =
HZ: Match Rule for Organization Simple Search =

3.) Try to create a duplicate cutomer

-Receivables Manager, N: Customers : Customers
-Enter a customer that already exists
-Click Apply. The following warning now appears:

Warning: Possible Duplicate Organizations
Option 1: Create New Organization
Option 2: Use Existing Organization -> a list of customers with exact same name will be listed

You can now choose either option: create new organization or use the existing organization. 

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量