Apply Pricing Promotions to Sales Orders Using Groups of Eligibility and Exclusion Conditions

Starting in Update 24C, you can use a predefined set of customer attributes, order line attributes, and item attributes in Oracle Pricing to determine what sales orders are eligible for your pricing promotion.

• Create a rule that matches any or all attribute values in a group or across groups and subgroups.
• Create an exclusion condition that excludes eligibility according to an attribute value.

Consider an example:

No Subgroup

The example applies this rule:

If the Customer attribute on the sales order contains Business World or if it contains A.C. Networks, and if the order total is greater than $20,000, and if the item isn't in the Office Stationary category, then apply the promotion.

Consider an example that has a subgroup:

Subgroup

The category specifies Home Theater as the group, two order line attributes specify the subgroup, and you also have an exclusion. The example applies this rule:

Condition	Rule
Group	If the item is in the Home Theater category.
Subgroup	And if the order line's: Unit of Measure attribute contains Each or it contains Dozen.    Or the line's Shipping Method attribute contains DHL-Air-Express or it contains Federal Express-Air-FedEx 2day.
Exclusion	And if the order header's Customer attribute doesn't contain ABC Corporation or Business World, then apply the promotion.

Business Benefits:

• Focus your selling.
• Easily create complex rules.

Steps to Enable

See Create Pricing Promotions for Sales Orders Using Redwood Pages.

Tips And Considerations

• If you specify a condition according to Line Amount or Order Total, then include the currency as a separate condition.

• If you specify a condition according to Line Quantity, then include the UOM as a separate condition.

• Some customer attributes might have more than one value, such as Billing Address City. If you reference an attribute that might have more than one value, then include another condition, such as Billing Address State or Billing Address Country. This will help to further qualify the promotion.

You can use these attributes in your rule:

Customer Attributes	Sales Order Attributes	Item Attributes
Customer Customer Account Billing Address City Billing Address County Billing Address State Billing Address Province Billing Address Country Billing Address Postal Code Shipping Address City Shipping Address County Shipping Address State Shipping Address Province Shipping Address Country Shipping Address Postal Code	Currency Line Quantity Line Amount Order Total Business Unit Shipment Method Pricing uses the list price for a one time charge in the: Order line's currency to calculate the Line Amount. Order header's currency to calculate the Order Total. Pricing considers the currency only on outbound lines. It doesn't consider the currency on return lines.	Item Item Category UOM

Key Resources

• Administering Pricing

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

• Manage Draft Pricing Promotions (QP_MANAGE_DRAFT_PRICING_PROMOTIONS)
• Manage Pricing Promotions (QP_MANAGE_PRICING_PROMOTIONS)
• View Pricing Promotions (QP_VIEW_PRICING_PROMOTIONS)
• Activate Pricing Promotions (QP_ APPROVE_PRICING_PROMOTIONS)
• Manage Dynamic Rules (QP_MANAGE_DYNAMIC_RULES)