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 MARCH 05, 2024

Applies to:

Goal

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

ERROR
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?

Solution

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