My Oracle Support Banner

DMS Error When SCP.Putaway_stage_loc Location ID Length Larger Than 20 Characters (Doc ID 2399550.1)

Last updated on MAY 24, 2018

Applies to:

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

Symptoms

After setting the SCP.putaway_stage_loc setting to a value larger than 20 characters, the following error message is generated in the error log table and in the startup convert HH screen.

Error: ORA-02291: integrity constraint (WMS01.CONTAINER_REF3) violated - parent key not found

Steps to Reproduce:
1. Update the SCP.putaway_stage_loc for a location with length = 20 or more.
2. Use the startup convert for reserve location.
3. Enter the necessary_data.
4. Confirm and notice DMS Error.

Changes

 

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!


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