Credit Transaction Error ORA-20001 An unexpected error has occurred (Doc ID 2499113.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Issue Clarification
Attempting to Credit an invoice and getting an error message in the form.

ERROR
"An Unexpected error has occur, Please contact your system administrator".

ZX.PLSQL.JL_ZZ_TAX calculate_latin_tax: EXCEPTION(NO_DATA_FOUND): jl_zz_tax.calculate_latin_tax
ZX.PLSQL.JL_ZZ_TAX EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate
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 JL_ZZ_TAX.calculate()- : tax_vendor_return_code 9
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.arp_tax_calculate -20001: ORA-20001:

ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte.END ZX_PRODUCT_INTEGRATION_PKG.calculate_tax_lte(-)
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax Errored out when calculate tax.
ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.calculate_tax.END ZX_PRODUCT_INTEGRATION_PKG: calculate_tax (-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.CALL_LTE LTE calculate tax returned errors. Return_Status = U
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax  returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.END ZX_API_PUB: DUMP_MSG()-
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Start Time :28-12-2018 16:13:11
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics End   Time :28-12-2018 16:13:12
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX.Statistics Total Time :0:0:1
ar.plsql.arp_standard.find_previous_trx_line_id return status service = U
ar.plsql.ARP_ETAX_SERVICES_PKG.Calculate_tax.end ARP_ETAX_SERVICES_PKG.Calculate_tax(-)
ar.resource.EXCEPTION EXCEPTION(ERROR_FROM_FUNCTION): jl_zz_tax.calculate
ar.resource.EXCEPTION An unexpected error has occurred. Please contact your system administrator.

Cause

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