APP-SQLAP-97731: A mandatory constraint to generate unique summary tax line is violated with error ORA-00001
Last updated on JULY 25, 2017
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
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.
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