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 NOVEMBER 27, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.



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.


Note:  If one then tries to add this item and price list to a sales order line, the following error occurs:
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