REST APIs (Inbound)

You can use Oracle REST APIs to integrate with Oracle Sourcing.

A comprehensive set of REST APIs are available for customers and integration-system architects to view, create, update, or delete records for their real-time integration requirements.

Key Features

• Use Oracle Sourcing REST resources and REST APIs for real-time inbound integration requirements. For example:
  • Supplier Negotiations
  • Draft Supplier Negotiation Responses
  • Supplier Negotiation Responses
• Supports standard create, read, update, delete (CRUD) operations on both single-item and collections. For more information, see CRUD Tasks in Accessing Business Objects Using REST APIs.
• Supports BATCH operation on sourcing business objects, enabling you execute multiple updates and perform post, delete, and get operations in a single call.

• Along with CRUD operations, Oracle Sourcing also supports custom actions. For example:

  • Create Negotiation from Template
  • Create Amendment and New Round
  • Unlock and Unseal Locked Negotiation
  • Renumber Lines
  • Validate and Submit Responses

Best Practices

• Use Oracle Sourcing REST APIs to support real-time inbound integration of third-party applications.
• For better performance, limit the attributes using the fields query parameter while performing a GET operation whenever it's supported.
• Ensure the content type and REST API versions are correctly specified for the POST and PATCH actions and for custom actions.
• You can use the POSTMAN client to execute all standard CRUD and custom actions.
• When bulk uploading the same children and grandchildren to the negotiations using the Oracle Visual Builder plug-in for Microsoft Excel follow these steps:
  1. Upload the same section to all the negotiations. This will generate a unique section ID for all the sections of the different negotiations.
  2. Upload the same requirement to the above sections using the Negotiation Title/Number and Section ID attributes. Because it's unique, use Section ID instead of Section Name.

Constraints

• All Oracle Sourcing REST APIs don't allow the return of more than 500 records in a single call. You can paginate through an entire set using the offset and limit in REST API parameters.
• You can execute custom actions with the scalar data type in the Oracle Visual Builder plug-in for Microsoft Excel. For example, the supported custom actions in Oracle Visual Builder are RenumberLine, UnlockSupplierNegotiation, and UnsealSupplierNegotiations.
• You can't execute custom actions with the complex or map data type for a request and response payload in the Oracle Visual Builder plug-in for Microsoft Excel. For example, CreateAmendment, CreateNewRound , CreateNegotiationFrom Template, CreateResponse, and ValidateAndSubmitNegotiationResponse.
• You can't bulk update the same children and grandchildren to a negotiation using Oracle Visual Builder in a single upload.