R12:AP:ZX: Invoice Validation APP-SQLAP-97731 ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated (Doc ID 2188005.1)

Last updated on SEPTEMBER 29, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Invoice cannot be validated. Following error appears:

APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed due to following error:
An unexpected error occurred. Please contact your system administrator

Error message from FND Log:

ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt -1: ORA-00001: unique constraint (ZX.ZX_DETAIL_TAX_LINES_GT_U1) violated
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt.END ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt Incorrect return_status after calling ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt RETURN_STATUS = U
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt.END ZX_TDS_CALC_SERVICES_PUB_PKG.dump_detail_tax_lines_into_gt(-)
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines Incorrect return_status after calling dump_detail_tax_lines_into_gt()
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines RETURN_STATUS = U
ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines.END ZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines(-)
ZX.PLSQL.ZX_SRVC_TYP_PKG.IMPORT ZX_SRVC_TYP_PKG: IMPORTZX_TDS_CALC_SERVICES_PUB_PKG.prorate_imported_sum_tax_lines returned errors
ZX.PLSQL.ZX_SRVC_TYP_PKG.IMPORT User-Defined Exception
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.BEGIN ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+
ZX.PLSQL.ZX_GLOBAL_STRUCTURES_PKG.DELETE_TRX_LINE_DIST_TBL.END ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX ZX_API_PUB: IMPORT_DOCUMENT_WITH_TAX:ZX_SRVC_TYP_PKG.import returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 0 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN ZX_API_PUB: DUMP_MSG()-
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics Start Time :20-09-2016 14:49:58
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics End Time :20-09-2016 14:50:03
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics Total Time :0:0:5
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics Number of records in ZX_TRX_HEADERS_GT :1
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics Number of records in ZX_TRANSACTION_LINES_GT :3
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics Number of records in ZX_IMPORT_TAX_LINES_GT :4
ZX.PLSQL.ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX.Statistics Number of records in ZX_TRX_TAX_LINK_GT :4
AP.PLSQL.AP_ETAX_SERVICES_PKG.Calculate Handle errors returned by API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from eTax API
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages Get error message from stack
AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages An unexpected error has occurred. Please contact your system administrator.
fnd.src.dict.afdict.afdautolog.auto_log SQLAP?AP_ETX_CALC_TAX_FAILED?N?REASON?An unexpected error has occurred. Please contact your system administrator.?

Changes

Invoice is imported with tax lines

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