Oracle R12 – SQL to delete unwanted tax rates and tax statuses

How to delete tax rates and statuses from the back end

Here is the thing, you have just set up a country in eBTax, the full regime to rate then realised you need to change the naming convention but have all these rates and statuses in the system. Rates can be deleted but statuses cannot be so whlst there won’t be any logical issues, having old data int eh system is not great from a cosmetic point of view. So, a simple way of clearing out old statuses and rates is to do the following.

Step 1.

End date all the statuses that you no longer need

Step 2.

run the following scripts, putting in the Tax Regime where you have made the changes. Make sure you run them in this order.

Continue Reading