Multiple Primary Site Uses Per Type in HZ_CUST_SITE_USES_ALL and HZ_CUST_ACCT_SITES_ALL (Doc ID 2007917.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Receivables - Version 12 to 12.2.4 [Release 12.0 to 12.2]
Oracle Trading Community - Version 11.5.10.1 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

On :  R12 version, Customers Module

There are multiple Primary Site Uses for the site use types in HZ_CUST_SITE_USES_ALL and as a result there are multiple Primary Site records in HZ_CUST_ACCT_SITES_ALL.

However, there should only be one Primary Site Use per type in HZ_CUST_SITE_USES_ALL, and there should only be one Primary Site per site use type in HZ_CUST_ACCT_SITES_ALL.

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