My Oracle Support Banner

How Can One Provide Quantity Buy Discounts For Items Across Different Item Categories (Doc ID 2531441.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Advanced Pricing - Version and later
Oracle Order Management - Version and later
Information in this document applies to any platform.


We run promotions that all customers who purchase items in <Pricing Category 1> and/or <Pricing Category 2>  get an additional discount.
We want to run promotion like if sales order has 4 items from either of the pricing category items or put together, a discount of 8% should be applied.
Lets say <pricing category 1> has items <Item 1>, <Item 2>  and <pricing category 2> has <Item 3> and <Item 4>.
Then sales order can be for <Item 1> for quantity =2, and <Item 3> for quantity = 2. Since total quantity is four, then 8% discount should be applied.
If <Item 1> had had quantity = 4, then an 8% discount should be applied.

If the customer orders between 6 - 10 of any of these items combined, they get the items at a further discount.
For example if the customer orders 4 of item AAM415, 1 of item 224444, and 1 of an item in Category FAMCAP they would get those items at a further discount because their combined quantity is between 6 and 10. The way Oracle does it is just per modifier line. Need to be able to group the modifier lines together.

How does setup a modifier as such so that one can add the quantities of items from different item categories to make a discount modifier applicable?


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.