My Oracle Support Banner

OEXOEORD: How Do You Create A Modifier That Will Only Be Applied to a Sales Order Based on a Certain Item Quantity (Multiple)? (Doc ID 563662.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.0.6 [Release 11.5 to 12.0]
Information in this document applies to any platform.


How does one setup a modifier for the following business scenario?

How do you create a modifier that will only apply to a sales order when entering a certain multiple?
Attempting to create an automatic modifier, which will be applied when you order a specific
quantity of a certain product.
For example
If you order 10 tickets, you would get the discount
     (each item unit selling price is $10.00 with discount applied).
If you order 11 tickets, you will get a discount on the 10 ticket and
the 11th ticket would be priced at the regular amount(list price $12.00).

One also wants to make this discount apply to the order when order
increments of 10 tickets. This modifier would also automatically apply a
discount when you order ticket in increments of 10 tickets.
Anything over 10 would be regular price.

For example,
if one orders 21 tickets
one would get a discount on 20 tickets and
no discount on the 21st ticket.
Order total (less tax) would then be $112.00.



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.