My Oracle Support Banner

Unit Selling Price Appears As Zero When UOM Is Changed In Sales Order Line Due to Using a New Price List Line on the Same Price List (Doc ID 1513703.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Oracle Order Management - Version and later
Information in this document applies to any platform.


On : 12.1.3 version, Pricing, Discounting & Charges

After raising Sales Order, enter Order line with Item code, qty, primary UOM, the price defaults with List price from Std Price List.
When the UOM is changed from PCS to BOX, then the List price changes to zero.

On the price list, there is an 'All Items' with UOM as BOX with price = 0
The All Items line in price list has precedence for 315 which is lower than 220 which is the precedence for the item price line with primary UOM.
So the item price should take precedence since the item is priced and has a higher priority given to it.

Expect the item to be priced and not take the all items lower precedence 0 price

The issue can be reproduced at will with the following steps:
1. Order Management Super User >> Quick Sales Order >> Enter Sales Order line >> Item code , qty ,primary UOM - defaults with List price from Std Price List.

2. Change UOM from PCS to BOX, then the List price changes to zero.

The issue has the following business impact:
Due to this issue, users have Unit selling price wrong and this has to be changed manually.This is causing delays in order processing.


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.