My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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


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.


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

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