Customers Workbench: Cannot Query a Customer in the Form, Due to Mismatch of Primary Flag Setting Between HZ_CUST_ACCT_SITES_ALL and HZ_CUST_SITE_USES_ALL (Doc ID 1631914.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

SCENARIO 1
The PRIMARY_FLAG setting in HZ_CUST_SITE_USES_ALL is not carried over into 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.

The value of HZ_CUST_SITE_USES_ALL.PRIMARY_FLAG must be consistent with the corresponding flag field in HZ_CUST_ACCT_SITES_ALL.

For example:
When HZ_CUST_SITE_USES_ALL.SITE_USE_CODE = 'BILL_TO' and PRIMARY_FLAG = 'Y' then HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG = 'P'.
When HZ_CUST_SITE_USES_ALL.SITE_USE_CODE = 'BILL_TO' and PRIMARY_FLAG = 'N' then HZ_CUST_ACCT_SITES_ALL.BILL_TO_FLAG = 'Y'.

______________________________________

SCENARIO 2
Responsibility: Receivables Manager
Navigation: Customers -> Create/Maintain Customers
1. Query ACCOUNT NUMBER=XXXX
2. After clicking GO, in the ACCOUNTS section, an ACCOUNT
is listed with no PRIMARY BILL TO address even if the
account has it.

Cause

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