Deactivate supplier sites in bulk any API ? or update command ?
We are on 12.1.3 and have a case where we need to end-date existing supplier sites in system based on particular vendor_site_id. As the number is greater than 10K, we cannot do it manually.
However, in our opinion, we would like to write a script to select particular vendor_site_id's (based on our requirement) and simply use the UPDATE command to end-date the same (like below).
UPDATE apps.ap_supplier_sites_all
set inactive_date = sysdate
where vendor_site_id in (select distinct vendor_site_id from etc... query follows).
We would like to have experts confirmation if we can do it simply using above query (or) should we go with an API only for this also ?