Integrate and Extend Procurement Using REST Resources

In this update, Oracle Fusion Cloud Procurement and Oracle Fusion Cloud Self Service Procurement deliver new and modified REST resources to enable and simplify integration with external systems.

The new REST resources introduced in this update are:

• Purchasing Document Styles List of Values
• Purchasing UN Number List of Values
• Purchasing Hazard Classes List of Values

The following REST resources were previously available, and have been updated:

• Purchase Requisitions
  • POST, PATCH, and SUBMIT are supported for the emergency purchase order number request.
  • POST, PATCH, and SUBMIT are supported for consignment blanket purchase agreement reference.
  • Use the viewPDF custom operation to download PDF content of one requisition in Base64 format.
• Draft Purchase Orders
  • PATCH is supported for the following attributes for both draft and open purchase orders:
    • Header attributes: Description, Required Acknowledgement, Acknowledgement within Days, Communication Method, Email, Fax, Cc, Bcc, Default Ship-to Location, Bill-to Location, Buyer, Buyer Email, Pay On Receipt, Payment Terms, Freight Terms, FOB, Carrier, Mode of Transport, Service Level, Note to Receiver, Note to Suppler, Supplier Order, and Confirming Order.
    • Line attributes: Line Number, UN Number, and Hazard Class.
    • Schedule attributes: Schedule Number, Receipt Routing, Allow Substitute Receipts Flag, Accrue At Receipt Flag, Invoice Close Tolerance Percent, Receipt Close Tolerance Percent, Invoice Match Option, Match Approval Level, Country of Origin & Supplier Order Line Number, Carrier, Mode of Transport, Service Level, Early Receipt Tolerance in Days, Late Receipt Tolerance in Days, Over Receipt Tolerance Percent, Over Receipt Action, Receipt Date Exception Action, and Ship To Exception Action.
    • Distribution attribute: Distribution Number.
  • PATCH is supported for the following attributes for draft purchase orders:
    • Header attributes: Currency, Conversion Rate, Conversion Rate Type, and Conversion Rate Date.
    • Line attributes: Category and UOM.
    • Distribution attributes: Conversion Rate and Conversion Rate Date.
  • Use the View PDF custom action to retrieve the PDF content for draft purchase orders.
  • Use the Validate custom action to view the validation errors or warnings before submitting the purchase order or it’s changes.
• Purchase Order Schedules
  • GET is now supported for draft purchase orders.
• Purchase Orders
  • GET is supported for the following attributes (to support the redesigned View Purchase Order page):
    • Header attributes: Order Date, Frozen Flag, First Party Tax Registration Number, First Party Registration ID,Third Party Tax Registration Number, Third Party Tax Registration ID, Taxation Country, Taxation Country Code, Document Fiscal Classification, Document Fiscal Classification ID, and Document Fiscal Classification Code.
    • Line attributes: UN Number Code.
    • Schedule attributes: Supplier Order, Supplier Order Line, Customer Item, Customer Item Description, Ship-to Customer Contact, Ship-to Customer Contact ID, Customer Sales Order Line, Customer Sales Order Schedule, Customer Purchase Order, Customer Purchase Order Line, Customer Purchase Order Schedule, Firm, Product Fiscal Classification, Product Fiscal Classification ID, Product Fiscal Classification Code, Product Type, Product Type Code, Product Category, Product Category Code, Assesable Value, Intended Use, Line Intended Use ID, User-Defined Fiscal Classification, User-Defined Fiscal Classification Code, Tax Classification, Tax Classification Code, Location of Final Discharge, Local of Final Discharge ID, Transaction Business Category, Transaction Business Category ID, and Transaction Business Category Code.
  • Use the Duplicate custom action to copy a purchase order, including its header, lines, schedules, distributions, contract terms, and attachments.
  • Use the Hold custom action to place a purchase order on hold, preventing receiving and invoicing until the hold is released.
  • Use the Remove Hold custom action to release a purchase order from hold status, allowing receiving and invoicing to resume.
  • Use the Communicate One Purchase Order custom action to send a purchase order by email, fax, or print.
  • Use the Reopen custom action to reopen a purchase order or purchase order schedule according to the selected reopen action. Reopen actions include Reopen for Receiving, Reopen for Invoicing, Reopen, and Reopen Finally Closed.
• Questionnaire Responses
  • GET and PATCH are supported to view and update supplier questionnaire responses.
  • Use the Populate Responses custom action to generate, validate, and submit supplier questionnaire responses.

You can use these new and modified REST resources to simplify integrations and support standards-based interoperability with your other applications and external systems.

Steps to Enable

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.

Key Resources

• Refer to the REST API for Oracle Fusion Cloud Procurement documentation, available on the Oracle Help Center.

Access Requirements

Refer to the Privileges section in the REST API for Oracle Fusion Cloud Procurement documentation, available on the Oracle Help Center.