Trading Community: GDF: Ensure HZ_Organization_Profiles Have Appropriate Effective_End_Date Values and Contain No Over-Lapping Date Ranges (Doc ID 2260595.1)

Last updated on JULY 14, 2017

Applies to:

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

Symptoms

The Adjustment Register does not match the AR Reconciliation Report.  The reports are not balancing. 
HZ_Organization_Profiles 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 by party_id.

The invalid date ranges cause the Adjustment Register to not balance with the AR Reconciliation Report.

Cause

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