R12: Unexpected error occurred during tax calculation when Validating Invoice ORA-01001 ZX_API_PUB CALCULATE_TAX ZX_SRVC_TYP_PKG.calculate_tax (Doc ID 552705.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

-- Problem Statement:
Invoice Validation process or Online Validation ends with the following error while calculating Tax:

'Unexpected error occurred during tax calculation.
Exception: An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your system administrator.'

Used Note 458371.1 - R12: How to Get the R12 Trace and FND Debug File / FND Log for Payables Processes - to obtain FND Debug Log messages which shows the following additional errors:

get_location_info(+)
Found the location info in cache for location id: <location_id> for table HR_LOCATIONS_ALL
get_location_info(-)
B: SEL hz_geo_name_ref: in: p_location_id=<location_id>, p_geography_type=CITY,
x_location_table_name=HR_LOCATIONS_ALL
S: SEL hz_geo_name_ref: no_data_found: x_location_table_name=HR_LOCATIONS_ALL B:
x_geography_id=, p_geography_type=CITY, p_location_id=<location_id>, p_geography_type=CITY
S: hz_geo_no_geo_name_ref: p_geography_type=CITY

ORA-01001 : invalid cursor
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors

-- Steps To Reproduce:
Upgrade from 11i to R12 using Migrated Taxes
Create Invoice header
Create Invoice Line and enter Tax Classification Code manually
Enter Distributions
Save the data
Click on Calculate Tax
Or
Try to Validate the invoice (Actions > Validate)
Or
Run the Invoice Validation Process

-- Business Impact:
Unable to validate invoices halts the entire AP cycle.

Changes

Upgraded from 11i to R12

Cause

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