Customer Data Matching with Oracle E-Business Suite
This process lets you match customer records in Oracle CX Sales with Oracle E-Business Suite.
During the customer synchronization process, customer records must be searched in Oracle E-Business Suite before synchronizing. The process calls the DQM Search Service web service in Oracle E-Business Suite, which returns a list of potential matches. DQM Search Service also offers fuzzy-matching capabilities.
If the customer record exists in Oracle E-Business Suite and there is only one match, then the process saves a cross-reference in Oracle CX Sales as an XREF custom object. The cross-reference contains the local identification in Oracle CX Sales and the remote identification in Oracle E-Business Suite.
If the customer record exists in Oracle E-Business Suite and has multiple potential matches, then the user is presented with a user interface (UI) where the potential matches are displayed. The user selects the candidate match. The process then associates the record in Oracle E-Business Suite with the record in Oracle CX Sales by saving cross-references.
If the customer record does not exist in Oracle E-Business Suite, then the Organization Service web service is called in Oracle E-Business Suite to create a new customer record. The process then saves a cross-reference in Oracle CX Sales with the local identification in Oracle CX Sales and the remote identification in Oracle E-Business Suite.
Detailed Customer Data Matching Process

When a salesperson performs a customer matching operation in Oracle CX Sales the following sequence takes place:
-
The process returns the Account object from Oracle CX Sales, and determines the customer synchronization status.
-
If the customer is not synchronized, or if the status is null, then the process calls the FindParties method in the DQM Search Service web service to perform a customer search in Oracle E-Business Suite. The customer search returns a list of matching candidates.
-
If there is no matching record, then the process calls the CreateOrganization method in the Organization Service web service in Oracle E-Business Suite. Organization Service returns the remote customer identification.
-
The process creates an XREF custom object in Oracle CX Sales using the local identification in Oracle CX Sales and the remote identification from Oracle E-Business Suite.
-
The process sets the synchronization status to Synchronized.