11i - Number of Relationships displayed on Merge Batch is wrong compared to HZ_PARTY_RELATIONSHIPS
Last updated on JULY 12, 2017
Applies to:Oracle Trading Community - Version 220.127.116.11 and later
Information in this document applies to any platform.
In 18.104.22.168, Merge Request Map Relationships in Oracle Customers Online (OCO) display shows a lower quantity of Organization Contact relationships than actually exist in HZ_PARTY_RELATIONSHIPS.
This was found when the Map Relationships screen displayed a difference in quantities between the number of Initial and Final Relationships indicating that a Mandatory (or Optional) merge had been defined but the Resolve Duplicates display showed no Mandatory (or Optional) Relationship merge.
Comparing to the HZ_PARTY_RELATIONSHIPS for the involved parties, the counts in OCO were low and did not display any Relationships for a particular person that would in fact be a Mandatory Relationship merge.
Responsibility: Customers Online Superuser
Navigation: Administration > Data Quality tab > Merge Requests subtab
Create Merge Request
Map icon for Merge Request
Difference in quantity between Initial and Final Relationships count
Resolve Duplicates does not show the expected Mandatory (or Optional) relationship merges to account for the difference in quantity between the Initial & Final Relationship counts.
Output of the script below shows HZ_PARTY_RELATIONSHIPS shows a larger quantity of relationships for the same parties including relationships for an Organization Contact that is not displayed in the Resolve:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms