My Oracle Support Banner

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 FEBRUARY 25, 2019

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
OEXOEORD
QPXPRLST

Symptoms

 

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

EXPECTED BEHAVIOR

Expects that the product value is populated.


STEPS

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
    save
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

 

Changes

 

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
References


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