My Oracle Support Banner

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:

SQL> select count(*) from hz_party_relationships;

 
COUNT(*)
----------
1989

2) Run the following select in R12 instance:

SQL> select count(*) from hz_party_relationships;

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

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

Solution

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
Goal
Solution
 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.