Item Tax Exemption Created At Tax Jurisdiction Level Is Not Getting Applied When AR Invoice Is Creat (Doc ID 2164621.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


We have created Item Tax Exemption and created at Tax jurisdiction level in Ebtax.  The invoice for that item it is not exemption the tax


The tax debug shows the following

ZX_TCM_TAX_RATE_PKG.get_tax_rate(+)
p_tax = CA PST
p_tax_status_code = CA PST STANDARD
p_tax_regime_code = CA PST R12
p_tax_jurisdiction_code = CA-BC
p_tax_date = 01-JUN-16
ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(+)
p_multiple_jurisdictions_flag: N
ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(+)
Found Tax rate: tax_rate_id: 17322 
tax_rate_code: CA PST STANDARD RATE
ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-)
ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)
tax_rate_code = CA PST STANDARD RATE
tax_rate_id = 17322
rate_type = PERCENTAGE
percentage_rate = 7
quantity_rate =
allow_adhoc_tax_rate_flag = Y
uom_code =
offset_tax_rate_code =
ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)
tax rate code: CA PST STANDARD RATE tax_rate = 7

1019054 = jurisdiction
item_id = 34

Ran the following query

select allow_exceptions_flag from zx_rates_b where tax_rate_id = 17322;

Shows that the allow_exceptions_flag was not set.

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