PARTY_ID column is missing in HZ_CUST_ACCOUNT_ROLES and HZ_RELATIONSHIPS tables
Summary: PARTY_ID column is missing in HZ_CUST_ACCOUNT_ROLES and HZ_RELATIONSHIPS tables.
Please share alternate column to fetch Party Relationship party Type from HZ_PARTIES.
Content (required): PARTY ID is missing , due to this we are not able to join HZ_PARTIES with of type Party Relationships
Version (include the version you are using, if applicable): 12.1.3
Code Snippet (add any code snippets that support your topic, if applicable): We join Party id from these tables to HZ_PARTIES and HZ_RELATIONSHIPS and all to get the contact details.