R12: EBTax: "A mandatory constraint to generate unique summary tax line is violated with error ORA-00001" during invoice validation (Doc ID 1609784.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

When a user attempts to validate invoice using the Invoice Validation Concurrent Program the following error occurs:

ERROR
-------
Invoice Validation did not process Invoice Id Due to Tax Error:XXXXX, Line Number:
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.


STEPS OR EVENTS THAT LEAD TO THE ISSUE OCCURRING
----------------------------------------------------------------
The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Other > Requests

3. Click on Single Request

4. Enter Request Name (Invoice Validation)

5. Enter Parameters

6. Click Ok

7. Click on Submit

Cause

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