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 MARCH 21, 2017

Applies to:

Oracle Financials for the Americas - Version 12.0.4 and later
Information in this document applies to any platform.

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

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