City Tax Not Calculating for a New City When the START_DATE is the Same and the SYSDATE
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,
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
e = SHIP_TO
If you change the Invoice Date to SYSDATE+1, the City Tax will calculate without error.
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