City Tax Not Calculating for a New City When the START_DATE is the Same and the SYSDATE (Doc ID 1670367.1)

Last updated on JULY 10, 2020

Applies to:

Symptoms

You are maintaining HZ_GEOGRAPHIES for US cites, by using the entry form within TCA.
When a new city is needed you update the following:

1. Enter new City under the correct county record.
2. Run Geography Name Referencing program
3. Enter a new record under the zone US_CITY_ZONE_TYPE_101
4. Create a new jurisdiction attaching the HZ_GEOGRAPHY and zone record.

All above have the same start date (current system date)

When a transaction is created, within AR, the city tax is not calculating and you receive the following error:

B: SEL hz_geography_type: out: p_location_id=95252,
p_location_type=SHIP_TO,
l_geography_type=US_CITY_ZONE_TYPE_101, l_geography_use=TAX"
get_zone(+)
R: Location country and Zone Type country are matching
Found geo name reference information in cache
Not Found Zone info in cache... call HZ_GEO_GET_PUB.get_zone
Returning from HZ_GEO_GET_PUB.get_zone with x_return_status:S x_msg_count:
x_msg_data:number of records in x_zone_tbl :0
R: No jurisdiction has been found
get_tax_jurisdictions(-)
ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)X_place_of_supply_type_cod
e = SHIP_TO
ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(+)
ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)S

If you change the Invoice Date to SYSDATE+1, the City Tax will calculate without error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.