Information Needed On Price List Columns (Doc ID 3054237.1)

Last updated on OCTOBER 21, 2024

Applies to:

Goal

Need clarification on below fields . Please review and provide information.

qp_list_lines.pricing_group_sequence

1. What is the significance of this field in Price List.
2. Our system has 0 and NULL as values. In what circumstances the value is NULL

qp_list_lines.product_precedence

1. What is the significance of this field in Price List
2. Why it is NULL for some records
3. What is the impact on Price calculation while Pricing Engine is called without Precedence

qp_list_lines.qualification_ind
1. What is the significance of this field in Price List
2. How is this calculated and used by Pricing Engine
3. Our system has two values 4 and 21. What do they stand for and how the values are derived

qp_pricing_attributes.attribute_grouping_no

1. What is the significance of this field in Price List
2. What is this value indicating.
3. Our system shows the value 1 for more records and a sequence# for other rows.
 

Solution

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