Error "ORA-02292: Integrity Constraint Violated" Occurs When Running RMS Rplapprv (Replenishment Approval) Batch

(Doc ID 1945514.1)

Last updated on AUGUST 17, 2016

Applies to:

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


In Oracle Retail Merchandising System (RMS) 13.1.x, the rplapprv batch (Replenishment Approval) aborts with the following error:

Steps to Reproduce:

  1. Replenishment process creates the order.
  2. The column ORD_PURGE_IND on table ORD_INV_MGMT is set to `Y'.
  3. Run process rplapprv to check if the order and location meet the vendor minimum requirements.
  4. The vendor requirements are not met, and the order is deleted (rplapprv process).


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