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 APRIL 03, 2025

Applies to:

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

Goal

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.

 

ERROR
FRM-40212  Invalid value for field ORDERED_ITEM_DSP

 

STEPS
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

Solution

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