Items Are Created in SIM with Improper Supplier Data (Doc ID 2265562.1)

Last updated on JUNE 18, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Retail Store Inventory Management (SIM) allows the Item to be created even if the Item's Supplier information is not available yet in SIM.

After the Item's Supplier is integrated, SIM fails to reprocess the ItemCre message due to the following error :


Steps To Recreate :

  1. Create a Supplier (SUP1) from Oracle E-Business Suite (EBS) and let it flow to Retail Merchandising System (RMS).
  2. SUP1 is not yet integrated in SIM due to some issues (For example: the Supplier message in the SIM MPS_STAGED_MESSAGE table was not processed).
  3. From RMS, create an Item (ITM1) for the Supplier (SUP1).
  4. ITM1 flows to SIM, and SIM allows the creation of ITM1 with improper data.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms