Tax Calculation Issue: Tax is Not Calculating in AR When Party Exists as Both Vendor and Customer (Doc ID 1073370.1)

Last updated on APRIL 10, 2015

Applies to:

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

Symptoms

Tax is not calculating under the following conditions.

1. Release 12.+
2. Create a new customer (create a site bill_to and ship_to)
3. Create a transaction and tax is not calculated.

Click on the tax profile of the ship_to site address.  Update the checkbox field 'Allow Tax Applicability' from a null check value to a checked value. Now tax is calculated correctly on a new invoice.

Log files show the follow:

Tax not applied with new cust and flag ('Allow Tax Applicability' ) set to null:

ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes(+)
l_template_usage_code := TAX_RULES
ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes(-)
ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(+)
ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(+)
Tax date = 02-MAR-10Tax determine date = 02-MAR-10Tax point date = 02-MAR-10
ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)S
ZX_SRVC_TYP_PKG: CALCULATE_TAX_PVT()- RETURN_STATUS = S
ZX_SRVC_TYP_PKG:UPDATE_LINE_DET_FACTORS()+
ZX_SRVC_TYP_PKG:UPDATE_LINE_DET_FACTORS(). Records Updated = 1
ZX_SRVC_TYP_PKG:UPDATE_LINE_DET_FACTORS()-, RETURN_STATUS = S
ZX_SRVC_TYP_PKG:UPDATE_LINE_DET_FACTORS()+
ZX_SRVC_TYP_PKG:UPDATE_LINE_DET_FACTORS(). Records Updated = 1
ZX_SRVC_TYP_PKG:UPDATE_LINE_DET_FACTORS()-, RETURN_STATUS = S
ZX_SRVC_TYP_PKG: CALCULATE_TAX()- RETURN_STATUS = S
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(+)
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(+)
p_detail_tax_lines_tbl is empty.
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)S
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)S
ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(+)
ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(+)
ZX_TDS_TAX_ROUNDING_PKG: perform_rounding(+)
ZX_TDS_TAX_ROUNDING_PKG: perform_rounding(-)S
ZX_TDS_TAX_LINES_POPU_PKG: process_tax_tolerance(+)


Tax not applied with new cust and flag ('Allow Tax Applicability' ) is checked.

l_template_usage_code := TAX_RULES
ZX_TDS_CALC_SERVICES_PUB_PKG.get_tax_regimes(-)
ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(+)
ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(+)
Tax date = 02-MAR-10Tax determine date = 02-MAR-10Tax point date = 02-MAR-10
ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(+)
ZX_TDS_UTILITIES_PKG.get_tax_index(+) tax_regime_code : US-SALES-TAX-101 tax
: COUNTY
Warning: p_begin_index is NULL
ZX_TDS_UTILITIES_PKG.get_tax_index(-)
ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(+)
p_place_of_supply_rule_flag = Np_Def_Place_Of_Supply_Type_Cd =
SHIP_TO_BILL_TOp_applicability_rule_flag = Np_def_reg_type = SHIP_TO_SITE
ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name(+)pos_type = SHIP_TO
get_pos_loc_or_site(+) B: SEL zx_party_types: in: p_party_type=THIRD_PARTY
R: SEL zx_party_types: out: x_loc_tbl=HZ_LOCATIONS, x_loc_site=LOCATION_ID
get_pos_loc_or_site(-)
ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+
ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()-,
p_tax_param_code:SHIP_TO_LOCATION_ID x_tax_param_value:23952
get_tax_jurisdictions(+) B: SEL hz_geography_types: in: p_tax=COUNTY,
p_tax_regime_code=US-SALES-TAX-101
ZX_TDS_UTILITIES_PKG.get_regime_cache_info(+) regime code: US-SALES-TAX-101
ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-) tax_regime_id = 8565
RETURN_STATUS = S
R: Tax Regime is created for a country
get_location_table_name(+)B: p_location_type= SHIP_TO
get_pos_loc_or_site(+) B: SEL zx_party_types: in: p_party_type=THIRD_PARTY
Found the party type information in cache for:THIRD_PARTY
R: SEL zx_party_types: out: x_loc_tbl=HZ_LOCATIONS, x_loc_site=LOCATION_ID
get_pos_loc_or_site(-)
R: x_location_table_name=HZ_LOCATIONSget_location_table_name(-)

 

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