Unit Selling Price Is Calculating Wrong After Changing Of List Price In Sales Order Line Entered in Unit of Measure (UOM) Other than Primary UOM
Last updated on MARCH 08, 2017
Applies to:Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.
*** Checked for relevance on 04-Nov-2014 ***
On : 12.0.6 version, Pricing, Discounting & Charges
Find that when an order line is entered for a unit of measure (UOM) that is not the primary UOM of the price list that when one overrides the list price and saves, the unit selling price is then updated based on
the primary UOM of the price list.
Expect the unit selling price to be the same as the overridden list price when no modifiers are applied
and the user overrides the list price.
The issue can be reproduced at will with the following steps:
1. Set profile option at user level
OM: List Price Override Privilege = UNLIMITED
2. Responsibility: Order Management Super User (or equivalent)
3. Navigate to: Orders, Returns > Sales Orders
4. Enter a sales order line for a UOM that is not the primary UOM on the price list. Save
5. Override the list price (at this point the list price and unit selling price are the same).
Find that the USP is changed based on the primary UOM of the price list.
UOM Conversion Definitions:
For item FSNMG40GP primary uom is case and secondary is Pouch
1 pouch = 1 Pieces (Pcs)
1 case= 375 Pieces (Pcs)
1Kg = 25 Pieces (Pcs)
Price list = SSL WB Needs India Ltd. (ISO) Price List
shows UOM = Cse (Case) with primary UOM checked unit price = 3000
Order has been raised in primary UOM USP and List price is calculating fine. 1 Cse shows Unit Selling Price (USP) = 3000 and List Price = 3000
When order has been raised in secondary UOM then also USP and List price is calculating fine
1 kg shows USP = 200 and List Price = 200
When list price is changed the USP coming fine
1 kg shows USP = 181 and List Price = 181
but save the data changes and takes the price of primary UOM,
1 kg shows USP = 2714.99999864250... and List Price = 181
The issue has the following business impact:
Due to this issue, users cannot correctly price the order.
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