My Oracle Support Banner

Receiving Messages Failing With "integrity Constraint (RMSPRD.APD_APH_FK) Violated" Error (Doc ID 1676230.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.


Appointment messages coming into RMS are failing with "integrity constraint" error if there were duplicates in Detail in previous message.

Steps to Recreate :

  1. Receive the appointments at Warehouse. Make sure they error out in RMS Hospital(Have more than one appt_detail with the same item and PO for one appt_nbr) with Unique constraint error.
  2. Notice that the other appointments even though they are good to go, will 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.