My Oracle Support Banner

DATAFIX: Eliminate Multiple or Overlapping Records in HZ_ORGANIZATION_PROFILES and/or HZ_PERSON_PROFILES (Doc ID 2260595.1)

Last updated on MARCH 20, 2020

Applies to:

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

Symptoms

Various errors may appear on multiple EBS Application forms or reports.

An example includes: The Adjustment Register does not match the AR Reconciliation Report.  The reports are not balancing. The invalid date ranges cause the Adjustment Register to not balance with the AR Reconciliation Report.
Various errors occur on the customer form. The invalid date ranges cause the Adjustment Register to not balance with the AR Reconciliation Report.


When reviewing the data, the HZ_Organization_Profiles (or HZ_Person_profiles) records contain incorrect effective_end_date values.  The records belonging to a single party_id contain overlapping date ranges. 
Fields effective_start_date and effective_end_date contain overlapping date ranges for the records for a single party_id.

Multiple records contain no effective_end_date.  Only one record per party_id and

 Multiple records for the same party_id cannot have overlapping data ranges for effective_start_date and effective_end_date.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Identify Corruption
 Still Have Questions?
References


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