Price Book Modifier With Qualifier Customer Class Only Applies to the First Price List Line
Last updated on MAY 18, 2017
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.
When using the Price Book Functionality on Oracle EBS 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.
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.
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.
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;
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Oracle Pricing User
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
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