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
Last updated on MARCH 22, 2018
Applies to:Oracle Receivables - Version 220.127.116.11 to 18.104.22.168 [Release 11.5.10]
Information in this document applies to any platform.
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:
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:
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:
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.
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