My Oracle Support Banner

How to Set Up a Modifier to Discount Lines Based on the Accumulated Ordered Quantity (Doc ID 1059506.1)

Last updated on AUGUST 02, 2023

Applies to:

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 (
1 5 5 %
6 10 10 %
11 15 15 %

When this discount is applied, the accumulated values and adjustment amounts are calculated as follows:

Line No. Quantity Accumulated Value Adjustment Amount
1.1 3 0 5%
1.2 6 3 8.33 %
1.3 4 9 13.75 %

The accumulation value and discounts are evaluated as follows:


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
 Modifier Setup
 Attribute Linking:
 Example Quote:
 Example Code Changes to APPS.QP_RUNTIME_SOURCE
 Example Table Structure Used by API to accumulate totals:

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