R12 AP Invoice Calculate Tax Error After Manually Updating Tax Rate Code: Payables could not calculate tax due to: A mandatory constraint to generate unique summary tax line is violated with error ORA-00001. Please contact your System Administrator. (Doc ID 1907389.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Payables - Version 12.0.0 to 12.2.3 [Release 12.0 to 12.2]
Oracle E-Business Tax - Version 12.0.0 to 12.2.3 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

After clicking 'Calculate Tax' on the AP invoice workbench against an invoice whose Item lines with applicable tax were discarded and a new Item line with applicable tax entered, the following error occurs:

Error message
Payables could not calculate tax due to: A mandatory
constraint to generate unique summary tax line is violated
with error ORA-00001. Please contact your System
Administrator.

Steps to reproduce
1. Created invoice header
2. Entered three lines
3. Calculated tax
4. Discarded all lines
5. Entered new line
6. Calculated tax - get the error

As advised by Oracle in Note 1152123.1, the Generic Data Fix (GDF) Patch 14700514:R12.ZX.B was applied and the create/select/fix scripts were executed. But the select script 'zx_sync_tax_rate_pop.sql' did not select any data.

Business impact
Unable to complete invoice - holding up supplier payments.

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