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 OCTOBER 30, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation 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.
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>
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 |