Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to create and update Approved Supplier List Entries from Excel — Cloud Customer Connect
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

91
Views
0
Comments
edited Dec 14, 2022 6:25AM in Purchasing

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.  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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