My Oracle Support Banner

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:
Responsibility:  Receivables
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.