ORA-02292 when Deleting a Warehouse with Virtual Warehouse Attached
Last updated on MAY 01, 2017
Applies to:Oracle Retail Merchandising System - Version 220.127.116.11 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