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

Last updated on JULY 23, 2024

Applies to:

Symptoms

Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

Changes

Cause

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