11i: Activating a Bill To Site Usage Before Activating the Site Causes the BILL_TO_FLAG Column in HZ_CUST_ACCT_SITES_ALL to NULL

(Doc ID 1585594.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

You are attempting to inactivate a Primary Bill-To Site, but it leads to no active Primary site for the customer.
There is a data mismatch, as displayed below: 

A Customer Account has Inactive Site and Inactive Bill-To usage.

1. Both Customer Addresses and Usage were Inactive. So values in HZ_CUST_ACCT_SITES_ALL are:

BILL_TO_FLAG STATUS
------------ ------
I

2. The Active check-box of Bill-To Usage is now checked before the Active check-box of Customer Addresses.  Values in HZ_CUST_ACCT_SITES_ALL are:

BILL_TO_FLAG STATUS
------------ ------
Y (or P) I

3. Now the Active check-box of Customer Addresses was checked and saved. Values in HZ_CUST_ACCT_SITES_ALL are:


BILL_TO_FLAG STATUS
------------ ------
A

The table data (BILL_TO_FLAG) should be 'Y' (or 'P').
However, it became NULL.  Even though it was 'Y' (or 'P') before the save.

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