My Oracle Support Banner

R12: AP: Credit Memo Error: Mandatory Constraint to Generate Unique Summary Tax Line is violated with error ORA-00001 (Doc ID 2686643.1)

Last updated on JULY 01, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, Invoice Issues

Unable to calculate tax on credit memo invoice

ERROR
-----------------------
Payables could not calculate tax due to: A mandatory constraint to generate unique summary tax line is violated with error ORA-00001

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to calculate tax
2. Error appears

BUSINESS IMPACT
-----------------------
The issue has the following Business Impact: Customer relationship with the Supplier and Company credibility are affected. The issue is preventing invoicing that stops users from correctly reporting the liability.
The issue has the following Financial Impact : Due to this issue, users are not able to pay the supplier.


WHAT IS WORKING
-----------------------
Other invoices don't have any issues.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution


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