Updating AP_SUPPLIER_SITES.VAT_CODE using a SQL SCRIPT.
Hello
We need to update en masse the vat_code for the supplier sites. Our current code includes the vat rate as part of the code and as our rate will change on 1/1/2014 having a rate as part of the code is confusing. In short we need to change 8000 supplier site records from the VAT_CODE = 'FFR_196ABS' to the VAT_CODE='FFR_NORM.ABS'.
Oracle do not support a mass change using SQL to do this.
We cannot find an API written by Oracle which updates the AP_SUPPLIER_SITES_ALL table.
We need to know if this update is possible using SQL? Is the VAT_CODE duplicated somewhere in eTax? If so , where?
0