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 MAY 20, 2024

Applies to:

Oracle Trading Community - Version 12 and later
Information in this document applies to any platform.

Symptoms

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

Changes

Upgrade to R12

Cause

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
Symptoms
Changes
Cause
Solution


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