My Oracle Support Banner

When an Appointment Flowing from RWMS to RMS Fails, Then Subsequent Appointments (Even Valid Ones) Fail With the Same Error (Doc ID 1952539.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Retail Merchandising System - Version to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


After an appointment message from Retail Warehouse Management System (RWMS) to Retail Merchandising System (RMS) fails in the RMS error hospital, other subsequent appointment messages also fail with the same error.  This continues until the ewReceivingToRMS e*Way is bounced.  The error that generated this situation is:


Steps to Reproduce:

  1. Receive multiple appointments at warehouse.  Make sure they error out in RMS Hospital (e.g., have more than one appt_detail with the same item and PO for one appt_nbr - this will generate a 'unique constraint violated' error).
  2. Note that the other appointments, even though they are valid, also error out in the hospital with the same constraint error.


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.