DSD With Same Item in Multiple Containers is Failing in RMS RIB Subscriber with ORA-00001 Error

(Doc ID 2258168.1)

Last updated on APRIL 26, 2017

Applies to:

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


When a DSD is performed at SIM for same item in multiple containers, DSDReceiptCre is processed by SIM, but this message is getting failed at RMS RIB with unique constraint error. As the SIM created DSD does not add the container details.

Steps To Recreate:

  1. Create DSD in SIM
  2. Create Container1 add item x with 10 qty and confirm
  3. Create Container2 add item x with 15 qty and confirm
  4. Confirm the DSD
  5. Message is processed by SIM (Check MPS_STAGED_MESSAGE)
  6. Message is failed in RMS (Check RMS RIB_MESSAGE) with Error ORA-00001: unique constraint (RMS.PK_ORDAUTO_TEMP).





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