My Oracle Support Banner

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:

Oracle Payables - Version 12.0.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
APPRVL - Invoice Validation
APXINWKB - Invoice Workbench



Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

-- 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:

Found the location info in cache for location id: <location_id> for table HR_LOCATIONS_ALL
B: SEL hz_geo_name_ref: in: p_location_id=<location_id>, p_geography_type=CITY,
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
Try to Validate the invoice (Actions > Validate)
Run the Invoice Validation Process

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


Upgraded from 11i to R12


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

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