duplicate addresses used by the same party
Hi All,
We are having a number of duplicate addresses that exist in the HZ_LOCATIONS table. It includes--
- duplicate addresses used by the same party : in that case the party name is the same, but the location ID is different
- the same address used by multiple parties: in that case the party name differs, but the location ID is the same.
We are able to identifying the duplicate addresses. How to clear the duplicate addresses used by the same party?
Thanks & Regards,
Gaurav Joshi.