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 21, 2016

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

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 hundreds of Community platforms