Overview

This recipe integrates Inventory Management with SCM Procurement.

It enables customers to centralize orders across all locations. Consolidated Purchase Orders provide greater purchasing power to the organization during supplier negotiations.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package.

Every booked Order in IM generates a Purchase Order Flat file in the configured File Server location. This schedule driven recipe reads each file, creates a consolidated Purchase Requisition Import file, and imports the file into SCM using the service integration APIs. It also executes an Enterprise Scheduler (ESS) job to generate a consolidated purchase order in SCM for the imported requisitions.

This recipe listens to the Requisition Import event, processes the response generated by SCM against the previous requisition request, and generates an acknowledgement file based on success or failure of IM Orders.

The recipe package contains three integration flows.

  1. Oracle MICROS IM Orders to SCM Requisitions

    The scheduled integration connects to the configured FTP server and downloads the order files created by IM.

    The integration then creates a requisition header interface file, a requisition line file, and a properties file based on the downloaded files. Then it invokes the Requisitions bulk data import process with these files using the ERP adapter.

    Finally, it invokes the Oracle ERP Launch ESS Job integration.

  2. Oracle SCM Order Status to Oracle MICROS IM

    This integration processes the requisition import and creates acknowledgement files based on the headers of successfully processed requisitions. It then uploads the Acknowledgement file to the configured IM FTP Server.

  3. Oracle ERP Launch ESS Job

    This is an application-driven integration which is triggered by the Oracle MICROS IM Orders to SCM Requisitions. It launches the Generate Purchase Order ESS job in SCM based on the job parameters received as the input payload.