Autoinvoice Issue: Invoices Do Not Process Through Autoinvoice and Complete with Error - ERROR: From EBusiness Tax - Return Code = 2 - ORA-01001: Invalid Cursor in ZX.PLSQL.ZX_SRVC_TYP_PKG.IMPORT (Doc ID 1577774.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to run Autoinvoice to import transactions to Receivables and receive the following error:

ERROR: from eBusiness Tax - return code = 2 Current system time is 18-AUG-2013 19:42:35
Please review the plsql debug log for additional details. Current system time is 18-AUG-2013 19:42:35
Error calling raaebt()
Error calling raapic()
raarrt2()+ Current system time is 18-AUG-2013 19:42:35
Commit after cleanup - Current system time is 18-AUG-2013 19:42:35
raarrt2()- Current system time is 18-AUG-2013 19:42:35

Tax Debug shows the following error:

ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS.END 1 ZX_SRVC_TYP_PKG:DB_INSERT_LINE_DET_FACTORS(). Records Inserted = 71
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS.END 1 ZX_SRVC_TYP_PKG:DB_INSERT_LINE_DET_FACTORS()-, RETURN_STATUS = S
ZX.PLSQL.ZX_SRVC_TYP_PKG.IMPORT 6 ORA-01001: invalid cursor
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX 1 ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_SRVC_TYP_PKG.import returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN 2 ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 2 4 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN 2 ZX_API_PUB: DUMP_MSG()-
ar.plsql.fetching 1 import_document_with_tax returns failure
ar.plsql.arp_etax_util.calculate_tax_int.begin 2 arp_etax_util.calculate_tax_int()+
ar.plsql.arp_etax_util.calculate_tax_int 1 ZX_API_PUB.import_document_with_tax returns failure
ar.plsql.arp_etax_util.calculate_tax_int 1 An unexpected error has occurred. Please contact your system administrator.
ar.plsql.arp_etax_util.calculate_tax_int 1 An unexpected error has occurred. Please contact your system administrator.
fnd.plsql.FND_FILE.PUT_LINE 3 arp_etax_autoinv_util.calculate_tax()-
fnd.src.process.fdpwrt.fdpwrt.log_write 3 ERROR: from eBusiness Tax - return code = 2
fnd.src.process.fdpwrt.fdpwrt.log_write 3 Current system time is 19-AUG-2013 09:10:11
fnd.src.process.fdpwrt.fdpwrt.log_write 3 Please review the plsql debug log for additional details.
fnd.src.process.fdpwrt.fdpwrt.log_write 3 Current system time is 19-AUG-2013 09:10:11
fnd.src.process.fdpwrt.fdpwrt.log_write 3 Error calling raaebt()
fnd.src.process.fdpwrt.fdpwrt.log_write 3 Error calling raapic()
fnd.src.process.fdpwrt.fdpwrt.log_write 3 raarrt2()+
fnd.src.process.fdpwrt.fdpwrt.log_write 3 Current system time is 19-AUG-2013 09:10:11
fnd.src.process.fdpwrt.fdpwrt.log_write 3 issued rollback in raarrt2

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