Latin Tax Engine Autoinvoice With Manual Tax Lines for Colombia Ends With 'ERROR From EBusiness Tax - Return Code = 2' (Doc ID 2143875.1)

Last updated on MAY 20, 2024

Applies to:

Oracle E-Business Tax - Version 12.2.5 and later
Oracle Financials for the Americas - Version 12 and later
Information in this document applies to any platform.

Symptoms

Running autoinvoice with manual tax lines for Columbia,fails with error - ERROR from eBusiness Tax - return code = 2.

Debug Log File Shows:

ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line 1 tax_regime_id :=
14618 tax_id := 253391 tax_status_id := 56197 tax_jurisdiction_id :=
tax_rate_id := 135198
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line 3 RETURN_STATUS =
S
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.create_detail_tax_line.END 3 ZX_PRODUCT_IN
TEGRATION_PKG.create_detail_tax_line(-)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes 1 Global_Attrib
ute_Category: , Global_Attribute11: 1321038.75
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.update_nfe_icms_def_amounts.BEGIN 2 ZX_PRO
DUCT_INTEGRATION_PKG: update_nfe_icms_def_amounts(+)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.update_nfe_icms_def_amounts 2 Deferred
Rate:
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.update_nfe_icms_def_amounts 6 -1422:
ORA-01422: exact fetch returns more than requested number of rows
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.update_nfe_icms_def_amounts.END 6 ZX_PRODU
CT_INTEGRATION_PKG.update_nfe_icms_def_amounts(-)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes 1 Incorrect
RETURN_STATUS after calling update_nfe_icms_def_amounts
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes 1 RETURN_STATUS
= U
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_trx_line_with_taxes.END 1 ZX_PRODUC
T_INTEGRATION_PKG.fetch_manual_tax_lines(-)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax 6 Errored out
when calling import_trx_line_with_taxes().
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax.END 2 ZX_PRODUCT_
INTEGRATION_PKG: import_document_with_tax(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.CALL_LTE 1 LTE calculate tax returned errors.
Return_Status = U