Cannot Enter Order Lines Due to Error FRM-40212: Invalid value for field ORDERED_ITEM_DSP (Doc ID 1634932.1)

Last updated on DECEMBER 06, 2024

Applies to:

Symptoms

Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

1) When attempting to query the price list for product value = (item 450-0509),the following error occurs.

ERROR
FRM-40301: query caused no records to be retrieved.


2) When attempting to enter a sales order for the same item (item 450-0509), the following error occurs.

ERROR
FRM-40212: Invalid value for field ORDERED_ITEM_DSP'

STEPS
The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Pricing Manager
2. Navigate to Price List > Price List Setup
3. Query price list shows that Item 450-0509 is Active
4. Under List Lines
    Do <F11> to enter query mode
    Enter 450-0509 for the Product Value
    Do <Ctrl><F11> to execute the query
    Shows message: 'FRM-40301: query caused no records to be retrieved.


1. Responsibility: Order Management Super User
2. Navigate to: Orders, Returns > Sales orders
3. Enter line 1.1 for item 450-0509, tab,
    Errors with: FRM-40212: Invalid value for field ORDERED_ITEM_DSP

Changes

Applied patches:
<Patch 14570467> - ORDER MANAGEMENT 12.1 JAN 2014 CUMULATIVE PATCH and
<Patch 17376133> - Latest Recommended Patch Collection for Order Management

Cause

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