TCA Party Merge

Oracle Trading Community Architecture
Party Merge User Guide Release 11i
June 2003
Oracle Trading Community Architecture Party Merge User Guide, Release 11i Copyright 2002, 2003, Oracle Corporation. All rights reserved. Author: Charlie Ahern, Essan Ni Charity Kocher, Kavi Nandakumar, Cuby Ng, Ajay Singh
Contributor:
The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual and industrial property laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other purpose. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation. If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on behalf of the U.S. Government, the following notice is applicable: Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs. The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party. Oracle is a registered trademark, and Oracle8i, Oracle9i, OracleMetaLink, Oracle Store, PL/SQL, Pro*C, SQL*Net, and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Other names may be trademarks of their respective owners.
Contents
Send Us Your Comments .................................................................................................................... v Preface........................................................................................................................................................... vii
How To Use This Guide ...................................................................................................................... viii Documentation Accessibility ................................................................................................. ix Other Information Sources .................................................................................................................... x Online Documentation ............................................................................................................ x Related Guides .......................................................................................................................... x Guides Related to All Products ............................................................................................. xi Guides Related to This Product ............................................................................................. xi Installation and System Administration ........................................................................................... xiii Other Implementation Documentation .............................................................................. xiv Training and Support.......................................................................................................................... xvi Do Not Use Database Tools to Modify Oracle Applications Data .............................................. xvii About Oracle ....................................................................................................................................... xvii Your Feedback..................................................................................................................................... xviii
Party Merge
Party Merge Overview ....................................................................................................................... Party Merge Details...................................................................................................................... Merging Parties or Party Sites ............................................................................................ Merging Individuals, Organizations, or Relationships .................................................. Merging Entities from Other Applications ....................................................................... Party Merge Example................................................................................................................... 1-2 1-4 1-4 1-4 1-4 1-5
iii
Before the Merge ................................................................................................................... During the Merge ................................................................................................................. After the Merge ..................................................................................................................... Impact on Source System References......................................................................................... Impact on D&B Data .................................................................................................................... Party Merge Process.......................................................................................................................... Prerequisites ........................................................................................................................ Creating Merge Batches ................................................................................................................... Merging Parties ................................................................................................................................. Merging Party Sites .................................................................................................................... Merging Party Relationships..................................................................................................... Merging Organization Contacts ............................................................................................... Viewing Profile Information ..................................................................................................... Merging Party Sites of a Party ........................................................................................................ Processing the Merge Batch ............................................................................................................ Reviewing the Party Merge Log..................................................................................................... Identifying Types of Errors ............................................................................................................. Data Errors ........................................................................................................................... Procedure Errors ................................................................................................................. Party and Customer Account Merge ............................................................................................. Party and Customer Account Merge Example....................................................................... Party Merge Followed by Customer Account Merge Example ................................... Customer Account Merge Followed by Party Merge Example ...................................
1-5 1-5 1-6 1-7 1-8 1-10 1-10 1-13 1-15 1-16 1-17 1-19 1-20 1-21 1-23 1-25 1-27 1-27 1-27 1-28 1-29 1-29 1-31
A Duplicate Checking
Duplicate Checking ............................................................................................................................ Contact Points and Preferences .......................................................................................... Customer Accounts and Related Information .................................................................. Customer Contact Points ..................................................................................................... Additional Party Information ............................................................................................. A-2 A-2 A-3 A-4 A-4
iv
Send Us Your Comments

Oracle Trading Community Architecture Party Merge User Guide, Release 11i Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this document. Your input is an important part of the information used for revision.

Did you find any errors? Is the information clearly presented? Do you need more information? If so, where? Are the examples correct? Do you need more examples? What features did you like most?
If you find any errors or have any other suggestions for improvement, please indicate the document title and part number, and the chapter, section, and page number (if available). You can send comments to us in the following ways:

Electronic mail: [email protected] FAX: (801) 659-7164 Attn: Oracle Applications Documentation Manager Postal service: Oracle Corporation Oracle Applications Documentation Manager 500 Oracle Parkway Redwood Shores, CA 94065 USA
If you would like a reply, please give your name, address, telephone number, and (optionally) electronic mail address. If you have problems with the software, please contact your local Oracle Support Services.
vi
Preface
Welcome to Release 11i of the Oracle Trading Community Architecture Party Merge User Guide. This guide assumes you have a working knowledge of the following:
The principles and customary practices of your business area. Oracle Trading Community Architecture Party Merge. If you have never used Oracle Trading Community Architecture Party Merge, Oracle suggests you attend one or more of the Oracle Applications training classes available through Oracle University.
The Oracle Applications graphical user interface.
See Other Information Sources for more information about Oracle Applications product information.
vii
How To Use This Guide

The Oracle Trading Community Architecture Party Merge User Guide contains the information you need to understand and use Oracle Trading Community Architecture Party Merge. This user guide includes:
Chapter 1 describes using Party Merge to merge duplicate parties and party sites. Appendix A describes duplicate checks for Party Merge to determine what information is merged or transferred.
viii
Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle Corporation is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.
Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle Corporation does not own or control. Oracle Corporation neither evaluates nor makes any representations regarding the accessibility of these Web sites.
ix
Other Information Sources

You can choose from many sources of information, including online documentation, training, and support services, to increase your knowledge and understanding of Oracle Trading Community Architecture Party Merge. If this guide refers you to other Oracle Applications documentation, use only the Release 11i versions of those guides.
Online Documentation
All Oracle Applications documentation is available online (HTML or PDF).
Online Help - Online help patches are available on MetaLink. 11i Features Matrix - This document lists new features available by patch and identifies any associated new documentation. The new features matrix document is available on MetaLink. Readme File - Refer to the readme file for patches that you have installed to learn about new documentation or documentation patches that you can download.
Related Guides
Oracle Trading Community Architecture Party Merge shares business and setup information with other Oracle Applications products. Therefore, you may want to refer to other guides when you set up and use Oracle Trading Community Architecture Party Merge. You can read the guides online by choosing Library from the expandable menu on your HTML help window, by reading from the Oracle Applications Document Library CD included in your media pack, or by using a Web browser with a URL that your system administrator provides. If you require printed guides, you can purchase them from the Oracle Store at http://oraclestore.oracle.com.
Guides Related to All Products

Oracle Applications Users Guide
This guide explains how to enter data, query, run reports, and navigate using the graphical user interface (GUI) available with this release of Oracle Trading Community Architecture Party Merge (and any other Oracle Applications products). This guide also includes information on setting user profiles, as well as running and reviewing reports and concurrent processes.
Guides Related to This Product

Oracle Trading Community Architecture Data Quality Management User Guide
Use this user guide to learn how to set up Data Quality Management for powerful search, match, and duplicate identification functionality that Oracle applications can implement and leverage. Batch duplicate identification provides sets of potential duplicates that you can merge in Party Merge.
Oracle Trading Community Architecture Administration User Guide

Use this user guide to learn how to set up and administer various TCA features, including Data Quality Management and the Merge Dictionary.
Oracle Receivables User Guide

