How to Prevent Selling Price from Becoming a Negative Price When Applying Modifiers

(Doc ID 284694.1)

Last updated on MAY 19, 2017

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.
FORM:OEXOEORD.FMB - Sales Orders


Goal

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
follows:

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.

Solution

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 hundreds of Community platforms