WH_STORE_ASSIGN Records Are Not Deleted Upon Deleting a Store, Resulting in "ORA-02292: Integrity Constraint Violated - Child Record Found" Errors in DLYPRG Batch

(Doc ID 1635513.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.6 [Release 13.2]
Information in this document applies to any platform.


In Oracle Retail Merchandising System (RMS) 13.2, not all store records are deleted upon deleting a store.  Because WH_STORE_ASSIGN records remain, the DLYPRG batch aborts with the following error:

Steps to Reproduce:

  1. Create a store with store_open_date in the future.
  2. Run storeadd.pc.
  3. Go to Control -> Setup -> Warehouse/store assignment.  Assign this store to a warehouse. Click OK.
  4. Delete the store.
  5. Run dlyprg.pc
  6. Note that the batch aborts with the error shown above.


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