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 FEBRUARY 03, 2019
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:
- Create a store with store_open_date in the future.
- Run storeadd.pc.
- Go to Control -> Setup -> Warehouse/store assignment. Assign this store to a warehouse. Click OK.
- Delete the store.
- Run dlyprg.pc
- Note that the batch aborts with the error shown above.
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