My Oracle Support Banner

How To Change "allow_relate_to_self_flag" Column In hz_relationship_types Table? (Doc ID 433394.1)

Last updated on MAY 31, 2019

Applies to:

Oracle Trading Community - Version 11.5.9 to [Release 11.5]
Information in this document applies to any platform.


You have a custom relationship type "MA Governed" defined two years back that is being used to set up Org-Org relationships.  This relationship does not allow set up a self relation (that is, a party related to itself using this relationship).  When you checked the HZ_RELATIONSHIP_TYPES table for this relationship type, the ALLOW_RELATE_TO_SELF_FLAG is set to N.

This needs to be changed to Y, but there does not appear to be a form or jsp page that allows this flag to be changed.  The "Relationships Administration" page in TCA does not show this flag and so, does not allow changing it.

Is there a way to change the 'ALLOW_RELATE_TO_SELF_FLAG' flag so that users can start using this relationship to satisfy the business case of relating a party to itself ?


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.