R12: E-Business Tax/Payables Data-Fixes: Cause and action to handle ZX_LINES_SUMMARY_U1 issue / ORA-00001

(Doc ID 1152123.1)

Last updated on APRIL 28, 2018

Applies to:

Oracle E-Business Tax - Version 12.0.0 to 12.2.5 [Release 12.0 to 12.2]
Oracle Payables - Version 12.0.0 to 12.2.5 [Release 12.0 to 12.2]
Information in this document applies to any platform.


E-Business Tax (EBTax) Information Center > EBTax Integration With EBS Modules > Payables > Note 1152123.1

When validating the Payables Invoice through the invoice workbench/submitting the Invoice validation concurrent program or when modifying an invoice and recalculating tax; user gets

A mandatory constraint to generate unique summary tax line is violated with error ORA-00001. Please contact your System Administrator.


Unexpected Error occurred during Tax Calculation.
Exception: User-Defined Exception.
Please correct the problem or contact your System Administrator.

FND Debug Log shows following error:



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