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 MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

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

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