APP-FND-01436: List of Values cannot find any values for you to choose (Doc ID 1497155.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Installed Base - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Apr-2016***

Symptoms


When attempting to search a product by item number,
the following error occurs.

ERROR
-----------------------
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)
--------------------------------------------------------------
No entries found for List of Values


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(R): Install Base Service User
(N): Find Customer product
Enter Item Number
Hit Find > above error will be displayed
Product can be found if search is done by sales order number

Changes

 

Cause

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 hundreds of Community platforms