My Oracle Support Banner

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 JULY 25, 2023

Applies to:

Oracle Advanced Pricing - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Oracle Order Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders

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 :=XXX
  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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.