REST APIs (Inbound)

Use the REST APIs inbound integration option to integrate with Oracle Self Service Procurement if your business process requires near real-time updates to your data.

The REST APIs enable you to view, create, update, or delete records for your real-time integration requirements.

Key Features

  • Use REST APIs for real-time integration requirements.
  • Perform CRUD operations on both single-item and collection.
  • Perform BATCH operations to perform multiple updates, and INSERT, DELETE, and GET operations in a single call.
  • Perform custom actions to quickly derive key values, expedite data entry, and perform certain validations.
  • Use REST APIs to achieve end-to-end process orchestration.

Best Practices

  • Use this option if you need to perform near real-time mode operations in Oracle Self Service Procurement.
  • For better performance, limit the attributes using the fields query parameter while performing a GET operation whenever it's supported.
  • For large requisitions, limit the number of lines per requisition to the 500 maximum.
  • We don't expect you to have hundreds of distributions per requisition line. For better performance when handling large requisitions, consider splitting the line if more than 100 distributions are required per line.
  • After performing a POST operation to create requisition lines, it's recommended that you execute the custom actions to:
    • Create default distributions.
    • Retrieve source document and transfer price.
    • Calculate tax and derive charge account.

Constraints

  • The REST APIs don't allow the return of more than 500 records in a single call. You can paginate through the entire set using offset and limit in the REST API parameters.
  • The custom actions you can perform on requisitions are limited to 500 lines.
  • You can only use the Cancel custom action to cancel requisition lines that aren't placed on purchase orders or transfer orders.