REST APIs (Inbound)

Use the REST APIs inbound integration option to import work order transactions into Oracle Fusion Cloud Manufacturing if your business process requires near real-time updates to your manufacturing data.

For example:

  • If you have a coexistence manufacturing execution scenario where your Manufacturing Execution System (MES) is integrated with Oracle Manufacturing for manufacturing execution.
  • You need near real-time updates of material and resource usage recorded in the MES in Oracle Manufacturing.

Key Features

  • Performs data updates in real time.
  • Used for both inbound and outbound integration.
  • Used with Oracle Integration Cloud (OIC) to perform near real-time operations in Oracle Manufacturing.

Best Practices

  • Use this option only if you need to perform near real-time mode operations in Oracle Manufacturing.
  • Call the REST API in a smaller set of records if the data set is very high. A REST API can experience a 504-gateway timeout if a request runs for more than 5 minutes.

Constraints

  • This option isn't suitable for importing a large volume of manufacturing data.
  • It can't be used to trigger Electronic Records and Electronic Signatures (ERES) events related to manufacturing.
  • There might be instances of inconsistent performance in near real-time implementations.

REST APIs for Inbound Integration

Oracle Manufacturing provides several REST APIs for inbound integration.

Note: Not all REST APIs are shown in the table.
Entity Description
Discrete Work Orders Creates, updates, reschedules, or resequences discrete work orders.
Process Work Orders Creates, updates, reschedules, or resequences process work orders.
Production Resources Creates, updates, or deletes production resources.
Production Reports Manages the operation and material transactions for a contract manufacturing work order.
Standard Operations Creates, updates, or deletes standard operations
Work Areas Creates, updates, or deletes work areas.
Work Centers Creates, updates, or deletes work centers.
Work Order Material Transactions Creates work order material transactions, transactions with no orders, and output transactions for discrete and process work orders.
Work Definition Requests Create work definition headers, operations, resources, alternate resources, materials, and outputs.
Work Order Operation Start Stops Creates, updates, or deletes work order operation starts and stops.
Work Order Operation Transactions Creates work order operation transactions.
Work Order Resource Transactions Creates work order resource transactions.
Work Order Statuses Creates work order statuses.

Oracle Visual Builder Add-In for Microsoft Excel

You can use the Oracle Visual Builder Add-in for Excel that enables Excel users to edit and manage business data using REST APIs. For more information, see Oracle Visual Builder Add-in for Excel, Version 3.8.0.