My Oracle Support Banner

DSD With Same Item in Multiple Containers is Failing in RMS RIB Subscriber with ORA-00001 Error (Doc ID 2258168.1)

Last updated on FEBRUARY 26, 2019

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).





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.