My Oracle Support Banner

ORA-02292 when Deleting a Warehouse with Virtual Warehouse Attached (Doc ID 1349552.1)

Last updated on MARCH 01, 2019

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:


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.