How to update Supplier information using API in Oracle EBS R12?

Is any way to run a supplier mass update from backend?

I bet this question was raised many time to E-Business Suite support team few months after go live. More over when data was migrated from a legacy system and cleaning activity was completed under time pressure.
Answer is yes, it’s possible to run a mass update as Oracle EBS provides APIs for supplier master data and also for supplier site level.

The API name is AP_VENDOR_PUB_PKG
· Create_Vendor
· Update_Vendor
· Create_Vendor_Site
· Update_Vendor_Site
· Create_Vendor_Contact
· Update_Vendor_Contact
· Update_Address_Assignments_DFF

In this video you can see the way AP_VENDOR_PUB_PKG.Update_Vendor may be used to update below fields:

Supplier type

Quantity Received Exception

Terms Date Basis and Pay Group

Inactive Date

Demo
 
If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address