How to create and update Approved Supplier List Entries from Excel
How to create and update approved supplier list entries using the Oracle Visual Builder Add-in for Excel.
Starting from Update 22C, Oracle Purchasing provides two new REST APIs:
- Procurement Approved Supplier Lis Entries
- Approved Supplier List Source Documents
In combination with the Oracle Visual Builder Add-in for Excel, these APIs can be used to query, create, and update approved supplier list entries and associated source documents from Excel. To this end, Oracle is providing two unpublished Visual Builder Excel templates with pre-populated attributes from these REST APIs.
Some columns are hidden but you can display them from the excel workbook. You can use these templates either as is or as a starting point to create new templates tailored to your organization’s needs, which you can then publish to your end users. Publishing creates a copy of the workbook with the design tools hidden and worksheet protection turned on for each worksheet with a layout.