Using hz_cust_account_site_v2pub.update_cust_site_use To Update Tax_code To NULL Does Not Work (Doc ID 335499.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version: 11.5.9
This problem can occur on any platform.
hz_cust_account_site_v2pub.update_cust_site_use

Symptoms

Using hz_cust_account_site_v2pub.update_cust_site_use to update HZ_CUST_SITE_USES_ALL.TAX_CODE

The results are:

1. You are able to update existing tax codes to a different value
2. You are able to put a value when the tax code is blank

BUT
You are not able to change an existing TAX_CODE to null.

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