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 AUGUST 16, 2021

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.


The output of the "Master GDF Diagnostic (MGD) Analyzer To Validate Data Related To Invoices, Payments, Accounting, Suppliers And EBTax" executed for the problem transaction identifies such issue as:

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>

 

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
References


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