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 FEBRUARY 19, 2019
Oracle Receivables - Version 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Information in this document applies to any platform.
When attempting to inactivate a Primary Bill-To Site, 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.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.