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

Last updated on JUNE 23, 2017

Applies to:

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

***Checked for relevance on 23-Jun-2017***


Symptoms

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

ERROR
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)
--------------------------------------------------------------

STEPS
The issue can be reproduced at will with the following steps:
1.Query up the RMA order
2.In the refernce field.
Give the order number and the line number it errors
BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot create return orders.
.

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