My Oracle Support Banner

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 JUNE 04, 2018

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

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:7903117, 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

To view full details, 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 a vibrant support community of peers and Oracle experts.