My Oracle Support Banner

Warehouse (WH) Cannot Be Created With An Id With 10 Digits (Doc ID 2919691.1)

Last updated on JANUARY 09, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 to 19.3 [Release 19.2 to 19.3]
Information in this document applies to any platform.

Symptoms

WH cannot be created with an id with 10 digits

In MFCS versions 19.2 and 19.3 it is not possible to create a WH with an id of 10 digits. Up to 9 works but with 10 digits the following error is displayed when saving virtual WH.


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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a wh with an id with 10 digits, eg 999999999
2. Add business address
3. Add VWh with an id with 10 digits, eg 9999999998
4. Save

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.