Use the Duplicate Customer Report to highlight possible duplicate customers. The Duplicate Customer Report lists the company or agency name, address, location, city, state, postal code, and country. Receivables groups possible duplicate customer information together for you to review. Use this information to consolidate duplicated customer information.
Customer Name: To restrict the search to a specific name, enter a customer name (optional).
Number of Characters: Enter the number of characters that you think should be the same, for the customer names to be deemed as potential duplicates.
Address: The street address for this customer.
City: The city for this customer address.
Country: The country for this customer address.
Customer Name: The customer name.
Customer Number: The customer id number.
Postal Code: The postal code for this customer address.
Site Code: The business purpose assigned to this address.
State: The state for this customer address.
Other Sources
Merging Customers, Oracle Trading Community Architecture User Guide