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 JULY 23, 2018
Applies to:Oracle Retail Merchandising System - Version 126.96.36.199 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:
(RETEK.UK_APPT_DETAIL) violated returned by program unit APPOINTMENT_PROCESS_SQL.FLUSH_APPT_DETAIL.
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.
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