My Oracle Support Banner

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

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

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References

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