Knowledge Article:Create & Update Purchase Order & Change Order with Project DFF using Oracle VBCS

Summary

The Oracle Visual Builder Add-in for Excel integrates Microsoft Excel spreadsheets with REST services to retrieve, analyze, and edit business data from the service.

Attached is an unpublished Visual Builder Excel template for Draft Purchase Orders REST API with pre-populated attributes including the Projects DFF. You can use this template to create and update purchase orders with project information. Note that some of the columns are hidden in the template, but you can display them from within the excel workbook. You can use this template as is, or as a starting point for a new template tailored for your requirement, and publish it to your end users. This template can also handle downloads of purchase orders and as well as updates to draft and open purchase orders.