My Oracle Support Banner

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 APRIL 06, 2018

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

 

Changes

 Upgrade to 12.2.5

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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