My Oracle Support Banner

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 DECEMBER 04, 2019

Applies to:

Oracle Bills of Material - Version 11.5.9 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12


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

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.