Use this user guide to learn about Customer Account Merge, which lets you merge customer accounts. You can use Customer Account Merge along with Party Merge to maintain clean and accurate data in the TCA Registry.
Oracle Trading Community Architecture Third Party Data Integration User Guide
User this user guide to learn how to manage and acquire third party information in the TCA Registry. The user guide describes acquiring third party data from D&B.
Oracle Trading Community Architecture Relationship Manager User Guide

User this user guide to learn how to view and manage relationships among existing parties in the TCA Registry. Relationships describe the roles that parties play among one another in the trading community.
xi
Oracle Trading Community Architecture API User Notes

Use these technical user notes to learn how to access the public TCA application programming interfaces (APIs). For each API, these user notes provide a description of the API, the PL/SQL procedure, and the Java method, as well as a table of the parameter descriptions and validations.
Oracle Customers Online Concepts and Procedures

Use this user guide to learn how to use Oracle Customers Online (OCO) to solve the 3 C's of customer data management: 1) consolidation, 2) cleanliness, and 3) completeness. From Oracle Customers Online, you can access Relationship Manager as well as view and manage relationships with other OCO functionality.
xii
Installation and System Administration

Oracle Applications Concepts
This guide provides an introduction to the concepts, features, technology stack, architecture, and terminology for Oracle Applications Release 11i. It provides a useful first book to read before an installation of Oracle Applications. This guide also introduces the concepts behind Applications-wide features such as Business Intelligence (BIS), languages and character sets, and Self-Service Web Applications.
Installing Oracle Applications

This guide provides instructions for managing the installation of Oracle Applications products. In Release 11i, much of the installation process is handled using Oracle Rapid Install, which minimizes the time to install Oracle Applications, the Oracle8 technology stack, and the Oracle8i Server technology stack by automating many of the required steps. This guide contains instructions for using Oracle Rapid Install and lists the tasks you need to perform to finish your installation. You should use this guide in conjunction with individual product user guides and implementation guides.
Oracle Applications Implementation Wizard User Guide

If you are implementing more than one Oracle product, you can use the Oracle Applications Implementation Wizard to coordinate your setup activities. This guide describes how to use the wizard.
Upgrading Oracle Applications

Refer to this guide if you are upgrading your Oracle Applications Release 10.7 or Release 11.0 products to Release 11i. This guide describes the upgrade process and lists database and product-specific upgrade tasks. You must be either at Release 10.7 (NCA, SmartClient, or character mode) or Release 11.0, to upgrade to Release 11i. You cannot upgrade to Release 11i directly from releases prior to 10.7.
Maintaining Oracle Applications

Use this guide to help you run the various AD utilities, such as AutoUpgrade, AutoPatch, AD Administration, AD Controller, AD Relink, License Manager, and others. It contains how-to steps, screenshots, and other information that you need to run the AD utilities. This guide also provides information on maintaining the Oracle applications file system and database.
xiii
Oracle Applications System Administrators Guide

This guide provides planning and reference information for the Oracle Applications System Administrator. It contains information on how to define security, customize menus and online help, and manage concurrent processing.
Oracle Alert Users Guide

This guide explains how to define periodic and event alerts to monitor the status of your Oracle Applications data.
Oracle Applications Developers Guide

This guide contains the coding standards followed by the Oracle Applications development staff. It describes the Oracle Application Object Library components needed to implement the Oracle Applications user interface described in the Oracle Applications User Interface Standards for Forms-Based Products. It also provides information to help you build your custom Oracle Forms Developer 6i forms so that they integrate with Oracle Applications.
Oracle Applications User Interface Standards for Forms-Based Products

This guide contains the user interface (UI) standards followed by the Oracle Applications development staff. It describes the UI for the Oracle Applications products and how to apply this UI to the design of an application built by using Oracle Forms.
Other Implementation Documentation

Oracle Applications Product Update Notes
Use this guide as a reference for upgrading an installation of Oracle Applications. It provides a history of the changes to individual Oracle Applications products between Release 11.0 and Release 11i. It includes new features, enhancements, and changes made to database objects, profile options, and seed data for this interval.
Oracle Workflow Guide

This guide explains how to define new workflow business processes as well as customize existing Oracle Applications-embedded workflow processes. You also use this guide to complete the setup steps necessary for any Oracle Applications product that includes workflow-enabled processes.
xiv
Oracle Applications Flexfields Guide

This guide provides flexfields planning, setup and reference information for the Oracle Trading Community Architecture Party Merge implementation team, as well as for users responsible for the ongoing maintenance of Oracle Applications product data. This guide also provides information on creating custom reports on flexfields data.
Oracle eTechnical Reference Manuals

Each eTechnical Reference Manual (eTRM) contains database diagrams and a detailed description of database tables, forms, reports, and programs for a specific Oracle Applications product. This information helps you convert data from your existing applications, integrate Oracle Applications data with non-Oracle applications, and write custom reports for Oracle Applications products. Oracle eTRM is available on Metalink
Oracle Applications Message Manual

This manual describes all Oracle Applications messages. This manual is available in HTML format on the documentation CD-ROM for Release 11i.
xv
Training and Support

Training
Oracle offers a complete set of training courses to help you and your staff master Oracle Trading Community Architecture Party Merge and reach full productivity quickly. These courses are organized into functional learning paths, so you take only those courses appropriate to your job or area of responsibility. You have a choice of educational environments. You can attend courses offered by Oracle University at any one of our many education centers, you can arrange for our trainers to teach at your facility, or you can use Oracle Learning Network (OLN), Oracle University's online education utility. In addition, Oracle training professionals can tailor standard courses or develop custom courses to meet your needs. For example, you may want to use your organization structure, terminology, and data as examples in a customized training session delivered at your own facility.
Support
From on-site support to central support, our team of experienced professionals provides the help and information you need to keep Oracle Trading Community Architecture Party Merge working for you. This team includes your technical representative, account manager, and Oracles large staff of consultants and support specialists with expertise in your business area, managing an Oracle8i server, and your hardware and software environment.
xvi
Do Not Use Database Tools to Modify Oracle Applications Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle Applications data unless otherwise instructed. Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data. Because Oracle Applications tables are interrelated, any change you make using Oracle Applications can update many tables at once. But when you modify Oracle Applications data using anything other than Oracle Applications, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle Applications. When you use Oracle Applications to modify your data, Oracle Applications automatically checks that your changes are valid. Oracle Applications also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.
About Oracle
Oracle Corporation develops and markets an integrated line of software products for database management, applications development, decision support, and office automation, as well as Oracle Applications, an integrated suite of more than 160 software modules for financial management, supply chain management, manufacturing, project systems, human resources and customer relationship management. Oracle products are available for mainframes, minicomputers, personal computers, network computers and personal digital assistants, allowing organizations to integrate different computers, different operating systems, different networks, and even different database management systems, into a single, unified computing and information resource. Oracle is the worlds leading supplier of software for information management, and the worlds second largest software company. Oracle offers its database, tools, and applications products, along with related consulting, education, and support services, in over 145 countries around the world.
xvii
Your Feedback
Thank you for using Oracle Trading Community Architecture Party Merge and this user guide. Oracle values your comments and feedback. In this guide is a readers comment form that you can use to explain what you like or dislike about Oracle Trading Community Architecture Party Merge or this user guide. Mail your comments to the following address or call us directly at (650) 506-7000. Oracle Applications Documentation Manager Oracle Corporation 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Or, send electronic mail to [email protected].
xviii
1
Party Merge
This chapter describes how to use Party Merge.
Party Merge 1-1
Party Merge Overview

