My Oracle Support Banner

R12 - Missing Rows In HZ_PARTY_RELATIONSHIPS After 12.0.6 Upgrade (Doc ID 872062.1)

Last updated on OCTOBER 23, 2018

Applies to:

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


After upgrading to R12.0.6, rows are missing in hz_party_relationships.
Also for all the rows, directional_flag used to be N now they are all Y
Rows that are missing are the ones that had end-date of 31-DEC-4712.

This is impacting some queries.

Both of the instances that are upgraded to R12.0.6 are missing rows in hz_party_relationships.

Steps to reproduce:

1) Run the following select in 11i instance:


The count is a lot higher in 11i than in 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
 Still Have Questions?

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