Relationship Type Information Not Stored In HZ_CUST_ACCT_RELATE_ALL Table in R12
(Doc ID 1530961.1)
Last updated on OCTOBER 13, 2022
Applies to:Oracle Trading Community - Version 12 and later
Information in this document applies to any platform.
The RELATIONSHIP_TYPE column in HZ_CUST_ACCT_RELATE_ALL is NULL for the Account Relationships created in R12.
It was populating in 11i with valid values.
Steps to Reproduce:
Navigation: Customers > Customers
Query for the account
Click on Details
Click on Relationships Tab
Click on Create Account Relationships
Create a new relationship
Upgrade to R12
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