Negative Price Error When Manual Override Modifier Is Applied To Set Selling Price To Zero (Doc ID 2099357.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Pricing, Discounting & Charges

When attempting to attempting to override the unit selling price to zero,
the following error occurs.

ERROR
-----------------------
 Order: 745459, Line 1.1, The list price 95 or the selling price -.01 for item F5 is negative and the profile “ONT: Negative Pricing” is set to “N”.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Quick Sales Order
3. Query sales order 745459
4. Order line 1.1 prior to applying the manual discount that will set the price to 0.00,
Shows unit selling price = 60.33
.
Price Adjustments:
List Line Type Rate Adjusted Amount
 Discount1    0.0
 Discount2 -34.675
.
5. Manually override the unit selling price to zero.
6. Error message occurs:
  Order: 745459, Line 1.1, The list price 95 or the selling price -.01 for item F5 is negative and the profile “ONT: Negative Pricing” is set to “N”.

NOTES
-----------------------
Math for this example.
Item has list price of $95.00
Discount2 is 36.5%.
Selling price is adjusted by -34.675.
$95.00 – 34.675 = 60.325. Rounded result is 60.33
Discount1 is to make line 0.00.
60.33 / 95.00 = 0.6350526315789474
Result is 60.33 – 60.33 = 0.00
Final line total calculation based on adjusted amounts is 34.675 + 60.33 = 95.005.
List line price minus total adjusted amounts = 95.00 – 95.005 = -0.005, Rounding result -0.01.



OM:Unit Price Precision Type ** Not Set At Any Level ** ----
QP: Price Rounding FACTOR Site
QP: Unit Price Precision Type STANDARD Site
QP: Selling Price Rounding Options NO_ROUND_ADJ Site




Cause

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