Get_order_amount Function Calculating Against List Price Not Unit Selling Price
(Doc ID 374786.1)
Last updated on JULY 20, 2020
Applies to:Oracle Order Management - Version 11.5.9 to 12.2.3 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 24-DEC-2013
Find that a custom pricing attribute which was created to use the custom api call of QP_SOURCING_API_PUB.GET_ORDER_AMOUNT function to get the order amount does not work as expected. The order amount value calculated always uses the list price, if an order line has a unit selling price that differs from the unit list price due to an adjustment, then the GET_ORDER_AMOUNT gets the unit list price.
Expect the GET_ORDER_AMOUNT FUNCTION to get the order amount from the selling price not list price
The issue can be reproduced at will with the following steps:
1. Via OM Super User Responsibility, Navigate Orders Returns, Sales Orders
2. Create a sales order line and save it
3. The applied freight charge is correct, but go back to the order line and change the unit
selling price to 4
The issue has the following business impact:
Due to this issue, users cannot get freight charges to be correctly calculated as the unit selling
price * order qty *1.5 % surcharge
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