Sales Order Errors Using Pattern Search: Could Not Find a Price List in Ordered UOM or Primary UOM (Doc ID 1231916.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10.2 and later
Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
***Checked for relevance on 02-JUL-2013***

Symptoms




On :  11.5.10.2 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. 

ERROR
-----------------------
Could not find a price list in Ordered UOM or Primary UOM


Notes
---------
<Patch 9872938>  has been applied.

  ====================================
  the debug file shows:
  ====================================
  *LINE_INDEX :=2
  *LINE_ID :=4433937
  LINE_TYPE_CODE :=ORDER
  UOM_QUANTITY :=
  CURRENCY_CODE :=USD
  PRICED_QUANTITY :=
  PRICED_UOM_CODE :=
  *UNIT_PRICE :=
  *PRICE_LIST_ID :=
  LINE_QUANTITY:=
  LINE_UOM_CODE:=
  LINE_UNIT_PRICE:=
  PERCENT_PRICE :=
  *ADJUSTED_UNIT_PRICE :=
  PARENT_PRICE :=
  PARENT_QUANTITY :=
  PARENT_UOM_CODE :=
  processed_code :=NMS
  processed_flag :=N
  Price Flag :=Y
  *STATUS_CODE :=INVALID_UOM
  *STATUS_TEXT :=Could not find a price list in Ordered UOM or Primary UOM





STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, pattern search had to be disabled in production,
which results in poor performance.

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