My Oracle Support Banner

Customers Workbench: The HZ_HIERARCHY_NODES are Updated Incorrectly when Relationships are End-dated (Doc ID 1629552.1)

Last updated on JANUARY 03, 2023

Applies to:

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


Attempting to end date a Relationship and find that the HZ_HIERARCHY_NODES are updated incorrectly when the relationships are end-dated.
Hierarchical relationships were established between parties as shown below.

Level 1 Level 2 Level 3 Level 4

Steps to Reproduce:
Step 1: End-date parent/child relationship XxxxxLevel3A / XxxxxLevel4A:
Relationship end-dated successfully. Changes successfully cascaded up to top level parent.
XxxxxLevel3A to XxxxxLevel3A (level 0) is end dated
XxxxxLevel4A to XxxxxLevel4A (level 0) is end dated
XxxxxLevel4A to XxxxxLevel3A (level 1) is end dated
XxxxxLevel4A to XxxxxLevel2 (level 2) is end dated
XxxxxLevel4A to XxxxxLevel1 (level 3) is end dated

Step 2: Create parent/child relationship XxxxxLevel3B/XxxxxLevel4A:
Relationship established successfully. Relationships successfully cascaded up to top level parent. (You only see one active level 0 for XxxxxLevel4A)

Step 3: End-date parent/child relationship XxxxxLevel3A/XxxxxLevel2:
Relationship end-dated successfully.
Changes for XxxxxLevel3A is successfully cascaded up to top level parent:
XxxxxLevel3A to XxxxxLevel3A is end dated
XxxxxLevel3A to XxxxxLevel2 is end dated
XxxxxLevel3A to XxxxxLevel1 is end dated

However, the following relationships were also incorrectly end-dated:
Row 4 and 5 are XxxxxLevel2 to XxxxxLevel4A, both are end dated.
There should only be one row is end dated, another one should be ACTIVE, since there is still a relationship (XxxxxLevel4A to XxxxxLevel3B to XxxxxLevel2 to XxxxxLevel1)
Row 6 and 7 are incorrectly end dated as well, for relationship XxxxxLevel1 to XxxxxLevel4A


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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