R12: AP: Validating an Invoice While Using Vertex for Tax Calculation Errors With ORA-06510: PL/SQL: unhandled user-defined exception (Doc ID 1555457.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Vertex Sales Tax - Version 3.2 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When we are validating an invoice or calculating tax for an invoice, it is throwing an error and not allowing to calcualte tax/validate invoice

We are using Vertex for tax calculation

XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP "Error while excuting oic call for Invoice Verification and request id is 32720 Error Message Error specified in XML response document.:An error occurred while calculating tax on transaction identified by ""239000"". This may be an incorrect use of the calculation engine. Please contact your software vendor.
Error trying to calculate tax on transaction identified by (239000).
Location(s) assigned to transaction identified by (239000) is insufficient. A destination location is required for a tax calculation. Please provide valid locations for this transaction and retry.
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES Begin
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES End
XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP "ERROR BACKTRACE is: ORA-06512: at ""XXVERTEX.P_VERTEX_ETAX_P2P_AP_PKG"", line 2023
"
XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP "ERROR STACK is: ORA-06510: PL/SQL: unhandled user-defined exception
"
XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP Error While calling OIC executerequest for request_id 32720 Error message is Error specified in XML response document.:An error occurred while calculating tax on transaction identified by "239000". This may be an incorrect use of the calculation engine. Please contact your sof
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES Begin
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES "ERROR BACKTRACE is: ORA-06512: at ""XXVERTEX.P_VERTEX_ETAX_P2P_PKG"", line 940
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES "ERROR STACK is: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06510: PL/SQL: unhandled user-defined exception
"
XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP "ERROR BACKTRACE is: ORA-06512: at ""XXVERTEX.P_VERTEX_ETAX_P2P_AP_PKG"", line 2046
"
XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP "ERROR STACK is: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
"
XXVTX.P_VERTEX_ETAX_P2P_AP_PKG.POPULATE_VERTEX_VIEWS_FOR_AP "E_UNEXP_INV_VER Exception Error =>Error specified in XML response document.:An error occurred while calculating tax on transaction identified by ""239000"". This may be an incorrect use of the calculation engine. Please contact your software vendor.
Error trying to calculate tax on transaction identified by (239000).
Location(s) assigned to transaction identified by (239000) is insufficient. A destination location is required for a tax calculation. Please provide valid locations for this transaction and retry.
 SQLERRM: User-Defined Exception"
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES Begin
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES "ERROR BACKTRACE is: ORA-06512: at ""XXVERTEX.P_VERTEX_ETAX_P2P_PKG"", line 940
"
XXVTX.P_VERTEX_ETAX_P2P_PKG.LOG_MESSAGES "ERROR STACK is: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception

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