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 DECEMBER 04, 2019

Applies to:

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

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

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
Symptoms
Cause
Solution
References


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