1. Integrate Oracle Fusion Cloud SCM Master Data with Oracle MICROS Inventory Management (OIC3)
  2. About This Recipe

1 About This Recipe

Use this recipe to create Suppliers/Vendors and Items in Oracle MICROS Inventory Management (IM) as soon as they are created in Oracle Fusion Cloud SCM (SCM) Product Lifecycle Management.

Note:

This recipe is available as Oracle Fusion Cloud SCM — Oracle MICROS Inventory Management | Master Data Synchronization in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance and is not warranted to be error-free. No support is provided for this recipe.

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. Any SCM configurations related to Supplier Onboarding and Item Creation should be completed before using the recipe.

The recipe package contains three integration flows:

  • Oracle SCM to Oracle MICROS IM Supplier Sync: This integration listens to a new supplier update event in SCM and gets triggered on the occurrence of the event.

    The integration orchestration:

    • matches/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/vendor details from SCM Procurement

    • triggers Oracle SCM to Oracle MICROS IM Master Data Sync to create or update suppliers/vendors in Inventory Management

  • 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 gets triggered on the occurrence of the event.

    The integration orchestration:

    • matches/looks for specific values in the fields ItemStatusValue, ApprovalStatusValue, ItemCategoryAssignmentId, 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.

  • Oracle SCM to Oracle MICROS IM Master Data Sync: This integration has 2 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 above integrations (Oracle SCM to Oracle MICROS IM Supplier Sync and Oracle SCM to Oracle MICROS IM Item Sync) for synchronizing the Suppliers/Vendors and Items from SCM to Inventory Management.

    • Since the integration design uses verbs, 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. For more information, see the following section.

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 below described mapping needs to be maintained manually.

Parent topic: About This Recipe

System and Access Requirements

  • Oracle Integration Cloud, Version 22.1.3.0.0 or higher

    An account in Oracle Integration Cloud with the Service Invoker role to configure the recipe

  • Oracle Fusion Cloud SCM, Version 21D or higher

  • Oracle MICROS Inventory Management, Version 9.1

Parent topic: About This Recipe

Assumptions

  • Master data configurations such as procurement Items, Categories, UOMs, and Suppliers are already performed in SCM.

  • This recipe currently handles Suppliers/Vendors and Item Master Data only. Recipe consumers can choose to expand the Oracle SCM to Oracle MICROS IM Master Data Sync integration to expose more Inventory Management Master Data elements based on their requirement (like Units of Measure, Price Quotes, Grouping Hierarchy).

  • Recipe integration includes the minimal data mapping required to synchronize the data. Recipe consumers can have additional mappings based on their requirements.

  • The recipe includes an example implementation of validations which can be modified as required.

  • OIC lookups are used to store environment specific values/configurations and cross references. Recipe consumers can choose to either retrieve the values using additional invokes or continue to use the lookups as per the requirements.

  • Recipe integration includes sample error handling and notifications. A robust error handling based on customer needs has to be implemented by the recipe consumer.

  • The Oracle SCM to Oracle MICROS IM Supplier Sync integration, in its current design, processes a supplier only if it is “Active” and “Spend Authorized” in SCM.

  • It is assumed that a supplier registration process for a prospective supplier is implemented in SCM. The Procurement Manager needs to have the relevant roles to approve a new supplier and promote them to “Spend Authorized” status.

Parent topic: About This Recipe