Party Merge provides the capability to merge parties and their related entities in the TCA Registry. Parties are entities, of type Person or Organization, that can enter into business relationships. The TCA registry is the single source of party information for multiple Oracle E-Business Suite applications. Because the TCA Registry shares information across the E-Business Suite, you must maintain the quality of the data in the Registry. Duplicate data can reduce the efficiency and accuracy of your party processing and reports. You can use the Party Merge feature to eliminate duplicate data in the Registry. With Party Merge, you can:
Consolidate duplicate parties or party sites. For example, you can merge Vision Corp. into Vision Corporation.
Integrate an acquired party into the acquiring party. For example, you can merge Blue Company into White Corporation.
Merge duplicate party sites for a party.
In Party Merge, merge batches are sets of parties or party sites to merge, and the Party Merge process runs on one merge at a time. A merge batch determines the records involved in the merge as well as the general outcome of the merge. When you submit parties or party sites for merge, the Party Merge process runs as a concurrent request to complete the actual merge. You can review the log to check the results and any errors that might have occurred. To identify the duplicate parties to include in a merge batch, you can:
Use batch duplicate identification to automatically find batches of duplicates.

See also: Batch Duplicate Identification Overview, Oracle Trading Community Architecture Data Quality Management User Guide
Manually determine and enter the duplicates into merge batches in Party Merge.
1-2 Oracle Trading Community Architecture Party Merge User Guide
In addition to Party Merge, you can use the Customer Account Merge feature to merge transactions from a source customer account to a target customer account. After the merge-from account is merged into the merge-to account, you can either inactivate or delete the source customer account.
See also:
Merging Customers, Oracle Receivables User Guide
Party Merge 1-3
Party Merge Details
Party Merge Details

In Party Merge, the merging parties are referred to as the merge-from party and the merge-to party, or the source and the target respectively. After the merge-from party is merged into the merge-to party, you can delete the merge-from, or source, party. By default the merge-from party is set to a Merged status. The related child entities that get merged or transferred include party relationships, contact information, party profiles, customer accounts, and information obtained from third-party sources. For more information about what information is merged or transferred, see Duplicate Checking on page A-2.
Merging Parties or Party Sites

You can merge parties or party sites that belong to a party. You cannot merge party sites between parties, however, until you merge the parties that they belong to. Before the Party Merge process begins, you can choose to delete the merge-from party when the process ends. If you merge party sites for the same party, you cannot choose to delete the merge-from party because the merge-from and merge-to parties are the same party. Deleting a party changes its status to Deleted. You cannot retrieve a deleted party in any search or transaction window unless the application is specifically designed to include deleted parties in any query results.
Merging Individuals, Organizations, or Relationships

You can merge Person, Organization, or Relationship party types. You can, however, only merge parties with the same party type. This implies that an organization can only be merged with another organization, a person with a person, and so on.
Merging Entities from Other Applications

You must process and merge or appropriately transfer other Oracle Applications information of the duplicate party, such as transactions and attributes, into the merge-to party. Before using the Party Merge feature, you must register all applications and entities that interact with Oracle Trading Community Architecture to ensure that all transaction and attributes are merged when the party is merged.
See also: Merge Dictionary, Oracle Trading Community Architecture Administration User Guide
Party Merge Example

This example of a party merge shows both the before and after conditions. ABC Company has implemented the Oracle Applications E-Business Suite. While checking the quality of its data, ABC Company determines that duplicate records exist for a party, Vision Corporation. Data for this party were entered into the database under the names Vision Corp. and Vision Inc. Using Party Merge, ABC Company plans to merge the two Vision parties.
Before the Merge

This table shows the from and to parties and their party sites.
From Party Name Vision Corp. From Party Site 500 Vision Parkway Site Use

To Party Name Vision Inc.
To Party Site 100 Vision Parkway
Site Use Bill-to
Bill-to Ship-to Marketing Bill-to Ship-to
600 Vision Parkway
600 Vision Parkway
Ship-to
The 600 Vision Parkway party site exists for both parties and is considered to be duplicated.
During the Merge

The party site 500 Vision Parkway is transferred to Vision Inc. The details of 500 Vision Parkway, for example the bill-to, ship-to, and marketing party site uses stay with the party site. The party site 600 Vision Parkway is merged with 600 Vision Parkway on Vision Inc. The bill-to site use is transferred because it does not exist for Vision Inc. The ship-to site use is merged because it already exists for Vision Inc.
Party Merge 1-5
Party Merge Example
After the Merge

Vision Corp.
Vision Corp. is set to a status of Merged. The party site 600 Vision Parkway is set to a status of Merged. The ship-to party site use for 600 Vision Parkway is set to a status of Merged.
Vision Inc.
Vision Inc. has three party sites:
100 Vision Parkway with a bill-to site use. 500 Vision Parkway with a bill-to, ship-to, and marketing site use. 600 Vision Parkway with a bill-to and ship-to site use.
Impact on Source System References

A party can have mappings to the source systems that the record originated from. A source system reference is the ID of that record in the original system. For example, the Oracle party has the ID 12345 in the Vision source system. When this Oracle record is imported from Vision into the TCA Registry, 12345 becomes the source system reference.
See also: Source Systems Management Overview, Oracle Trading Community Architecture Administration User Guide
When you merge two parties with source system references, the references of the merge-from party are transferred to the merge-to party. For example, this table shows source system mapping records for the Oracle 1 and Oracle 2 parties.
Party Oracle 1 Oracle 2 Source System Name Vision Vision Source System Reference 10001 10002 Status Active Active
This table shows the result of Oracle 1 merging into Oracle 2. The Oracle 1 mapping record is inactivated, and a new mapping record is created for Oracle 2 and source system reference 10001.
Party Oracle 1 Oracle 2 Oracle 2 Source System Name Vision Vision Vision Source System Reference 10001 10001 10002 Status Inactive Active Active
Party Merge 1-7
Impact on D&B Data
Impact on D&B Data

Oracle Trading Community Architecture lets you purchase data from D&Bs global business databases. Information purchased from D&B is stored in the party tables at the party level and must be also merged with other party information.
See also:
Introduction to D&B, Oracle Trading Community Architecture Third Party Data Integration User Guide
You must resolve and merge D&B data for the merge-from and merge-to parties. When you merge parties with D&B data, retain as much of the D&B data about the parties as possible. When you merge two parties with D&B data, you might encounter these situations:
DUNS Numbers Are Different

