My Oracle Support Banner

Unable To Price Related Items Without Encountering A Pricing Note On Sales Order (Doc ID 1623657.1)

Last updated on JUNE 14, 2021

Applies to:

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


When attempting to a enter sales order line on either the sales order or quick sales order form which has several related items attached to it, for some of the related items the following error occurs.

Price was not found on price list for this item and uom BX

The issue can be reproduced at will with the following steps:
1. Via OM Super User
2. Navigate to the quick sales order form.
3. Enter item # 51401513 which has:

Related items and List line IDs

51037439 -- 5888835 --- This should be priced out of the all items price list line
51183910 -- 10412489
ZTPA01A -- 10809081
ZA40050 -- 10412362
ZR9300 --5888835 --- This should be priced out of the all items price list line
ZA30050 -- 10697779

Once the message has been clicked through , all the items are price correctly

The customer then will run the QP Denormalize Data which can take up to 4 hours and the same order entered after the concurrent program is run will no error

However, this is not a feasible workaround as it delays 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.