My Oracle Support Banner

Items and Item Locations Created in Retail Merchandising System (RMS) Do Not Always End Up in Store Inventory Management (SIM) (Doc ID 1235954.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.1 to [Release 13.1]
Information in this document applies to any platform.
Checked for relevance Sept 2013


In Oracle Retail Merchandising System (RMS) 13.1, items and item locations created in RMS do not always end up in Store Inventory Management (SIM).  Retail Integration Bus (RIB) appears to miss the publication of approved items in some cases.

Steps to Recreate:

  1. Set up multiple threads for Item publisher.
  2. Have multiple users create/approve items at the same time.
  3. Some items are created and approved at the later point of time.
  4. Note that  few items are not published from RMS.
  5. For items that are not published, the data in table ITEM_MFQUEUE is deleted and in table ITEM_PUB_INFO the publish_ind is set to ‘N’.




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.