My Oracle Support Banner

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 MARCH 08, 2017

Applies to:

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


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,
l_geography_type=US_CITY_ZONE_TYPE_101, l_geography_use=TAX"
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
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.


To view full details, 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 a vibrant support community of peers and Oracle experts.