Autoinvoice Import Error - The System Cannot Find Tax Rate Information For Tax - The System Cannot Find Tax Rate Information for Tax Regime (Doc ID 1902213.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

On :  12.1.3 version, Tax Calculation

Upgraded from 11i to R12 and Autoinvoice is failing with validation error:

ERROR
-----------------------
Errors:   1) The system cannot find tax rate information for Tax regime: US-SALES-TAX-101, Tax: STATE, Tax status: STANDARD , Tax
               rate code: STANDARD and Tax Jurisdiction code: ST-CI-320270350. Please contact your tax manager.

The problem is system is trying find tax rate for wrong jurisdiction 'ST-CI-320270350' for Tax STATE.
This problem is only happening for autoinvoice.

There is no problem for manual invoices because the system is using the correct jurisdiction (ST-320000000) and current rates.
However, when checking both debug logs, autoinvoice and manual invoice both have error

You have multiple locations with this problem.
Using Vertex for data only. 
35 Invoices out of 2500 records are rejected.
RETURN_STATUS = E error buffer: No tax_rate_id found for the specified tax_regime_code, tax, tax_status_code and tax_rate_code

Cause

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