If the DUNS Numbers for the merge-from and merge-to parties are not the same number, the data for the merge-to party is retained. The D&B data for the merge-from party is set to the Merged status.
DUNS Numbers Are the Same

If the DUNS Numbers for the merge-from and merge-to parties are the same number, the latest D&B data, whether for the merge-from or merge-to party, is retained. If the latest D&B data is stored for the merge-from party, that data overwrites the D&B data stored for the merge-to party.
No D&B Data Exists for the Merge-To Party

If D&B data exists for the merge-from party but not the merge-to party, the D&B data for the merge-from party transfers to the merge-to party as a result of the merge process.
Merge-From Party is a Branch of Merge-To Party

If the merge-to party is the headquarters for the merge-from party, which is a branch, and the merge-to party contains the D&B data, this data is retained. The status of the merge-from party is set to Merged.
Merge-From Party is the Headquarters of Merge-to Party

If the merge-from party is the headquarters and the merge-to party is its branch, the D&B data for the merge-from party is copied to the merge-to party. The merge-to party becomes the headquarters. All branches associated with the merge-from party now belong to the merge-to party.
Party Merge 1-9
Party Merge Process
Party Merge Process

The Party Merge process involves four procedures to resolve duplicate parties and party sites in the TCA Registry:
1. 2. 3. 4.
Creating the merge batch, on page 1-13. Processing the merge batch, on page 1-23. Reviewing the Party Merge log, on page 1-25. Identifying types of errors, on page 1-27.
Prerequisites
Before you use Party Merge, you must set up the Merge Dictionary to determine the entities and procedures that must be processed to merge party entities. You can set up the Merge Dictionary for all Oracle Applications that you use to interact with parties. With the Merge Dictionary, you determine the sequence of entities to merge, as well as view, update, and add seeded or custom entities. You add entities as a child of another entity. The parent entity is merged before the child, and the foreign key of the child points to the parent. You can customize the Merge Dictionary by:
Including your own custom entities as part of the merge process that affects the standard TCA entities, so that custom entities can be merged using standard merge rules or custom rules. Using a different implementation of the merge process for the standard TCA entities, so that standard entities can be merged using custom rules. You can override the predefined procedures for merging TCA entities with the custom procedures. You must develop the code to customize the merge procedures used by your custom applications and entities. Your custom merge procedure should: Perform any required validations before you run the merge process. Meet the processing requirements of your range of business activities.
See also: Merge Dictionary Overview, Oracle Trading Community Architecture Administration User Guide
Party Merge Process
For example, if your company enters into a service contract with one of the parties in your Registry, you would use Oracle Receivables to send invoices and statements to that party and Oracle Service to administer that service contract. If that party is acquired by another party, is identified as a duplicate of another party, or has sites that must be consolidated, you must merge those parties or party sites. This party merge affects customer accounts and attributes of the parties in Oracle Receivables, Oracle Service, and other Oracle Applications.
Prerequisites
Before you add any Oracle application to the Merge Dictionary, you must:
Identify any entities that have foreign keys in the TCA Registry. Create merge procedures by identifying the foreign keys for those entities.
To maintain the Merge Dictionary:

1. 2. 3.
Navigate to the Merge Dictionary window. Enter the name of the Oracle application affected by the merge process in the Application field. In the Entity field, enter the name of the table that has a foreign key to the HZ_ PARTIES table or a related table such as HZ_PARTY_SITES or HZ_CONTACT_ POINTS. In the Parent Entity field, enter the name of the table that the foreign key of the table in the Entity field refers to. The Procedure Type field defaults to PL/SQL.
4.
5.
Check the Merge Records in Bulk check box if you want to call the merge procedure once for all records in the table that references the merged party. Otherwise, the merge procedure is called once for every record.
Note:
If you check the Merge Records in Bulk check box, you cannot enter child entities for this table.
6.
In the Description Column(s) field, enter the name of the columns used to generate a description for the record, for example, PARTY_NAME for the HZ_ PARTIES table. You can alternatively enter a complex concatenation or decode expression. The information in the Description Column field is used in reports and logs.
Party Merge 1-11
Party Merge Process
7. 8. 9.
In the Additional Query Clause field, enter a SQL clause that is used to specify additional filtering conditions for joining the table to the related parent entity. In the Primary Key field, enter the name of the primary key column for the entity. In the Foreign Key field, enter the name of the foreign key column which links the entity to its parent entity. must conform to the standard merge procedure signature.
10. In the Procedure Name field, enter the name of the merge procedure, which 11. In the Child Entities region, for each child entity, enter the foreign key that
relates the child to the parent entity in the Foreign Key field. If the relationship between the parent and child entities involve more than one foreign key or is complex, you can enter an additional join condition in the merge procedure. For example, the HZ_CONTACT_POINTS table can be associated with either a party or party sites based on the value of the owner_table_name. To associate HZ_ CONTACT_POINTS with:
The HZ_PARTIES table Enter the join condition as hz_contact_points.owner_table_name = HZ_ PARTIES. Define the foreign key as owner_table_id.
The HZ_PARTY_SITE table Enter the join condition as hz_contact_points.owner_table_name = HZ_ PARTY_SITE. Define the foreign key as owner_table_id.
Creating Merge Batches

Use the Merge Batch window to set up a merge batch for the parties or party sites that you are merging. See:
Merging Parties on page 1-15. Merging the Party Sites of a Party on page 1-21.
You can only merge parties of the same party type. You can merge or transfer party sites, organization contacts, party relationships, and profiles related to a party. All other entities related to a party are either always merged or always transferred based on the merge procedures defined for that entity. When you select a party as the merge-from or merge-to party in a batch, the records for that party are locked and cannot be selected as a merge candidate for this or any other batch until after this batch is submitted and processed.
Party Merge 1-13
Note:
For your merge batch, you cannot include any party that is already part of a de-duplication merge request. Merge Requests Overview, Oracle Customers Online Concepts and Procedures
See also:
Aside from manually creating merge batches in the Merge Batch window, you can also use batch duplicate identification to automatically determine duplicate parties based on match rules. You create merge batches from the suggested duplicate candidates.
In the Merge Batch window, you can specify if you want to delete the merge-from party after the merge process completes. Otherwise, the merge-from party is set to a status of Merged. The results of the merge are saved only after the entire batch has completely processed. If one record results in error, none of the parties in the batch are merged. If you want to save the resulting party after each merge, you must create a separate batch for each pair of parties to merge. For an overview of the Party Merge process, see Party Merge Process on page 1-10.
Prerequisites
Before you create a merge batch, you must:
Define any custom entities and merge procedures. Decide if you want to delete all of the records of the merge-from party. You can also set up any merge procedure registered with the Merge Dictionary to prevent the deletion of records, if your companys business rules require that parties cannot be deleted. To prevent deletion, a merge procedure must call the HZ_PARTY_MERGE. veto_delete procedure. At the end of the merge process, if none of the merge procedures has vetoed the deletion of the merge-from parties, then those party records are deleted. For more information about the Merge Dictionary, see Prerequisites on page 1-10.
Merging Parties
Merging Parties
When you create a merge batch with parties to merge, you can also define the merge of entities from the merge-from and merge-to parties, including:
Party sites, on page 1-16. Party relationships, on page 1-17. Organization contacts, on page 1-19.
You can also view party profile attributes of the merge-from and merge-to parties. See Viewing Profile Information on page 1-20. If you used batch duplicate identification to create the merge batch, all the details of the merge-from and merge-to parties are already determined and cannot be changed.
For an overview of creating merge batches, see Creating Merge Batches on page 1-13.
To create a merge batch for parties:

