About This Recipe
This recipe integrates Oracle SCM Cloud with KanbanBOX (a third-party application). It complements existing supply-chain management capabilities of Oracle SCM Cloud with additional Kanban-replenishment capability.
Note:
This is a package-based recipe. See About Packages and Edit and Replace Dependent Resources in a PackageThis is an application-driven recipe that creates the necessary purchase orders and work orders in Oracle Fusion Cloud Procurement and Oracle Fusion Cloud Manufacturing (components of Oracle SCM Cloud), respectively, when a Kanban card is released in KanbanBOX. The bin-replenishment requirements in the production line drive the release of Kanban cards in KanbanBOX.
To use the recipe, you must install the recipe package and configure the connections and other resources within the package. And, when you scan a card (or a batch of cards) as released in KanbanBOX, a REST request is sent to Oracle Integration with the necessary cards data to create the corresponding orders. For each card in the request, Oracle Integration creates a purchase order (PO) in Oracle Fusion Cloud Procurement or a work order in Oracle Fusion Cloud Manufacturing, based on the type of request from KanbanBOX. Also, Oracle Integration sends the purchase order and work order information, including status changes, back to KanbanBOX.
The recipe package contains seven integration flows for executing this use case. Initially, a REST request (with necessary data) from KanbanBOX triggers the following two integration flows of the recipe:
- Oracle KanbanBOX ERP PurchaseOrder Create: This flow creates a purchase requisition along with line items in Oracle Fusion Cloud Procurement; the requisition in turn automatically creates a purchase order for each KanbanBOX card. (Each Kanban card makes up one order line in the purchase order). Subsequently, the Oracle ERP KanbanBOX PurchaseOrder Status integration flow listens to the Purchase Order Creation event in Oracle Fusion Cloud Procurement, and propagates the purchase order number to KanbanBOX for each of the Kanban cards (PO lines).
- Oracle KanbanBOX ERP WorkOrder Create: This flow calls the Oracle KanbanBOX ERP Process WorkOrder integration flow to create a work order in Oracle Fusion Cloud Manufacturing for each KanbanBOX card. The Oracle KanbanBOX ERP Process WorkOrder flow creates the work orders and sends the work order numbers back to KanbanBOX.
When the purchase order and work order are fulfilled, the following two integration flows of the recipe are triggered:
- Oracle ERP KanbanBOX PurchaseOrder Receipt: This flow listens to the Purchase Order Receipt event in Oracle Fusion Cloud Procurement, and propagates the receipt status to KanbanBOX for each of the Kanban card receipts.
- Oracle ERP KanbanBOX WorkOrder Status: This flow listens to the Work Order Status Change event in Oracle Fusion Cloud Manufacturing, and propagates the Work Order Completion status to KanbanBOX for each of the Kanban cards.
In addition, the Oracle ERP KanbanBOX ErrorHandler integration flow of the recipe blocks the respective Kanban card if any failures are encountered during work order or purchase order creation.
System and Access Requirements
-
Oracle Integration, Version 22.1.3.0.0 or higher
-
An account on Oracle Integration with the Service Invoker role to configure the recipe
-
Oracle SCM Cloud, Version 21D or higher
-
An account on Oracle SCM Cloud with the Administrator role, and also Procurement Manager and Manufacturing Plant Manager roles (in order to create receipts and close work orders)
-
KanbanBOX
Assumptions
You have installed the REST — Oracle Fusion Applications | Invoke Pop-Up Notifications recipe on your Oracle Integration instance. You’ll require this recipe to send the notification information to Oracle SCM Cloud when work orders and purchase orders are created.
To install the recipe, see Invoke Pop-Up Notifications for Events in Oracle Fusion Applications.