Customers Workbench: Primary Flag in HZ_CUST_SITE_USES_ALL Does Not Match HZ_CUST_ACCT_SITES_ALL

(Doc ID 1631914.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Locations

The PRIMARY_FLAG in HZ_CUST_SITE_USES_ALL does not match the following columns in the HZ_CUST_ACCT_SITES_ALL table:

BILL_TO_FLAG
SHIP_TO_FLAG
MARKET_FLAG

These fields in HZ_CUST_ACCT_SITES_ALL should match the control table of the HZ_CUST_SITE_USES_ALL table.

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