My Oracle Support Banner

Pricing API QP_PREQ_PUB.PRICE_REQUEST Is Rounding the Discounts Differently Than the Sales Order Form (Doc ID 2132206.1)

Last updated on MAY 01, 2023

Applies to:

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



Find that the pricing API (Qp_Preq_Pub.PRICE_REQUEST) is rounding the discounts differently than the sales order form.
The Pricing API is rounding the discounts and the applying it on the List Price.
So there is variance between the Price Calculated from the Form and the Pricing API.

From Sales Order Form
List Price: 149,494.25
Discount: 15 % , Adjusted amount -22424.1375
Other Discount 58% Adjusted amount -86706.665
Unit Selling Pricing : 40363.45

From API
List Price: 149,494.25
Discount: 15 % , Adjusted Amount : -22424.14
Other Discount 58% , Adjusted Amount : -86706.67
Adjusted Unit Price: 40363.44


Profile QP: Selling Price Rounding Options = Additive: =round(listprice + adj); unrounded Freight

The API calculation is 1 cent off. Should be the same value.

The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Enter order line and save.
4. Actions > View Adjustments

1. Run wrapper code which calls the pricing API
2. Review the output


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.