My Oracle Support Banner

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 later
Oracle 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.


 

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!


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