My Oracle Support Banner

Can Not Create The Routing For An Multi-Segment Item: Item Not Available In The LOV To Create Routing: APP-FND-01048: Use of this combination restricted (Doc ID 2216133.1)

Last updated on JULY 18, 2021

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.
APP-FND-01048: Use of this combination restricted by WHERE clause

Symptoms

Attempting to create a routing for a part with multiple item segments fails with error.

What is working
This works if the item has just one segment. When the item has multiple segments, then this does not work.

Checked the following
The item setup includes:
* purchased item
* BOM enabled
* Build in WIP is enabled
(However, when try to create the routing for the item, that item is not available in the list of values of the routing form.)

ERROR
APP-FND-01048: Use of this combination restricted by WHERE clause '(bom_enabled_flag = 'Y' and bom_item_type <> 3 and pick_components_flag = 'N'
and not exists (Select null from bom_operational_routings bo..)

STEPS
1. Navigate to Inventory > Items > Master item form : Create asset activity (item used in Enterprise Asset Management [EAM])
2. Navigate to Bills > Routings > Routings : Try to create maintenance routing.
3. Enter part number and tab.
4. Receive error.
* Cursor never leaves the field. System does not allow to enter item number.

Changes

Change from single segment item to multi-segment part numbers.

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
Changes
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.