1. 2. 3. 4.
Navigate to the Merge Batch window. Enter a batch name that is unique and related to the parties that you are merging. Enter a reason for the merge, either a predefined reason, such as Merger or De-duplication Merge, or your own. Check Delete Merged Records to delete the merge-from party records after the batch merge completes. Do not check this box if you do not want to delete the merged records. These records are instead assigned a Merged status. In the Party Details region, enter pairs of parties that you want to merge, including the party type and merge reason for each pair. Save your work before moving on to the tabbed regions.
5. 6.
Party Merge 1-15
Merging Party Sites
Merging Party Sites

You can merge party sites either within a single party or between a pair of parties that you are merging. If you are merging US party sites, you can only merge addresses that reflect the same Sales Tax Structure. For example, if you use the State.County.City Sales Tax Location Flexfield Structure, you can only merge party sites that have the same state, county, and city. Oracle Applications calculates sales taxes in the United States based on the address components of the Sales Tax Structure that you define in the System Options window. Because sales tax rates can change, modifying these components can invalidate the tax calculated for transactions previously assigned to an address. To ensure that you do not violate US sales tax audit requirements, you must merge party sites with addresses of same Sales Tax Structure.
See also:
Setup Steps for US Sales Tax, Oracle Receivables Tax
Manual
To merge party sites:

1.
Navigate to the Party Sites tabbed region after you enter the basic merge batch information. See Merging Parties on page 1-15 or Merging Party Sites of a Party on page 1-21. Enter the from sites address and the appropriate merge operation, Merge or Transfer Party Merge. If you enter the Merge operation, you must enter an address for the merge-to party site.
2. 3.
Merging Parties
Merging Party Relationships

Party relationships are binary roles between two parties, such as a partnership. A party relationship can be a party itself, so that certain party relationships could themselves enter into relationships. For example, if Joe is your contact at Vision Corporation, you can record this as a relationship between the person Joe and the organization Vision Corporation. That relationship, Joe as a contact for Vision Corporation, is itself a party that can enter into its own relationships. This table shows details of this sample relationship.
Party ID 789 (Joe, contact for Vision Corp.) Subject ID 456 (Joe) Object ID Type of Relationship
123 (Vision Corp.) Contact Of
After reviewing your database, you might determine that Vision Corporation and Vision Inc., another party in your database, are duplicates that should be merged. After the merge process, the contact information would be changed as shown in this table.
Party ID 789 (Joe, contact for Vision Inc.) Subject ID 456 (Joe) Object ID 123 (Vision Inc.) Type of Relationship Contact Of
If the same party relationship exists for the merge-from and merge-to parties, the relationships are automatically selected to be merged and cannot be transferred. If parties of type Relationship represent both relationships, the relationship parties are automatically added to the batch. If you manually select two party relationships to be merged and relationship parties represent both relationships, you must first manually merge the relationship parties in another batch before running this batch.
Party Merge 1-17
Merging Party Relationships
To merge party relationships:

1. 2.
Navigate to the Party Relationships tabbed region after you enter the basic merge batch information. See Merging Parties on page 1-15. For each relationship to be transferred or merged for a party, enter that relationships subject, object, and type in the From Relationships region. For example, if a type of relationship exists called Subsidiary of and Vision Manufacturing is a subsidiary of Vision Corporation, then Vision Manufacturing would be the subsidiary of Vision Corporation. Vision Manufacturing would be the subject of the relationship and Vision Corporation would be the object of the relationship. Party relationships do not require a hierarchical relationship like a parent-child relationship. For example, party relationships defined as Partner of, Colleague of, Competitor of, and so on do not imply a hierarchical relationship, but you have to identify a subject and object of the relationship before you can merge relationships.
3.
Enter either Merge or Transfer for the operation. You can merge only if the same party relationship exists for the merge-from and merge-to parties.
4.
Enter a relationship for the merge-to party in the To Relationships region.
Merging Parties
Merging Organization Contacts

You can merge organization contacts between parties that you are merging. See Merging Parties on page 1-15. If the same organization contact exists for the merge-from and merge-to parties, that contact is automatically selected to be merged. You must add the relationship parties for these contacts to the batch before entering the organization contacts for merging.
To merge organization contacts:

1. 2.
Navigate to the Org Contacts tabbed region after you enter the basic merge batch information. See Merging Parties on page 1-15. In the From Org Contact region, for each organization contact for the merge-from party, enter that contacts name and title. You can enter the type, department, and party site to identify a group of organization contacts. Enter either Merge or Transfer for the operation. You can merge only if a similar organization contact exists for the merge-to party.
3.
4.
If you enter Merge as the operation, enter an organization contact for the merge-to party that the party in the From Org Contact region is to be merged into.
Party Merge 1-19
Viewing Profile Information
Viewing Profile Information

For the parties that you are setting up to be merged in a merge batch, you can view the merge-from and merge-to parties profile information. See Merging Parties on page 1-15. Party profile information differs depending on whether the parties to merge are organizations or people. You can see the taxpayer ID and tax registration number for both, but the date of birth for parties of type Person and the DUNS Number for parties of type Organization.
To view profile information for the merging parties:

Navigate to the Person Profiles or Org Profiles tabbed region after you enter the basic merge batch information. See Merging Parties on page 1-15. For either the person or the organization, you see the profile of the merge-from party that is to be merged with the profile of the merge-to party.
Merging Party Sites of a Party

Use the Merge Batch window to create merge batches for merging duplicate party sites within a single party. For each batch, you can include multiple parties to merge party sites for. After the merge process, all entities associated with the merge-from party site, including customer account sites, refer to the merge-to party site. To submit a merge for two sites of the same party, you cannot check Delete Merged Records. Checking that check box implies deleting both the merge-from and merge-to parties. If the merge-from address is the identifying address, you must confirm that the merge-to address should be used as the identifying address to continue with the merge. If you want to merge the identifying address of a customer account, you can use Customer Merge to merge the account sites that point to these party sites only after you merge the party sites.
See also:
For an overview of creating merge batches, see Creating Merge Batches on page 1-13.
To merge party sites for the same party:

