Autoinvoice Import Program is Failing Orders with Invalid Tax Errors

(Doc ID 2405403.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle E-Business Tax - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Tax Calculation


Autoinvoice Import program is failing on some Orders with invalid tax errors :

ERROR
-------
The system cannot find tax information for tax regime US VERTEX TAX REGIME and tax COUNTRYCHOUTPUT. Please contact your tax manager.


Debug log shows :

XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..GET_CURRENCY zx_tax_partner_pkg.G_TAX_REGIME_CODE US VERTEX TAX REGIME
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..GET_CURRENCY lc_tax_name COUNTRYCHOUTPUT
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..GET_CURRENCY tax p_currency_code
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..GET_CURRENCY Regime p_currency_code USD
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..GET_CURRENCY End(-)
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..P_GET_EXTN_ATTR r_line_attr.curr_iso_code_dest: USD
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG. gl_conversion_rates(+)
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG. from_currUSD
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG. to_currencyUSD
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG. gl_conversion_rates exceptionORA-01403: no data found
XXVTX.VERTEX_CUSTOM_ATTRIBUTES_PKG..P_GET_EXTN_ATTR r_line_attr.curr_conv_rate_dest: 1

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