My Oracle Support Banner

APP-FND-01436 List Of Values Cannot Find Any Values For You To Choose (Doc ID 790710.1)

Last updated on APRIL 05, 2023

Applies to:

Oracle Order Management - Version 12.0 and later
Information in this document applies to any platform.


On 12.0.0 in Production:
When attempting to Reference the line information in the return tab for the RMA,
the following error occurs.


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)


The issue can be reproduced at will with the following steps:
1. Query up the RMA order
2. In the reference field.
Give the order number and the line number it errors




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

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