Trading Community: GDF: Ensure HZ_Organization_Profiles Have Appropriate Effective_End_Date Values and Contain No Over-Lapping Date Ranges
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms