R12: AP: Error When Trying to Calculate Tax on Invoice (Doc ID 2283089.1)

Last updated on NOVEMBER 19, 2021

Applies to:

Symptoms

In the Invoice workbench when trying to click calculate Tax button receiving the following error:

Unable to Calculate Tax on the Payable Invoice.

Debug log shows following details:

Not Found Zone info in cache... call HZ_GEO_GET_PUB.get_zone

- get_zone (+)
- Param p_location_table_name HZ_LOCATIONS p_location_id xx p_zone_type UK_COUNTRY_ZONE_TYPE_1 p_date 30-JUN-17
-For Zone type UK_COUNTRY_ZONE_TYPE_1 Relationship type count is 1
- Country Code for location yy
- For location yy Geo Name References count is 0
-In Exception - For geography_type COUNTY and Location yy, Geography_id is

Geography Name Referencing has not been performed for this location record. Geography Name Referencing must be performed on the location before a zone can be determined.
R: No jurisdiction has been found
get_tax_jurisdictions(-)
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-

Cause

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