My Oracle Support Banner

ItemLocMod Messages Are Reaching SIM For Non-transactional Items (styles) And Failing In MPS (Doc ID 2890346.1)

Last updated on AUGUST 18, 2022

Applies to:

Oracle Retail Integration Cloud Service - Version NA and later
Oracle Retail Store Inventory Management - Version and later
Information in this document applies to any platform.


ItemLocMod messages are coming from RMS and reaching SIM for non-transactional items (styles) and failing in the MPS_STAGED_MESSAGE table due to below error:
- Cannot have orderable item without a primary supplier!

First, these are Modification messages and there is no respective item/loc combination in the STORE_ITEM table because all these messages are related to items with item_level (1) < transaction_level (2). In the STORE_ITEM There are only records for transactional items (transaction_level = item_level). There are no suppliers associated with any of the styles, suppliers are only associated to the SKUs.

Why are these messages being generated and sent from RMS and why is SIM is not discarding these messages?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.