My Oracle Support Banner

Allocation Failed With ORA-02291: Integrity Constraint RWMS16.STOCK_ALLOCATION_REF2 Error (Doc ID 2363559.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Retail Warehouse Management System - Version 16.0 and later
Information in this document applies to any platform.


Stock order message failed in Retail Warehouse Management System(RWMS) with "ORA-02291: integrity constraint (RWMS16.STOCK_ALLOCATION_REF2) violated" error when item is allocated to store and warehouse in same allocation.

Steps To Recreate:
1. Login to allocation application.
2. Select item to allocate.
3. Allocate item to one store and one warehouse.
4. Enter allocation quantity.
5. Submit and approve allocation.
6. Allocation created in allocation and RMS.
7. Check message failed in RWMS. Refer RIB_MESSAGE_FAILURE for error message.
  Error message - ORA-02291: integrity constraint (RWMS16.STOCK_ALLOCATION_REF2) violated



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.