Error "ORA-02292: Integrity Constraint Violated" Occurs When Running RMS Rplapprv (Replenishment Approval) Batch
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:
- Replenishment process creates the order.
- The column ORD_PURGE_IND on table ORD_INV_MGMT is set to `Y'.
- Run process rplapprv to check if the order and location meet the vendor minimum requirements.
- 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