My Oracle Support Banner

Error Creating A Virtual Warehouse (Doc ID 2730149.1)

Last updated on NOVEMBER 20, 2020

Applies to:

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


An error occurs when creating a virtual warehouse : when user clicks on the save button an error is displayed :

ORA-02291: integrity constraint (RMS.WHD_WAH_FK) violated - parent key not found.

Steps to reproduce :
1. Access organizational hierarchy (Task – Foundation Data – Locations - Organizational Hierarchy).
2. Choice Warehouse option.
3. Choice Create Warehouse option.
4. Capture required data main screen.
5. Click Address button and capture the required data from the address screen.
6. Click Save button.
7. Click Save and close button.
8. Click Virtual Warehouse button.
9. Click Add New Virtual Warehouse button.
10. Capture required data and click on OK button.
11. Click Save button.




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.