AutoInvoice Error: Tax Debug Shows 'No rate found for trx conversion type: Corporate p_conversion_date = (Doc ID 795821.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle E-Business Tax - Version 12.0.0 and later
Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


Symptoms

Attempting to run Autoinvoice with a USER rate for exchange rate type, the following error occurs:

ERROR: from eBusiness Tax - return code = 1 Current system time is 05-MAR-2009 08:51:23
Please review the plsql debug log for additional details. Current system time is 05-MAR-2009
08:51:23
Error calling raaebt()
Error calling raapic()
raarrt2()+ Current system time is 05-MAR-2009 08:51:23
issued rollback in raarrt2 Current system time is 05-MAR-2009 08:51:23

The FND debug log shows:

ZX_TDS_TAX_ROUNDING_PKG: convert_amount(+)
p_from_currency = EURp_to_currency = GBPp_conversion_date = 28-JAN-09p_tax_conversion_type =
Corporatep_trx_conversion_type = User
ZX_TDS_TAX_ROUNDING_PKG: get_other_rate(+)p_from_currency = EURp_to_currency =
GBPp_conversion_date = 28-JAN-09P_trx_conversion_date = 25-JAN-09p_tax_conversion_type =
Corporatep_trx_conversion_type = User
No rate found for tax conversion type: Corporate p_conversion_date = 28-JAN-09
No rate found for trx conversion type: Corporate p_conversion_date = 28-JAN-09
Getting Rate information based on Currency Converion Date P_trx_conversion_date = 25-JAN-09
No rate found for tax conversion type: Corporate P_trx_conversion_date = 25-JAN-09
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
ZX_TDS_TAX_ROUNDING_PKG: get_other_rate(-)rate =
converted amount =
ZX_TDS_TAX_ROUNDING_PKG: convert_amount(-)E
ZX_TDS_TAX_ROUNDING_PKG: convert_to_currency(-)conversion rate = p_return_status = E
tax conversion rate = unround tax amt tax currency =
Incorrect return_status after calling ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines()
RETURN_STATUS = E

Changes

RUP 3 and later installed

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