Tax In Autoinvoice Failing Convert_to_currency(-)Conversion Rate (Doc ID 887710.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Symptoms

See also <Note 795821.1> AutoInvoice Error: Tax Debug Shows 'No rate found for trx conversion type: Corporate p_conversion_date = 

Auto Invoice fails with error.  Tax debug log shows the following:

ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_other_rate Getting Rate information based on Currency
Converion Date P_trx_conversion_date = 18-AUG-08
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_other_rate No rate found for tax conversion type: Corporate
P_trx_conversion_date = 18-AUG-08
ZX.PLSQL.ZX_API_PUB.ADD_MSG.BEGIN ZX_API_PUB: ADD_MSG()+
ZX.PLSQL.ZX_API_PUB.ADD_MSG.END ZX_API_PUB: ADD_MSG()-
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.get_other_rate.END ZX_TDS_TAX_ROUNDING_PKG:
get_other_rate(-)rate =
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_amount.END converted amount =
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_amount.END ZX_TDS_TAX_ROUNDING_PKG: convert_amount(-)E
ZX.PLSQL.ZX_TDS_TAX_ROUNDING_PKG.convert_to_currency.END ZX_TDS_TAX_ROUNDING_PKG:
convert_to_currency(-)conversion rate = p_return_status = E
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination Incorrect return_status after
calling ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines()
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination RETURN_STATUS = E
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination.END
ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination(-)
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 1 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()-
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX ZX_API_PUB:
IMPORT_DOCUMENT_WITH_TAX:ZX_TDS_CALC_SERVICES_PUB_PKG.tax_line_determination returned errors

.

Cause

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