Autoinvoice Import Program Is Finishing With Error: eBusiness Tax - return code = 2, Error Message ORA-20001: APP-AR-11526: EXCEPTION(NO_DATA_FOUND):jl_zz_tax.get_legal_message (Doc ID 1576804.1)

Last updated on JUNE 16, 2021

Applies to:

Symptoms

On : 12.0.4 version, Latin Tax Engine

Attempting to run Autoinvoice and receive the following error:

ERROR
-----------------------
ERROR: from eBusiness Tax - return code = 2 Current system time is 09-AUG-2013 10:51:01
Please review the plsql debug log for additional details. Current system time is 09-AUG-2013 10:51:01
Error calling raaebt()
Error calling raapic()
Commit after cleanup - Current system time is 09-AUG-2013 10:51:01

The debug log file shows:

ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG ... E: Override Tax Rate =
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG ... E: Party Flag =
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.dump_tax_info_rec.END ZX_PRODUCT_INTEGRATION_PKG.dump_tax_info_rec(-)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG EXCEPTION(process_tax_rec_f_sql in loop)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG SQLCODE -20001Error Message ORA-20001: APP-AR-11526: EXCEPTION(NO_DATA_FOUND):jl_zz_tax.get_legal_message
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG -- Raise error
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.process_tax_rec_f_sql -20001: ORA-20001: APP-AR-11526: EXCEPTION(NO_DATA_FOUND):jl_zz_tax.get_legal_message
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte -20001: ORA-20001: APP-AR-11526: EXCEPTION(NO_DATA_FOUND):jl_zz_tax.get_legal_message
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_PRODUCT_INTEGRATION_PKG.calculate_tax_lte.END ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte(-)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax Incorrect return_status after calling ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte().
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.import_document_with_tax.END ZX_PRODUCT_INTEGRATION_PKG: import_document_with_tax(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.CALL_LTE LTE calculate tax returned errors. Return_Status = U
ZX.PLSQL.ZX_SRVC_TYP_PKG.IMPORT Incorrect status returned by Call_lte. Return_StatusU
ZX.PLSQL.ZX_SRVC_TYP_PKG.IMPORT User-Defined Exception
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_SRVC_TYP_PKG.import returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+

Steps to Reproduce:
Responsibility:  Receivables with Latin Tax Engine activated for Brazil
Navigation:  Interfaces > Autoinvoice
Run Autoinvoice Master Program

Changes

Cause

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