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 AUGUST 17, 2016

Applies to:

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

Symptoms

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.

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