Oracle R12 Tax: The same tax conditions already exist in another tax condition set error

If you get the following error;

Oracle tax r12

The same tax conditions already exist in another tax condition set

Row 3 Error – The same tax conditions already exist in another tax condition set: CA S2 NULL B2 BC within this determining factor set. Please update the tax conditions to differentiate the details from the existing record.

 

 

 

 

You have either duplicated your condition set as the error indicates or you have simply been caught up in an Oracle bug!

To get around the issue, you have to do a little trick, the steps are as follows.

1. Enter the tax condition and save your work – you will get the error.

oracle r12 save complete

You get the error

 

2. Set all values to be disabled to allow you to at least save the condition

Oracle R12 eBTax

Click on all the Ignore conditions

 

3. Click to any other tax category other than ‘Tax Condition Set’. So for example click on the ‘Tax Formulas’

ORACLE TAX TAX FORMULA

4. Now click back to ‘Tax Conditions’ where you were before.

 

5. re-query your condition as sown above and click on update.

6. update condition again, you get same error

Oracle tax r12

7. But instead of changing the value back so the ignore condition is selected on every line, click cancel, this returns you top the previous screen

oracle r128. click update again (do not refresh)

9. make your corrections as before.

Oracle R12 etax conditions

10. Save the Condition and you will see that is updates successfully.

oracle tax condition complete

11. This time it is successful!

 

Andrew Bohnet
Follow Us

Andrew Bohnet

Managing Director and Oracle Fusion Tax / eBTax expert at eBiz Answers Ltd
Andrew Bohnet is the current chair for the Oracle Tax Management SIG. He founded eBiz Answers to offer clients complete tax solutions making the most of the rich functionality of the R12 and Fusion tax modules. Whether it is analysis, design, configuration or support, eBiz Answers provide an unparalleled service when it comes to a complete tax solution. Having worked on one of the first Oracle R12 implementations in Europe, Andrew was exposed to the tax module early on and worked closely with Oracle to fix bugs, enhance functionality and present on numerous occasions on the subject of tax and Oracle. When it comes to presenting on eBTax, you wont find a more experienced consultant outside of Oracle.
Andrew Bohnet
Follow Us