QPXPRLST Query Price List Finds Product Value Is Null - Price List Line Product Value is Blank - There is no item number shown

(Doc ID 1087313.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
Checked for relevance 14-APR-2016



On : 12.0.6 version, Price List

Find that when one queries a price list, the product value for the price list line(s) is null (empty / blank).

Expects that the product value is populated.

The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Price Manager
Navigate to: Price List > Price List Setup
2. Query price list = Teste
3. Enter a new price list line as follows:
product context = Item
product attribute = Item Number
product attribute value = 00002 (selected from the list of values for this field)
defaults UOM = PC
primary UOM is not checked
application method = unit price
value = 77
4. Requery the price list and all is fine.
5. Exit the price list setup form.
6. Go back into the price list setup form.
7. Requery the price list and now the product value is null.

The issue has the following business impact:
Needs to prepare the instance with price lists to demonstrate business process to users.


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