My Oracle Support Banner

Pricing Example: - How to Apply Order Level Discount to Lines that are Discounted (Doc ID 357939.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
FORM:QPXPRMLS.FMB - Modifier Details



How can a modifier be defined so that a discount is applied at order level on lines that have already been discounted at line level?


Item A has list price of 100 and has special discount of 10%
Item B has list price of 50 and has special discount of 5%
    and for special customers there is an additional discount of 2%.

 The final price of Item A is 88.2
  - After the line discount (10%) the price becomes 100-(10*100/100) =  90
  - After the order discount (2%) the price becomes 90-(2*90/100)= 88.2

  The final price of Item B is 46.55
 - After the line discount (5%) the price becomes 50-(5*50/100) = 47.5
 - After the order  discount (2%) the price becomes 47.5-(2*47.5/100)= 46.55


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.