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

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.0.6 and later
Information in this document applies to any platform.
***Checked for Relevance 7-May-2013***
Information in this document applies to any platform.

Goal

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:

 
COUNT(*)
----------
433

The count is a lot higher in 11i than in R12.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms