Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

D

Appendix – SIOCS to Merchandising Data Processing Using Background Engine

In addition to scheduling batch jobs using POM batch scheduler, Merchandising additionally provides a Background Engine that specializes in running few types of micro-batch processes requiring 24/7 executions at a high frequency. For micro-batch processes that relies on polling queues every few seconds or minutes, the background engine provides a lightweight solution compared to POM batch scheduler. SIOCS to MFCS import jobs are supported by the Background Engine and background engine should be used instead of POM to consume the transaction from SIOCS. If the SIOCS to MFCS data process jobs are enabled to be run through the background engine, the corresponding jobs in POM jobs should be disabled. Please refer to the reference paper “Publish APIs - Customer Enablement Overview” in KB157214 for additional information on Background Engine.

To enable the jobs to run through the background engine, Merchandising spreadsheet upload/ download functionality should be used for a Template type of “Administration” and a Template of “Background Process Configure”. The following two parameter should be configured for the SIOCS to MFCS batch names:

  • BACKGROUND_RUN_FLAG – Takes a value of Y or N. To enable a job to run using the background engine, set the value to “Y”.

  • BACKGROUND_RUN_INTERVAL_SECOND – This defines the interval in seconds between consecutive execution. On completion of the execution of a job, the engine will wait for this interval seconds before invoking the next run.

EntityBatch Name (Merch_Batch_Params)
Direct Store Delivery ReceiptsSIM_RMS_IMPORT_DSD_RECEIPT_SQL
Fiscal DocumentsSIM_RMS_IMPORT_FDG_SQL
Inventory AdjustmentsSIM_RMS_IMPORT_INVADJ_SQL
Inventory RequestsSIM_RMS_IMPORT_INVENTORY_REQUEST_SQL
Outbound ASNsSIM_RMS_IMPORT_ASNOUT_SQL
PO ReceiptsSIM_RMS_IMPORT_PO_RECEIPT_SQL
Return to VendorSIM_RMS_IMPORT_RTV_SQL
Stock Order ReceiptsSIM_RMS_IMPORT_STOCK_ORDER_RECEIPT_SQL
Stock Order StatusSIM_RMS_IMPORT_STOCK_ORDER_STATUS_SQL
Stock Count ScheduleSIM_RMS_IMPORT_STOCK_COUNT_SCHEDULE_SQL
Stock Order ReviewSIM_RMS_IMPORT_STORE_ORDER_REVIEW_SQL

Note

The Purge jobs and Stock Count Results import job are not supported in the background engine. These must be configured in POM only.

Implementation Guide G56162-01 Copyright© 2026, Oracle and/or its affiliates.

May 8, 2026 Appendix D-1 of D-1


In this guide

  • 5 ReSTful Web ServicesInbound and Outbound Integration Guide · shares BACKGROUND_RUN_FLAG, BACKGROUND_RUN_INTERVAL_SECOND