Customer Item Cross Reference Error: FRM-40212 Invalid Value For Field ORDERED_ITEM_DSP

(Doc ID 1590622.1)

Last updated on JANUARY 25, 2018

Applies to:

Oracle Order Management - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


The Customer Item Cross Reference raises an error, when entering a sales order.

Defined a Customer Item only at the Bill To Site Address. While creating a Sales Order, with the Bill To, using the Item Identifier as Customer Item, the item is not popping up.

It displays an error - Invalid value for field - ORDERED_ITEM_DSP.

When the same item is set as a cross reference with a Ship To, and the Ship To, Bill To Combination is used, the Customer Item pops up.


FRM-40212  Invalid value for field ORDERED_ITEM_DSP


1. Responsibility: Order Management Super user
2. Navigate: Orders Workbench, Order Organizer > Define customer item at bill to site address > Attempt to create a sales order.
3. Receive error


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