Payables and Cash Management - EBS (MOSC)

MOSC Banner

Deactivate supplier sites in bulk any API ? or update command ?

edited Feb 19, 2020 9:56AM in Payables and Cash Management - EBS (MOSC) 17 commentsAnswered

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center