My Oracle Support Banner

R12/AP: Datafix - Validate Invoice With Error 'A mandatory constraint to generate unique summary tax line is violated with error ORA-00001' (Doc ID 2490557.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to validate an invoice, the following error occurs.

ERROR
Unexpected error occurred during Tax Calculation.
Exception: A mandatory constraint to generate unique summary tax line is violated with error ORA-00001. Please contact your System Administrator.
Please correct the problem or contact your System Administrator.


Master GDF diagnostic script can identify such issue with Results for Signature ID 411: When invoice exchange rates, dates, or type are modified on an invoice with cancelled tax lines, the change is not reflected in all ZX (EBTax) tables
Pattern # 11 from  <Note: 1152123.1>


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
Cause
Solution
References


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