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 14, 2022
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
1. Bug Summary |
2. Fixed Files |
3. Recommended Patches |
4. Solution Steps |
References |