Receive Error "APP-FND-01048: Use of this combination restricted by WHERE clause" When Creating a New BOM (Doc ID 291092.1)

Last updated on AUGUST 13, 2024

Applies to:

Symptoms

Errors similar to the following are displayed when trying to define a new Bill of Material (BOM) for a particular item using the Bill Define form (BOMFDBOM.fmb). This occurs after entering or selecting an item.

Error 1:
            No entries found for List of Values
            --------------------------------------------------------------
            APP-FND-01436: List of Values cannot find any values for you to choose

            Cause: The List of Values execution failed to find any values.

            Cause: The SQL statement specified to fdlfch() failed to return any values.

            Action: Check the message stack for any SQL statement failure messages.
            Check to make sure your SQL statement works in SQL*Plus.
            (ROUTINE=fdlfch)
            --------------------------------------------------------------

Error 2:
            No entries found for List of Values

            --------------------------------------------------------------
            APP-FND-01048: Use of this combination restricted by WHERE clause
            ' ( ((:parameter.query_mode = 2 AND bom_enabled_flag = 'Y')
            OR (:parameter.query_mode = 1 AND EXISTS (SELECT NULL FROM
            bom_bill_of_materials bom WHERE bom.organization_id =
            :parameter.org_id AND bom.assembly_item_id = inventory_item_id
            AND ((:parameter.bom_or_eng = 1 AND assembly_type = 1) OR
            :parameter.bom_or_eng = 2) ))) AND (bom_item_type in
            (:parameter.model_item_access, :parameter.planning_item_access,
            :parameter.std_item_access, :parameter.oc_item_access) ) AND
            ((:parameter.bom_or_eng = 1 AND eng_item_flag = 'N' AND NOT
            EXISTS (SELECT 'X' FROM bom_bill_of_materials bom WHERE
            bom.organization_id = :parameter.org_id AND bom.assembly_item_id
            = inventory_item_id AND bom.alternate_bom_designator IS NULL AND
            bom.assembly_type <> 1) AND (:parameter.eam_type is null OR
            (:parameter.eam_type in (1, 2)

Changes

Cause