You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create and update Approved Supplier List Entries from Excel

edited Dec 14, 2022 6:25AM in Purchasing 17 comments

Summary:

How to create and update approved supplier list entries using the Oracle Visual Builder Add-in for Excel.

Content (required):

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.  

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!