My Oracle Support Banner

How to Apply a Manually Entered Order Level Discount to the Net (discounted) Value of an Order (Doc ID 413982.1)

Last updated on AUGUST 11, 2020

Applies to:

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


Currently it is not possible to assign an order Header Discount to a bucket, this is described in Enhancement request <Bug 2137771>

There is often a requirement to apply a manual discount on the Net Value of an Order.


Order Line 1 has a value of 100 USD with a 20 % Discount applied. The Net value of this order line is 80 USD

Order Line 2 has a value of 200 USD with a 30 % Discount applied. the Net value of this order line is 140 USD.

A manual discount is to be applied on the Net value of the order - 220 USD.  The discount applied is entered at 30 %.

The Actual value of the order is then calculated as 154 USD - (220 - (220*(30/100)).


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
 A. Create an order Header Flexfield to enter the discount.
 B. Create a Pricing Context
 C. Link the flexfield to a pricing attribute
 D. Reference the pricing attribute in a formula
 E. Apply the formula in a modifier so that the discount is applied.
 F. Housekeeping.
 G. Setup Screen shots Including Special Considerations Needed for Manual Modifier Application
 Manual Modifier Business Need
 Manual Modifier Setup Needed
 Testing the Manual Modifiers Impact with the Net Price Modifier.

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