1. 2. 3. 4. 5. 6.
Navigate to the Merge Batch window. Enter a batch name that is unique and related to the party for which you are merging the party sites. Enter a reason for the merge, either a predefined reason, such as Merger or De-duplication Merge, or your own. Make sure that Delete Merged Records is not checked. In the Party Details region, enter one or more from-parties for which you want to merge the party sites, including the party type. Check Site Merge. The To Party fields are automatically populated with information from the From Party fields. Alternatively, you can just enter the party name or party number of your from-party in the To Party fields.
7.
Enter the reason for merging these party sites.
Party Merge 1-21
8. 9.
Save your work. Enter all party sites to be merged in the Party Sites tabbed region. See Merging Party Sites on page 1-16. The other tabbed regions are disabled.
Processing the Merge Batch

After you create the merge batch to merge either different parties or party sites of the same party, you have three options to process your merge batch:
Preview your merge batch and the outcome of the merge process before submitting the Party Merge process. Submit the Party Merge process immediately after entering your merge details. Save your work and submit the Party Merge process at a later time.
After a merge batch is successfully processed, you cannot reverse the results. For an overview of the Party Merge process, see Party Merge Process on page 1-10.
To preview the merge batch results:

1. 2. 3.
Create the merge batch in the Merge Batch window. For more information, see Creating Merge Batches on page 1-13. Click Preview Batch. The Party Merge process runs and merges the appropriate parties and other entities, but does not save the merged records to the database. The request number is displayed in the Last Request ID field. In Standard Request Submission, find the Party Merge process and preview the expected effect of the merge process on the merging parties and their entities. See Reviewing the Party Merge Log on page 1-25.
See also:
4.
Viewing Request Output and Log Files, Oracle Applications User Guide
If you query for the merge batch at this point in the Merge Batch window, the Merge Done check boxes are not checked. Even if you checked the Delete Merged Records check box, no records are deleted because the merge process is submitted in the preview mode.
To submit the Party Merge process:

1.
Create the merge batch in the Merge Batch window. See Creating Merge Batches on page 1-13. Optionally save the merge batch and submit it later.
Party Merge 1-23
2.
Click Run Batch. The Party Merge process runs and merges the appropriate parties and other entities. The entire batch must be successfully processed before the merged records are saved to the database. The request number is displayed in the Last Request ID field.
3.
In Standard Request Submission, find the Party Merge process and view the results and status of the merge process. See Reviewing the Party Merge Log on page 1-25.
See also:
If you query for the merge batch at this point in the Merge Batch window, the Merge Done check box is checked. If you checked Delete Merged Records, the merge-from parties are set to the Deleted status.
Reviewing the Party Merge Log

You can use the log of the Party Merge process to review the parties and related entities affected by the process. This output file is automatically generated after you run the Party Merge process. The report body displays Merged or Deleted for each merge-from party to indicate the status of the merge-from party or party site. The report displays an error message if the Party Merge process fails. This table shows the report headings and the corresponding values.
Heading Request ID Log Message Value The request ID for your concurrent process. The sequence of processes that run to execute the merge batch, including:

Start time of the merge Batch ID Batch name Rule set name Merge process Entities merged or transferred
Execution status The possible execution status combinations are:
Merge batch successfully executed / Batch rollback complete - This status occurs after you click Preview Batch in the Merge Batch window and the Party Merge process successfully runs without saving any merged records. This status indicates that the merge procedures registered with the Merge Dictionary ran, the merge process completed, but the merged records were not committed to the database.
Merge batch successfully executed / Batch commit complete - This status occurs after you click Run Batch in the Merge Batch window and the Party Merge process successfully runs. This status indicates that the merge procedures registered with the Merge Dictionary ran, the merge process completed, and the merged records were saved to the database.
Merge batch failed / Batch rollback complete - This status indicates that the merge procedures registered with the Merge Dictionary did not run successfully, and no merged records were saved to the database. Along with this status information, the log provides details of the error and identifies the merge procedure that the error occurred in. See Identifying Types of Errors on page 3-33.
Party Merge 1-25
The log message displays the details of the entities that have been merged or transferred. The entities that are merged or transferred are based on the merge procedures that were registered with the Merge Dictionary. The entities include, but are not restricted to, parties, party sites, relationships, contacts, profiles, contact points, customer accounts, customer account sites, and so on.
See also:
Foreign Keys and Procedures for Party Entities, Oracle Trading Community Architecture Administration User Guide
In addition to these standard TCA entities, other Oracle Applications and legacy system entities can be registered with the Merge Dictionary. These entities are also merged during the Party Merge process. You can also view the details about these entities in the Party Merge Request log file. For more information about the Merge Dictionary, see Prerequisites on page 1-10. For an overview of the Party Merge process, see Party Merge Process on page 1-10.
See also:
Identifying Types of Errors
Identifying Types of Errors

The Party Merge process encounters two types of errors: data errors and procedure errors.
Data Errors
The Party Merge process might fail at the batch or party level if any record contains corrupt data. If the Party Merge process encounters corrupt data, the entire batch fails, and none of the parties are merged. Users should be able to correct most data errors.
Procedure Errors
The Party Merge process can fail if any procedures were not correctly coded, registered, and tested. The Party Merge log identifies the procedure that caused the Party Merge process to fail. Procedure errors must be corrected by an application developer or administrator who has access to the error log, Merge Dictionary, and PL/SQL procedures. See Reviewing the Party Merge Log on page 1-25 and Prerequisites on page 1-10.
Party Merge 1-27
Party and Customer Account Merge

Data Quality Management involves both the merging of parties and customers, or customer accounts. You can use the Customers Merge window and the Customer Merge program to merge customer accounts.
See also:
If you find duplicate parties, you should determine if duplicate customer accounts exist between the merge-from and merge-to parties. If you find duplicate customer accounts, duplicate parties might exist for these customer accounts. You should verify that duplicate parties exist and merge those duplicate parties.
When two customer accounts are merged and the corresponding parties are verified as duplicates, the parties can be merged. When two parties are merged and the corresponding customer accounts are verified as duplicates, the customer accounts can be merged.
Party and Customer Account Merge Example

ABC Company has implemented the Oracle Applications E-Business Suite. While checking the quality of its customer data, ABC Company determines that duplicate records exist for a party, Vision Corporation. Data for this party were entered into the database under the names of Vision Corp. and Vision Inc. Using Party Merge, ABC Company plans to merge the two Vision parties.
Before Party or Customer Account Merge

This table shows the from and to parties and their customer accounts and account party sites.
From Party From Acct Name Num Vision Corp. 765432 From Acct Party Site Site Use 500 Vision Parkway (ID: 1VISCORP) 600 Vision Parkway (ID: 2VISCORP)

To Party Name
To Acct Num
To Acct Party Site 100 Vision Parkway (ID: 1VISINC) 600 Vision Parkway (ID: 2VISINC)
Site Use Bill-to
Bill-to Ship-to Marketing Bill-to Ship-to
Vision Inc. 234567
Ship-to
The 600 Vision Parkway party sites exist for both Vision Corp. and Vision Inc. and are deemed to be duplicates.
Party Merge Followed by Customer Account Merge Example

Merging the Parties
The 500 Vision Parkway party site is transferred to Vision Inc. The details for 500 Vision Parkway, such as the bill-to, ship-to, and marketing party site uses stay with the party site. The 600 Vision Parkway party site from Vision Corp. is merged with 600 Vision Parkway for Vision Inc. The bill-to site use is transferred because it does not exist for Vision Inc. The ship-to is merged because it already exists for Vision Inc.
Party Merge 1-29
After Party Merge and Before Customer Account Merge

Vision Corp.
Vision Corp. is set to a status of Merged. The 600 Vision Parkway party site is set to a status of Merged. The ship-to party site use for 600 Vision Parkway is set to a status of Merged. Vision Inc. has two customer accounts with these account numbers: 765432 234567
Vision Inc.
Vision Inc. has three party sites: 100 Oracle Parkway with a bill-to site use. Customer account site ID: 1VISINC. 500 Oracle Parkway with a bill-to, ship-to, and marketing site use. Customer account site ID: 1VISCORP. 600 Oracle Parkway with a bill-to and ship-to site use. Customer account site ID: 2VISCORP. Customer account site ID: 2VISINC.
Merging the Customer Accounts

Customer account 765432 is merged with customer account 234567. Customer account site 2VISCORP is merged with customer account site 2VISINC.
After Customer Account Merge
Customer account 765432 is set to a status of Merged. Customer account site 2VISCORP is set to a status of Merged. The bill-to and ship-to site uses on customer account site 2VISCORP are set to a status of Merged. Vision Inc. has one customer account, 234567.
Vision Inc. has three party sites: 100 Oracle Parkway with a bill-to site use. Customer account site ID: 1VISINC. 500 Oracle Parkway with a bill-to, ship-to, and marketing site use. Customer account site ID: 1VISCORP. 600 Oracle Parkway with a bill-to and ship-to site use. Customer account site ID: 2VISINC.
Customer Account Merge Followed by Party Merge Example

Merging the Customer Accounts
Customer account 765432 is merged with customer account 234567. Customer account site 2VISCORP is merged with customer account site 2VISINC.
After Customer Account Merge and Before Party Merge
Customer account 765432 has the status of Merged. Customer account site 2VISCORP has the status of Merged. The bill-to and ship-to site uses for customer account site 2VISCORP have the status of Merged. Vision Corp. has the following party sites: 500 Vision Parkway, with three uses: bill-to, ship-to, and marketing. 600 Vision Parkway, with two uses: bill-to and ship-to.
Vision Corp. does not have any customer accounts or customer account sites belonging to it. Vision Inc. has one customer account, 234567. Vision Inc. has two party sites: 100 Vision Parkway, with one use: bill-to. Customer account site ID: 1VISINC. 600 Vision Parkway, with one use: ship-to. Customer account site ID: 2VISINC.
Party Merge 1-31
Merging the Parties

The 500 Vision Parkway party site is transferred to Vision Inc. The details of the party site uses for 500 Vision Pkwy, such as bill-to, ship-to and marketing stay with the party site. The 600 Vision Parkway party site is merged with 600 Vision Parkway to Vision Inc. The bill-to site use is transferred because it does not exist for Vision Inc. The ship-to is merged because it already exists for Vision Inc.
After Party Merge
Vision Inc. has one customer account, 234567. Vision Inc. has three party sites. 100 Oracle Parkway with a bill-to site use. Customer account site ID: 1VISINC. 500 Oracle Parkway with a bill-to, ship-to, and marketing site use. Customer account site ID: 1VISCORP. 600 Oracle Parkway with a bill-to and ship-to site use. Customer account site ID: 2VISINC.
A
Duplicate Checking
This appendix describes duplicate checks for Party Merge to determine what information is merged or transferred.
Duplicate Checking
A-1
Duplicate Checking
Duplicate Checking
In Party Merge, you can either merge or transfer the child entities that belong to the merge-from party. These entities can include party sites, contacts, relationships, and profile information. The merge procedures automatically handle the merge or transfer of other child entities. Below are some of the TCA entities and the rules that are applied to them to determine whether the entities should be merged or transferred. In general, if the Party Merge process determines that the entities are exact duplicates based on the concatenation of table columns, the merge-from record will be merged with the merge-to record. If the entities are not exact duplicates, the merge-from entity is transferred to the merge-to entity.
Contact Points and Preferences

Contact Points
You must transfer contact points unless they are exact duplicates. If the following columns in the HZ_CONTACT_POINTS table match, the contact points are exact duplicates. Only exact duplicates are merged.
CONTACT_POINT_TYPE STATUS EDI_TRANSACTION_HANDLING EDI_ID_NUMBER EDI_PAYMENT_METHOD EDI_PAYMENT_FORMAT EDI_REMITTANCE_METHOD EDI_REMITTANCE_INSTRUCTION EDI_TP_HEADER_ID EDI_ECE_TP_LOCATION_CODE EMAIL_FORMAT BEST_TIME_TO_CONTACT_START BEST_TIME_TO_CONTACT_END
A-2 Oracle Trading Community Architecture Party Merge User Guide
Duplicate Checking
PHONE_CALLING_CALENDAR DECLARED_BUSINESS_PHONE_FLAG PHONE_PREFERRED_ORDER TELEPHONE_TYPE TIME_ZONE PHONE_TOUCH_TONE_TYPE_FLAG PHONE_AREA_CODE PHONE_COUNTRY_CODE PHONE_NUMBER PHONE_EXTENSION PHONE_LINE_TYPE TELEX_NUMBER CONTENT_SOURCE_TYPE WEB_TYPE EMAIL_ADDRESS URL
Contact points can point to a party site. These contact points are transferred or merged the way that the contact points are at the party level.
Contact Preferences
Contact preferences are always merged.
Customer Accounts and Related Information

Customer Accounts
Customer accounts are transferred to the merge-to party. After the parties are merged, you can use the Customer Merge program to merge customer accounts. This is a separate process that requires a separate concurrent request.
See also:
Duplicate Checking
A-3
Duplicate Checking
Customer Account Sites
Customer account sites are related to party sites. How customer account sites are merged depends on how the party site is processed.
Party site merge - The customer account site must be modified to point to the existing merge-to party site. Party site transfer - The customer account site should point to the merge-from party site, which now points to the merge-to party.
Roles in a Customer Account

Each role in a customer account points to a party. A customer account role can be processed during the Party Merge process in either of these situations:
The role points to the merge-from party. In this case, the role must be modified to point to the merge-to party. The role points to an organization contact or other relatable party relationship. This relationship is being merged or transferred as the relationships subject or object in a party merge.
Customer Contact Points

Customer contact points point to party-level contact points. The customer contact point refers to the merge-to contact point on the merge-to party. This contact point is either a pre-existing contact point for the merge-to party or a contact point that has been transferred from the merge-from party.
Additional Party Information

If the duplicate check procedure identifies the following as exact duplicates, these entities are merged, otherwise they are transferred. The additional party information depends on whether the party is an organization, person, or either.
When the Party is an Organization

