1. Integration Playbooks for SCM
  2. REST APIs (Inbound)

REST APIs (Inbound)

Use the REST APIs inbound integration option to import transactions into Oracle Fusion Cloud Inventory Management if your business process requires near real-time updates to your inventory data.

Using the REST API inbound integration option might be appropriate if your business process needs to integrate with 3PL or WMS systems or you need to import reservations from a third-party system.

Example scenarios:

  • If you have a coexistence manufacturing execution scenario where your Manufacturing Execution System (MES) is integrated with Oracle Fusion Cloud Manufacturing for manufacturing execution.
  • If 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 integrations.
  • Used with Oracle Integration Cloud (OIC) to perform near real-time operations in Oracle Inventory Management.

Best Practices

  • Use this option only if you need to perform near real-time mode operations in Oracle Inventory Management.
  • If you working with a high-volume data set:
    • Call the REST API in a smaller set of records. A REST API can experience a 504-gateway timeout if a request runs for more than 5 minutes.
    • Only use the REST API to stage the data to the staging tables. Then, process the data using the corresponding scheduled process. This can be done for REST APIs that support the separation of steps for staging and processing of data.
  • Purge the staging records periodically. We also recommend that you review the staging table records for any errors and take the required actions to re-process the records.
  • For Reservations processing, use the InventoryStagedReservations REST API. Allow the insert to happen in the interface. Schedule and run the Manage Reservations Interface scheduled process in the background every 30 minutes (or more often).

Constraints

  • This option isn't suitable for importing a large volume of inventory data.
  • Call the REST APIs in a smaller set of records if working with a high-volume data set.

REST APIs for Inbound Integration

Oracle Inventory Management provides several REST APIs for inbound integration.

Object Description REST API
Inbound Receipts Receives and processes receipt confirmations to acknowledge the receipt of material, updates the source documents and available details for quantities and other related information, such as lots, serials, external packing units, and the return of rejected material.

ReceivingReceiptRequests - Creates a receipt of material

ReceivingReceiptTransactionRequests - Performs inspect, put away, correct, and return for the received material.
Inbound Shipments Confirms the shipments executed in the external system (3PL/WMS).

shipmentTransactionRequests (ActionCode: CreateAndConfirmShipment)

shipmentLineChangeRequests (custom action: backorderLine)
Miscellaneous Inventory Transactions Processes inventory adjustments from an external system. inventoryStagedTransactions
Inbound Manufacturing Picks Receives the details of the picked manufacturing or maintenance work order transactions from the external system. interfacedPickTransactions
Synchronize Inventory Balances Receives and processes inventory balance updates from an external system. inventoryBalanceTransactions
Inbound Reservations Receives Reservation requests from an external system. InventoryStagedReservations