My Oracle Support Banner

Unable To Process RMS/Debits for the Obsolete Items FRM-40212: Invalid value for field ORDERED_ITEM_DSP (Doc ID 2890982.1)

Last updated on AUGUST 23, 2022

Applies to:

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


Unable to process RMS/Debits for the Obsolete items when CUSTOMER ORDERS ENABLED in the Master Items form.  

These are Obsolete status post upgrade step from 12.1.3 to 12.2.9

FRM-40212: Invalid value for field ORDERED_ITEM_DSP

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

1. Login as order management super user
2  Inventory item master which we manually enable and disable a sku# for ordering.
3. I tried the 3 scenarios.
  a)Manual credit – able to create a credit without having to check/click CUSTOMER  ENABLE BOX
  b)Manual Standard – not able to create an order which is understandable since this item is OBSOLOTE and CUSTOMER ENABLEB BOX is not checked.
  c)Manual debit – not able to create a debit when CUSTOMER ENABLE BOX is not checked. FRM-40212: Invalid value for field ORDERED_ITEM_DSP

 Does CUSTOMER ENABLE BOX really have to be marked to enter a debit for a customer since this is a manual billing?


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.