If the duplicate check procedure identifies the following as exact duplicates, they are merged.
Financial Numbers
If there is a duplicate financial number in the merge-to partys financial report data, that financial number is merged with the duplicate.
Duplicate Checking
Financial Reports
The procedure checks for duplicates in these columns in the HZ_FINANCIAL_ REPORTS table:
DATE_REPORT_ISSUED DOCUMENT_REFERENCE ISSUED_PERIOD REQUIRING_AUTHORITY TYPE_OF_FINANCIAL_REPORT REPORT_START_DATE REPORT_END_DATE AUDIT_IND CONSOLIDATED_IND ESTIMATED_IND FISCAL_IND FINAL_IND FORECAST_IND OPENING_IND PROFORMA_IND QUALIFIED_IND RESTATED_IND SIGNED_BY_PRINCIPALS_IND TRIAL_BALANCE_IND UNBALANCED_IND CONTENT_SOURCE_TYPE
Duplicate Checking
A-5
Duplicate Checking
Industrial Reference
The procedure checks for duplicates in these columns of the HZ_INDUSTRIAL_ REFERENCE table:
INDUSTRY_REFERENCE ISSUED_BY_AUTHORITY NAME_OF_REFERENCE RECOGNIZED_AS_OF_DATE
Organization Indicators
The procedure checks for duplicates in these columns of the HZ_ ORGANIZATION_INDICATORS table:
INDICATOR START_DATE END_DATE CONTENT_SOURCE_TYPE, DESCRIPTION
Securities Issued
The procedure checks for duplicates in these columns of the HZ_SECURITY_ ISSUED table:
ESTIMATED_TOTAL_AMOUNT STOCK_EXCHANGE_ID SECURITY_ISSUED_CLASS SECURITY_ISSUED_NAME TOTAL_AMOUNT_IN_A_CURRENCY STOCK_TICKER_SYMBOL SECURITY_CURRENCY_CODE BEGIN_DATE END_DATE
Duplicate Checking
When the Party is a Person

Citizenship
The procedure checks for duplicates in these columns of the HZ_CITIZENSHIP table:
BIRTH_OR_SELECTED COUNTRY_CODE DATE_DISOWNED DATE_RECOGNIZED DOCUMENT_REFERENCE END_DATE DOCUMENT_TYPE
Education
The procedure checks for duplicates in these columns of the HZ_EDUCATION table:
COURSE_MAJOR DEGREE_RECEIVED LAST_DATE_ATTENDED START_DATE_ATTENDED TYPE_OF_SCHOOL
Employment History
The procedure checks for duplicates in these columns of the HZ_EMPLOYMENT_ HISTORY table:
BEGIN_DATE EMPLOYED_AS_TITLE EMPLOYED_BY_DIVISION_NAME EMPLOYED_BY_NAME_COMPANY END_DATE
Duplicate Checking
A-7
Duplicate Checking
SUPERVISOR_NAME BRANCH MILITARY_RANK SERVED
Person Interest
The procedure checks for duplicates in these columns of the HZ_PERSON_ INTEREST table:
LEVEL_OF_INTEREST LEVEL_OF_PARTICIPATION INTEREST_TYPE_CODE COMMENTS SPORT_INDICATOR SUB_INTEREST_TYPE_CODE INTEREST_NAME SINCE
Person Language
The procedure checks for duplicates in these columns of the HZ_PERSON_ LANGUAGE table:
LANGUAGE_NAME NATIVE_LANGUAGE PRIMARY_LANGUAGE_INDICATOR READS_LEVEL WRITES_LEVEL SPEAKS_LEVEL
Work Class
The procedure checks for duplicates in these columns of the HZ_WORK_CLASS table:
WORK_CLASS_NAME LEVEL_OF_EXPERIENCE
Duplicate Checking
When the Party is Either an Organization or a Person

Certifications
The procedure checks for duplicates in these columns of the HZ_CERTIFICATIONS table:
CERTIFICATION_NAME CURRENT_STATUS EXPIRES_ON_DATE GRADE ISSUED_BY_AUTHORITY ISSUED_ON_DATE
Credit Ratings
Credit ratings are always transferred unless the application providing the credit rating information has a duplicate check in its merge procedures.
Financial Profiles
The procedure checks for duplicates in these columns of the HZ_FINANCIAL_ PROFILE table:
ACCESS_AUTHORITY_DATE ACCESS_AUTHORITY_GRANTED BALANCE_AMOUNT BALANCE_VERIFIED_ON_DATE FINANCIAL_ACCOUNT_NUMBER FINANCIAL_ACCOUNT_TYPE FINANCIAL_ORG_TYPE FINANCIAL_ORGANIZATION_NAME
Duplicate Checking
A-9
Duplicate Checking
References
The procedure checks for duplicates in these columns of the HZ_REFERENCES table:
COMMENTING_PARTY_ID EXTERNAL_ACCOUNT_NUMBER RATING REFERENCE_DATE COMMENTS

TCA Party Merge

Uploaded by

Copyright:

Available Formats

TCA Party Merge

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

TCA Party Merge

Uploaded by

Copyright:

Available Formats

What information is checked for duplicates?

What information is checked for duplicates?

What tables contain information that is checked for duplicates when the party is a person?

What tables contain information that is checked for duplicates when the party is a person?

Oracle Trading Community Architecture

Party Merge User Guide Release 11i

Send Us Your Comments

The Oracle Applications graphical user interface.

How To Use This Guide

Accessibility of Code Examples in Documentation

Accessibility of Links to External Web Sites in Documentation

Other Information Sources

Guides Related to All Products

Guides Related to This Product

Oracle Trading Community Architecture Administration User Guide

Oracle Receivables User Guide

Oracle Trading Community Architecture Relationship Manager User Guide

Oracle Trading Community Architecture API User Notes

Oracle Customers Online Concepts and Procedures

Installation and System Administration

Installing Oracle Applications

Oracle Applications Implementation Wizard User Guide

Upgrading Oracle Applications

Maintaining Oracle Applications

Oracle Applications System Administrators Guide

Oracle Alert Users Guide

Oracle Applications Developers Guide

Oracle Applications User Interface Standards for Forms-Based Products

Other Implementation Documentation

Oracle Workflow Guide

Oracle Applications Flexfields Guide

Oracle eTechnical Reference Manuals

Oracle Applications Message Manual

Training and Support

Do Not Use Database Tools to Modify Oracle Applications Data

Party Merge 1-1

Party Merge Overview

Party Merge Overview

Merge duplicate party sites for a party.

Use batch duplicate identification to automatically find batches of duplicates.

1-2 Oracle Trading Community Architecture Party Merge User Guide

Party Merge Overview

Merging Customers, Oracle Receivables User Guide

Party Merge 1-3

Party Merge Details

Party Merge Details

Merging Parties or Party Sites

Merging Individuals, Organizations, or Relationships

Merging Entities from Other Applications

1-4 Oracle Trading Community Architecture Party Merge User Guide

Party Merge Overview

Party Merge Example

Before the Merge

To Party Name Vision Inc.

To Party Site 100 Vision Parkway

Site Use Bill-to

Bill-to Ship-to Marketing Bill-to Ship-to

600 Vision Parkway

600 Vision Parkway

During the Merge