My Oracle Support Banner

Customer Item Cross Reference Error: FRM-40212 Invalid Value For Field ORDERED_ITEM_DSP (Doc ID 1590622.1)

Last updated on FEBRUARY 20, 2019

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


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.