No inventory items presented in LOV while trying to create a new price list (Doc ID 271702.1)

Last updated on JULY 14, 2016

Applies to:

Oracle Advanced Pricing - Version 10.7 to 12.0.6 [Release 10.7 to 12.0]
Information in this document applies to any platform.
***Checked for relevance on 29-JAN-2015***
Form Application : Oracle Pricing
Form Name : QPXPRLST
Form Path :/qp/11.5.0/forms/US/QPXPRLST.fmx
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

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