My Oracle Support Banner

How to Prevent Selling Price from Becoming a Negative Price When Applying Modifiers (Doc ID 284694.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Advanced Pricing - Version 11.5.9 and later
Oracle Order Management - Version 11.5.9 and later
Information in this document applies to any platform.


The purpose of this Note is to explain and provide examples of how to apply a discount modifier
to the resultant selling price of an order line, or all lines, in such a way as to prevent the
selling price from becoming negative. This is to solve a problem caused by the current design of
modifiers whereby order level and manual modifiers are placed in the null bucket, which means that
they get applied to the list price of the item.

For example, say item A has list price 100.00 and after a discount the selling price becomes 80.00.
If an order level 100% modifier is now applied the resultant selling price would be calculated as

Selling Price = 100.00 + (-20.00 which is previous discount) + (-100.00 which is the order level modifier).
This results in -20.00, and not 0.00 which is the desired result.


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.