Vertex O Series Integration: Credit Memo Failing In AutoInvoice - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows

(Doc ID 1676112.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

On : 12.1.1 version, Receivables Uptake of EBTAX

Vertex O Series.

Attempting to import Credit Memos through AutoInvoice and receive the following error:

ERROR
-----------------------
ZX_VTX_USER_PKG: POPULATE_EXEMPTION_DETAILS(+)
No Source Tax
ORA-01422: exact fetch returns more than requested number of rows
ORA-0000: normal, successful completion
RETURN_STATUS = E
RETURN_STATUS = E
ZX_SRVC_TYP_PKG: ptnr_calculate_tax_pvt returned errors
ZX_SRVC_TYP_PKG: DELETE_FROM_LINES_DET_GT(+)
ZX_SRVC_TYP_PKG: DELETE_FROM_LINES_DET_GT(-)
ZX_API_PUB: DUMP_MSG()+
0 Error Message(s) dumped into Zx_Errors_GT.
ZX_API_PUB: DUMP_MSG()-
ZX_SRVC_TYP_PKG: PTNR_BULK_CALC_TAX_PVT(-)raised errors
RETURN_STATUS: E
ZX_SRVC_TYP_PKG: PTNR_BULK_CALC_TAX_PVT(-)
RETURN_STATUS = E
ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_SRVC_TYP_PKG.import returned errors
ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(+)

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