My Oracle Support Banner

Autoinvoice Fails APP-AR-11526: ORA-01086: savepoint 'IMPORT_DOCUMENT_PVT' never established (Doc ID 2459566.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

Symptoms

On : R12 Autoinvoice Related

When attempting to run Autoinvoice, the following error occurs.

ERROR
-----------------------

APP-AR-11526: ORA-01086: savepoint 'IMPORT_DOCUMENT_PVT' never established in this s
begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :^Z
APP-AR-11526: 13974260/ar/lib/raaebt.lpc 127
Error calling raaebt()
Error calling raapic()


Generating a debug of the error shows the following

ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.GET_VENDOR_ERROR.BEGIN ZX_TAXWARE_TAX_SERVICE_PKG: GET_VENDOR_ERROR()+
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.GET_VENDOR_ERROR CALLING STACK_ERROR
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.STACK_ERROR.BEGIN ZX_TAXWARE_TAX_SERVICE_PKG: STACK_ERROR()+
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.STACK_ERROR -- P_MSGNAME = GENERIC_MESSAGE
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.STACK_ERROR -- P_TOKEN1 = GENERIC_TEXT
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.STACK_ERROR -- P_VALUE1 = Taxware Errror: Taxfn_Tax010 returned FALSE and GenCmplCd = 25
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.STACK_ERROR -- P_TOKEN2 =
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.STACK_ERROR -- P_VALUE2 =
...............
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.DUMP_VENDOR_REC 3257078:JurLink.JurLocType = [O]
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.DUMP_VENDOR_REC.BEGIN ZX_TAXWARE_TAX_SERVICE_PKG: DUMP_VENDOR_REC()-
ZX.PLSQL.ZX_TAXWARE_TAX_SERVICE_PKG.CALCULATE_TAX_API.END ZX_TAXWARE_TAX_SERVICE_PKG: CALCULATE_TAX_API()-
ZX.PLSQL.ZX_TPI_SERVICES_PKG.CALL_PARTNER_SERVICE.END ZX_TPI_SERVICES_PKG: CALL_PARTNER_SERVICE(-) RETURN_STATUS = S
ZX.PLSQL.ZX_TPI_SERVICES_PKG.PTNR_POST_PROCESSING_CALC_TAX.BEGIN ZX_TPI_SERVICES_PKG: PTNR_POST_PROCESSING_CALC_TAX(+)
ZX.PLSQL.ZX_TPI_SERVICES_PKG.PTNR_POST_PROCESSING_CALC_TAX Checking whether any item lines processed for this Transaction
ZX.PLSQL.ZX_TPI_SERVICES_PKG.PTNR_POST_PROCESSING_CALC_TAX ORA-01403: no data found
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_calculate_tax_pvt RETURN_STATUS = U
ZX.PLSQL.ZX_SRVC_TYP_PKG.ptnr_bulk_calc_tax_pvt Incorrect Status returned by Ptnr_calculate_tax_pvt. RETURN_STATUS = U
ZX.PLSQL.ZX_SRVC_TYP_PKG.import "ORA-01086: savepoint 'PTNR_BULK_CALC_TAX_PVT' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception"
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.BEGIN ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.END ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_SRVC_TYP_PKG.import returned errors

You are on
ZX_TAXWARE_TAX_SERVICE_PKG        zxtxwsrvcpkgb.pls                120.24.12010000.22
ZX_SRVC_TYP_PKG                           zxifsrvctypspkgb.pls             120.246.12010000.106

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
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.