Get_order_amount Function Calculating Against List Price Not Unit Selling Price (Doc ID 374786.1)

Last updated on AUGUST 02, 2017

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


Symptoms

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.


EXPECTED BEHAVIOR
Expect the GET_ORDER_AMOUNT FUNCTION to get the order amount from the selling price not list price

STEPS
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

BUSINESS IMPACT
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

 


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