Sales Order Errors Using Pattern Search: Could Not Find a Price List in Ordered UOM or Primary UOM
Last updated on MARCH 08, 2017
Applies to:Oracle Advanced Pricing - Version 126.96.36.199 and later
Oracle Order Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
***Checked for relevance on 02-JUL-2013***
On : 184.108.40.206 version, Other Issues
Basically the error occurs when you enter the quantity in the order, the
message states that the price list cannot be found, although once you enter (click ok)
the message, the price is then displayed. Sometimes the error appears on line 1 but
always in line 2 using this data scenario.
Could not find a price list in Ordered UOM or Primary UOM
<Patch 9872938> has been applied.
the debug file shows:
Price Flag :=Y
*STATUS_TEXT :=Could not find a price list in Ordered UOM or Primary UOM
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Orders
3. Enter a sales order line and save.
4. Enter a the item and quantity on the second order line,
The aforementioned error is shown.
The issue has the following business impact:
Due to this issue, pattern search had to be disabled in production,
which results in poor performance.
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