Depot Repair Error: 'Select a Valid Value' On The Select Materials Page When Two Routing Items Start With The Same Characters (Doc ID 2353843.1)

Last updated on JULY 14, 2020

Applies to:

Symptoms

On : 12.1.3 version, Repair Execution

When attempting to select materials from a BOM for estimates, the user is not able to save a routing if the routing name is also a substring of another routing.  It causes the following error:

ERROR
-----------------------
Routing Reference: Select a Valid Value in Select Materials Page from estimate Tab

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

Create two routing in which one routing's name is a substring of the other.  (eg, CSD002 and CSD002a) 

1) Create a Repair Order 

2) Create an estimate header by saving the estimate 

3) In the estimate tab, click the Select Materials button 

4) In the routing field at the bottom of the expanded BOM page, select the shorter routing name. (eg CSD002) 

5) Click save Result: An error is retrieved "Select a valid value" comes up and routing can not be saved. 

Changes

Cause

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