R12 - TCA API HZ_CUST_ACCOUNT_SITE_V2pub.create_cust_site_use Errors With 'The Site Use Referenced By This Bill_to_site_use_id Must Be Active Bill-To' (Doc ID 817073.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

When using TCA API 'hz_cust_account_site_v2pub.create_cust_site_use' to create the 'Ship To' usage and link it to an existing Bill To usage by assigning the Bill To location to p_cust_site_use_rec.bill_to_site_use_id parameter in the API procedure, the following error is received:

Error: The site use referenced by this bill_to_site_use_id must be active bill-to, belong to an active customer account site, and assigned to the same or a related customer account. Please select adifferent bill-to site use.

Detailed Scenario: There is a Customer Account (A1).

Case 1:
For this account, there is an account site (S1) and needs ‘Bill to’ and ‘Ship To’ usage for it.
For site S1, a ‘Bill to’ usage is created using API hz_cust_account_site_v2pub.create_cust_site_use.

Now, using the same API to create second usage ‘Ship To’ for site S1 and link it to the ‘Bill To’, which was just created.  For linking ‘Bill to’ site usage to ‘Ship To’ usage, the ‘Bill to’ SITE_USE_ID needs to be passed to the parameter p_cust_site_use_rec.bill_to_site_use_id while using the API to create ‘Ship To’ usage.  

The  issue here is that:



Case 2: 
Need to create a new site S2 with site usage as ‘Ship To’.

It is understood that only ‘Ship to’ can not be created for Account Site, it has to be linked to ‘Bill to’ location.

Here, a site is created.  Now, try to create a ‘Ship to’ usage using the API hz_cust_account_site_v2pub.create_cust_site_use. 

To link the ‘Ship to’ usage to the ‘Bill to’ location, the SITE_USE_ID created in Case 1 is passed to the parameter p_cust_site_use_rec.bill_to_site_use_id for the API.  This does not created the ‘Ship To’ site usage and gives the following error:
The site use referenced by this bill_to_site_use_id must be active bill-to, belong to an active customer account site, and assigned to the same or a related customer account. Please select a different bill-to site use.

The issue remains even after applying Patch 8295000.

The piece of code which has the API that is throwing the error:

 

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