PARTY_ID column is missing in HZ_CUST_ACCOUNT_ROLES and HZ_RELATIONSHIPS tables — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!