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.
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:
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
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.
Unable to complete invoice - holding up supplier payments.
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