My Oracle Support Banner

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 JUNE 17, 2021

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information 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

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

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