No Inventory Items are Presented in List of Values While Trying to Create a New Price List Line
(Doc ID 271702.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Advanced Pricing - Version 11.5.10 and laterInformation in this document applies to any platform.
Form Application : Oracle Pricing
Form Name : QPXPRLST
LOV - List of values
Form Version : Any
Symptoms
While creating a new price list in Oracle Advanced or Basic Pricing, choose the pricing context of Item,
Product attribute of, Item Number, and while trying to add an inventory item unable to do so.
If user does a blind search in the list of values, the following error is displayed:
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)
--------------------------------------------------------------
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)
--------------------------------------------------------------
No entries found for List of Values
Changes
No changes fresh install and setup
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |