My Oracle Support Banner

R12: AP/EBTax: 'Unexpected Error Occurred During Tax Calculation' When Validating Invoice (Doc ID 1136013.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle Payables - Version 12.0.4 and later
Oracle 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

 
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.

 
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


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