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:

Symptoms

ACTUAL BEHAVIOR

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



NOTES

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

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

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 > Sales Orders
3. Enter order line and save.
4. Actions > View Adjustments

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

Cause

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