R12:AP: Unexpected Error During Invoice Validation POP_ESTB_ID ORA-01422
(Doc ID 1310195.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterOracle Purchasing - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
Symptoms
On : 12.1.3 version,
When attempting to validate an invoice the following error occurs.
ERROR
-----------------------
Unexpected error occurred during Tax Calculation
Exception....
FND LOG SHOWS:
ZX_SRVC_TYP_PKG: Pop_Estb_Id()+ Error occurred in POP_ESTB_ID : ORA-01422: exact fetch returns more than requested number of rows RETURN_STATUS = U User-Defined Exception ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors ZX_API_PUB: DUMP_MSG()+ 0 Error Message(s) dumped into Zx_Errors_GT. ZX_API_PUB: DUMP_MSG()- Handle errors returned by API Get error message from eTax API Get error message from stack An unexpected error has occurred. Please contact your system administrator. Unexpected error occurred during Tax Calculation.
Exception: An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your System Administrator.
-----------------------
Unexpected error occurred during Tax Calculation
Exception....
FND LOG SHOWS:
ZX_SRVC_TYP_PKG: Pop_Estb_Id()+ Error occurred in POP_ESTB_ID : ORA-01422: exact fetch returns more than requested number of rows RETURN_STATUS = U User-Defined Exception ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors ZX_API_PUB: DUMP_MSG()+ 0 Error Message(s) dumped into Zx_Errors_GT. ZX_API_PUB: DUMP_MSG()- Handle errors returned by API Get error message from eTax API Get error message from stack An unexpected error has occurred. Please contact your system administrator. Unexpected error occurred during Tax Calculation.
Exception: An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your System Administrator.
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! |