ORA-02292 when Deleting a Warehouse with Virtual Warehouse Attached

(Doc ID 1349552.1)

Last updated on MAY 01, 2017

Applies to:

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


The Dlyprg batch is not deleting physical warehouse having virtual warehouses with ORG_ENTITY_TYPE set to 'M' - importer or 'X' - exporter.

Steps To Recreate:

1. Create a physical warehouse (lets say 10). Attach virtual warehouses to it with ORG_ENTITY_TYPE set to 'R', 'M', 'X' (101, 102, 103 respectively). Run Whadd.pc batch.
2. Delete the physical warehouse using the form Warehse.fmb.
3. Records for only the Physical wh and the Regular wh get inserted to DAILY_PURGE table.
4. Run the dlyprg.pc batch. The following error is logged:


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