1. Integrate Oracle Fusion Cloud SCM Master Data with Oracle MICROS Inventory Management
  2. About This Recipe
  3. Overview

Overview

This recipe integrates SCM with Inventory Management.

In a centralized Supplier Onboarding and Product Lifecycle Management implementation using SCM, these recipe integrations will automate the Supplier and Item Synchronization to Inventory Management.

This is an event-driven integration that creates suppliers/vendors and items in Inventory Management when a supplier or item is created and approved in SCM.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package. Complete SCM configurations related to Supplier Onboarding and Item Creation before using the recipe.

The recipe package contains three integration flows.

  1. Oracle SCM to Oracle MICROS IM Supplier Sync

    This integration listens to a new supplier update event in SCM and is triggered on the occurrence of the event.

    The integration orchestration:

    • Matches and looks for specific values in the fields Status, BusinessRelationShipCode and CreationSource to filter the records to be processed to the downstream system.

    • Fetches additional supplier and vendor details from SCM Procurement.

    • Triggers Oracle SCM to Oracle MICROS IM Master Data Sync to create or update suppliers and vendors in Inventory Management.

  2. Oracle SCM to Oracle MICROS IM Item Sync

    This integration listens to a new item or update event from Oracle Product Lifecycle Management Cloud and is triggered on the occurrence of the event.

    The integration orchestration:

    • Matches and looks for specific values in the fields ItemStatusValue, ApprovalStatusValue, ItemCategoryAssignmentId, and CategoryName to filter the records to be processed to the downstream system.

    • Triggers Oracle SCM to Oracle MICROS IM Master Data Sync to create or update items in Inventory Management.

  3. Oracle SCM to Oracle MICROS IM Master Data Sync

    This integration has two verbs configured to create or update supplier/vendor and item master data in Inventory Management using SOAP APIs. Each verb is configured to receive request payloads based on the respective SOAP WSDL operation being performed.

    • This integration is invoked by the previous two integrations (Oracle SCM to Oracle MICROS IM Supplier Sync and Oracle SCM to Oracle MICROS IM Item Sync) to synchronize the suppliers/vendors and items from SCM to Inventory Management.

    • Because the integration design uses verbs, the implementer of this recipe could extend this integration to incorporate additional data elements supported by the inventory management master data web service.

Note:

The sample implementation given synchronizes supplier/vendors and items, and relies on a manual mapping for Groups and Units of Measure. See Configure the Lookup Tables for more information. Unless the recipe is extended to also synchronize Over Groups, Major Groups, Item Groups, and Units, these definitions need to be inserted through the IM Master Data API and the mapping described needs to be maintained manually.

Parent topic: About This Recipe