My Oracle Support Banner

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

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