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 MAY 09, 2018

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!

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