My Oracle Support Banner

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 AUGUST 22, 2018

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

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
Cause
Solution


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