My Oracle Support Banner

Manual Item Substitution on a Booked Order Fails with Error 'FRM:40212 Invalid Value for Field Order_quantity_uom' If the Uoms of the Ordered Item and Substituted Item Are Different (Doc ID 2896837.1)

Last updated on OCTOBER 27, 2022

Applies to:

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


Manual Item Substitution on booked order fails if UOM of Ordered Item and substituted item are different even though UOM conversion is defined.
When trying to add substitute item from Related Item window having UOM different than original item below error occurs

Could not find price list in ordered UOM and primary UOM
List price is required for booked order
FRM :40212 Invalid value for field ORDER_QUANTITY_UOM

The issue can be reproduced at will with the following steps:
1. Order management super user
2. Enter order with line item having UOM of HR
3.Order is Booked
4.Use Related item window and select Substitute item having UOM 'USD'
  Error pops up




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.