My Oracle Support Banner

Price Book Modifier With Qualifier Customer Class Only Applies to the First Price List Line (Doc ID 2058479.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Oracle Advanced Pricing - Version 12.1 and later
Oracle Order Management - Version 12.1 and later
Oracle Trade Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.



Scenario 1

When using the Price Book Functionality with Modifiers applied to the Price List, on 2 scenarios:

1) Creating a Full Price Book
2) Creating a Delta Price Book

If pick certain Qualifiers to apply the Modifiers on the base Price List, such as Customer Class, the behavior is erratic, as explained below:
Goal: Generate a Full or Delta Price Book with Modifiers + Qualifiers applied to the Price List.
For certain Qualifiers, such as Customer Class, the Modifier is only applied to the First Line on the Price List or no lines at all, while for other Qualifiers, such as Customer Name, the Modifier is applied to all the Lines.

Scenario 2

Create a modifier with qualifier with Qualifier Context = Customer, Qualifier Attribute = Sales Channel.
Create a sales order with the same sales channel as in the qualifier. Multiple lines are on the order but the modifier only applies to the first line.


Scenario 3

From EDI/order import, an order with 2 lines...only the first line had the modifier with qualifier customer class apply; the same modifier did not apply to the second line on the order.

Scenario 4

In sales order form, line 1 has a discount applied. Manually split the line and notice the discount is not applied to the split line. The discount has a qualifiers of customer/customer name.


Apply the Modifier + Qualifier to the Price List and Generate the Price Book with all the defined Price Changes;


The issue can be reproduced at will with the following steps:
1. Pricing User
2. Home
3. Reports
4. Create Price Book
5. Enter criteria for modifier with qualifier for customer class.
6. The Modifier is only applied to the First Line on the Price List


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

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