How to Set Up a Modifier to Discount Lines Based on the Accumulated Ordered Quantity
(Doc ID 1059506.1)
Last updated on OCTOBER 22, 2018
Oracle Advanced Pricing - Version 11.5.10 and later Information in this document applies to any platform.
My Requirement is to set up a modifier to discount lines based on the accumulated ordered quantity of an item on the order.
For example, if a customer orders 3 lines of the same item that is eligible for a discount, then each line is priced based on the accumulated value of the previous qualifying line for the same product.
Volume Attribute From
Volume Attribute To
Adjustment Amount ( Percent)
When this discount is applied, the accumulated values and adjustment amounts are calculated as follows:
The accumulation value and discounts are evaluated as follows:
The first line -- 1.1 -- is given a discount of 5% because an accumulation value of 0 is passed and the order quantity of 3 satisfies the range 1-5.
Line 1.2 is evaluated with starting at the accumulated value of 3. Two of the ordered quantity 6 fall within the range of 1-5 and 4 fall within the range 6-10 resulting in an 8.33% adjustment.
Line 1.3 is evaluated with a starting point of (3+6) = 9 passed by the calling application and an order quantity of 4. One of quantity 4 falls within range 6-10 and 3 fall within the range of 11-15 resulting in a 13.75% adjustment.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!