My Oracle Support Banner

Site Use And Site Use Original Source Reference Still Under Losing Site(Status=M) After Merge (Doc ID 2703874.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle Customer Data Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Accounts, Contacts, Households


When the customer has more than two sites with the same information after the merge those sites are merged into 1 site with multiple purpose, which is normal behavior.
With the case with 2 accounts, one of which had 3 identical addresses(different original system references), two with bill to site use and 1 with ship to site use. After the merge it was noticed that from 3 sites that were there before the merge, there were 2 sites, one of which(billing one) was with Status "M". For the site with the Status "M" the site use was still under the same site also the site use with Status "M". Meanwhile the original system reference for the site had been removed from the losing site(Status "M") and had been added on the wining site(Status "A") the original system reference section for the site use was still under the site use with Status "M". The original system reference for the site use was still active.

The original system reference should be transfered under SiteUseId which is the Bill To purpose for the wining site, following the logic that after the Duplicate Resolution the references for the wining sites and site uses are removed from the losing one and added to the wining. 

The issue can be reproduced at will with the following steps:
1.Created account with 3 identical addresses, 2 Bill To and 1 Ship To address:
2. Created second account with 1 address:
3. Created a Duplicate Resolution Request for the two accounts
4. Fetch the account from Fusion using the below service:
URL: https://<domain>/crmService/CustomerAccountService
5. Site use and site use reference still under losing site(Status=M) after merge

The issue has the following business impact:
Due to this issue, users cannot create orders for some sites after the account has been merged.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.