My Oracle Support Banner

The Net Unit Price for a Sales Order Line Is Not Rounded Properly when "Summed" Price Rules Are Used (Doc ID 1353501.1)

Last updated on FEBRUARY 04, 2022

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.


When there's a rounding rule to 2 decimals and multiple Price Rules with an Adjustment Method of 'Summed' are applied, the Net Unit Price at the Sales Order line level is not rounding correctly (navigation: Order Management, Quotes and Orders, Create/Update Order).

For example:

When a Price Rule of -18% is applied on a Price of 12.35, the Net Price is coming to 12.13


when "Summed " Price Rules -5% and -13% are applied on a Price of 12.35, the line Net Unit Price is coming to 12.12 instead of 12.13. There is an inconsistency in the rounding.

13% discount: 12.35 * .13 = 1.6055
5% discount: 12.35 * .05 = 0.6175

12.35 - (1.6055 + 0.6175) = 10.127 (rounded to 10.13 per 2 decimal rounding rule)

As per PeopleBooks, both Price Rules should be summed and then applied.

PeopleSoft Enterprise Pricer 9.1 PeopleBook > Creating Price Rules > Setting Up Price Rules > Setting Up Price Rule Formulas


Select the method for applying the adjustment for the Discount/Surcharge and Product Add price action types.

Cascading: Applied as they are found. A second discount is applied to the previously discounted price, a third discount is applied to a price that is already discounted twice, and so on. For example, if the system encounters two discounts, such as 10 percent and 20 percent off the list price of 100 USD, then the system applies the discounts in this way: 10 percent off of 100 USD and 20 percent off of 90 USD. Thus, the unit price for the order schedule line is 72 USD.

Summed: When the system finds multiple discounts, it adds them together and applies the discount once. Thus, for the summed example, the system applies discounts in this way: the 10 percent and 20 percent discounts are combined for 30 percent off of 100 USD. The unit price for the order schedule line is 70 USD. The summed adjustments are applied to the net price with cascading adjustments already applied.


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.