Autoinvoice:: ERROR: from EBusiness Tax - Return Code = 2

(Doc ID 2239867.1)

Last updated on MAY 23, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Receivables Uptake of EBTAX, TEST

While running the Autoinvoice using Latin Tax Engine (LTE) for Brazil, notice the request ends in error and that the log shows the following error:


ERROR
-----------------------
ERROR: from eBusiness Tax - return code = 2 Current system time is 16-FEB-2017 09:39:14
Please review the plsql debug log for additional details. Current system time is 16-FEB-2017 09:39:14
Error calling raaebt()
Error calling raapic()
raarrt2()+ Current system time is 16-FEB-2017 09:39:14
issued rollback in raarrt2 Current system time is 16-FEB-2017 09:39:14

2 Error(s) occured while inserting tax lines in ZX_DETAIL_TAX_LINES_GT.
ORA-00001 error occurred for Trx_id : -99
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
ORA-00001 error occurred for Trx_id : 13671200
ZX_API_PUB: ADD_MSG()+
ZX_API_PUB: ADD_MSG()-
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
Incorrect return_status after calling ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt
RETURN_STATUS = U
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt returned errors

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Receivables Manager with LTE enabled
2. Navigation: Requests > Run Requests > Run Autoinvoice Import Program
3. Notice the error message in the log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import transactions via Autoinvoice and this is delaying testing deadlines..

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