APP-SQLAP-97731: A mandatory constraint to generate unique summary tax line is violated with error ORA-00001 (Doc ID 2100953.1)

Last updated on JULY 25, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

In R12: Oracle Payables, when a user attempts to click on invoice distributions button the following error occurs:

APP-SQLAP-97731: The system cannot generate distributions because tax calculation failed dur to the following error:
A mandatory constraint to generate unique summary tax line is violated with error ORA-00001. Please contact your System Administrator.

The issue can be reproduced at will with the following steps:

1. Using Payables Manager responsibility

2. Navigate to Invoices : Invoices > Entry > Invoice

3. Query the invoice and Click the invoice distributions button tab.

4. The error is shown.

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