PICKING RULE LOV AT OM TAB IN INVIDITM FORM CONTAINS NO DATA (Doc ID 1059016.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

Inventory>Items>Master Items>Insert Item>Order Management Tab>Picking Rule Field>Error, LOV contains no data

Opened the form INVIDITM in Oracle Forms to see the query used by LOV in record group. Found this query in the PICKING_RULE_QP record group:

SELECT picking_rule_name, description, picking_rule_id FROM mtl_picking_rules ORDER BY picking_rule_name;

The table that this query is getting values is MTL_PICKING_RULES but table used for Picking Rules Setup the name is different, the name is MTL_INV_PICKING_RULES.

So, is this a bug? Exist any patch to solve this or we are doing wrong setups?

Solution

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