R12: AP: EBTax: Error on Validation of Invoice from Invoice Workbench: "Unexpected Error During Tax Calculation", "The event class information passed is incorrect. Please CHECK! ORA-01422: exact fetch returns more than requested number of rows"
(Doc ID 3047457.1)
Last updated on MARCH 12, 2025
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
There is tax error when any invoice is validated in Payables
Error is returned on Invoice Workbench/Invoice Validation program log files.
Error on Invoice workbench
-----------------------
Unexpected Error During Tax Calculation
Error in FND Debug log
-----------------------
ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.get_tax_event_class.BEGIN 1 ZX_VALID_INIT_PARAMS_PKG: get_tax_event_class()+
ZX.PLSQL.ZX_VALID_INIT_PARAMS_PKG.get_tax_event_class 6 The event class information passed is incorrect. Please CHECK! ORA-01422: exact fetch returns more than requested number of rows
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX 1 ZX_API_PUB: CALCULATE_TAX:ZX_VALID_INIT_PARAMS_PKG.calculate_tax returned errors
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX 1 ZX_API_PUB: CALCULATE_TAX:Calculate_Tax_Pvt returned errors. Return Status: U
The issue can be reproduced at will with the following steps:
1. Navigate to Payable responsibility
2. Invoices > Query the Invoice
3. Actions > Validate the invoice or Run Invoice Validation program.
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 |
| Cause |
| Solution |