Query Price List Finds Product Value Is Null - Price List Line Product Value is Blank - There is no item number shown
Last updated on NOVEMBER 27, 2017
Applies to:Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
Form:QPXPRLST.FMB - QP_PRICE_LIST_LISTINGS_OBS
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. Re-query the price list and all is fine.
5. Exit the price list setup form.
6. Go back into the price list setup form.
7. Re-query the price list and now the product value is null.
FRM-40212: Invalid value for field ORDERED_ITEM_DSP
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