R12: AP/EBTax: 'Unexpected Error Occurred During Tax Calculation' When Validating Invoice
(Doc ID 1136013.1)
Last updated on MARCH 07, 2023
Applies to:
Oracle Payables - Version 12.0.4 and laterOracle E-Business Tax - Version 12.0.4 and later
Information in this document applies to any platform.
Symptoms
R12, Encountered ETax problem when validate AP invoice. The following error occurs:
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
Exception: An unexpected error has occurred. Please contact your system administrator.
Please correct the problem or contact your System Administrator
FND log shows:
ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)S
ZX_SRVC_TYP_PKG: CALCULATE_TAX_PVT()- RETURN_STATUS = S
ZX_SRVC_TYP_PKG: DB_INSERT_LINE_DET_FACTORS()+
Inside DB ins line det factors No of records in tbl1, Inside DB First index1, Inside DB Last index1, p_insert_index1
ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated
RETURN_STATUS = U
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX_API_PUB: DUMP_MSG()+
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.
"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.
ZX_SRVC_TYP_PKG: CALCULATE_TAX_PVT()- RETURN_STATUS = S
ZX_SRVC_TYP_PKG: DB_INSERT_LINE_DET_FACTORS()+
Inside DB ins line det factors No of records in tbl1, Inside DB First index1, Inside DB Last index1, p_insert_index1
ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated
RETURN_STATUS = U
ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
ZX_API_PUB: DUMP_MSG()+
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.
"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.
The error details does not match any of the scenarios discussed in below documents:
<Note 1365130.1> - R12: AP: Troubleshooting Note: Invoice Validation: 'Unexpected Error Occurred During Tax Calculation', 'Mandatory constraint violated', APP-SQLAP-10000 ORA-00001
<Note 1307197.1> - R12:PA: Primary Note: Invoice Validation Program Finishes In Error Status. REP-1419: ORA-00001: unique constraint violated
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 |
| Have more questions? |
| References |