My Oracle Support Banner

Using The Clear Button In The Material Workbench Makes Some Fields Inactive and Gives Error FRM-41014 (Doc ID 2463184.1)

Last updated on OCTOBER 07, 2019

Applies to:

Oracle Inventory Management - Version 12.2.7 and later
Information in this document applies to any platform.


The Clear button is being used to perform additional queries in the Material Workbench.
Two issues are being encountered when clicking the button:

  1. Receive the following error:

    FRM-41014: Cannot set attribute of null canvas item MATERIAL_QF.ORGANIZATION_ID
  2. The following fields are no long active/searchable (are greyed out):

    • Description
    • Status
    • Category Set
    • Category


  1. Navigate: Inventory > On-hand, Availability > On-hand Quantity
  2. Perform a forms query.
  3. Click the Clear button and receive the error and notice some fields that were searchable previously are no longer searchable.




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.