Pricing API QP_PREQ_PUB.PRICE_REQUEST Is Rounding the Discounts Differently than the Sales Order Form

(Doc ID 2132206.1)

Last updated on OCTOBER 18, 2017

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

On : 12.2.4 version, Pricing Engine

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
Automatic Contracted Discount: 15 % , Adjusted amount -22424.1375
Other Discount 58% Adjusted amount -86706.665
Selling Pricing : 40363.45

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



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

EXPECTED BEHAVIOR
-----------------------
The API calculation is 1 cent off. Please let me know how to get this corrected.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms