R12: AP: 'Unexpected Error Occurred During Tax Calculation' When Validating Invoice

(Doc ID 1136013.1)

Last updated on FEBRUARY 20, 2018

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: Master Note: Invoice Validation: 'Unexpected Error Occurred During Tax Calculation', 'Mandatory constraint violated', APP-SQLAP-10000 ORA-00001

<Note 1307197.1> - R12: Master Note: Invoice Validation Program Finishes In Error Status. REP-1419: ORA-00001: unique constraint violated

Changes

 

Cause

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 hundreds of Community platforms