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 JUNE 05, 2024
Applies to:
Oracle Receivables - Version 12.1.1 and laterInformation 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(+)
Changes
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 |
| Changes |
| Cause |
| Solution |