When an Appointment Flowing from RWMS to RMS Fails, Then Subsequent Appointments (Even Valid Ones) Fail With the Same Error
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising System - Version 220.127.116.11 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:
- 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).
- Note that the other appointments, even though they are valid, also error out in the hospital with the same constraint error.
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