How To Resolve An Item That Errors With FRM-40350 And Cannot Be Queried In The Master Or Organization Items Form (Doc ID 413104.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Information in this document applies to any platform.
Item Master - Version: 11.5.10.2 and later
FORM:INVIDITM.FMB - Define Item Information
This document includes all versions of Oracle EBS 11i and R12 and later

Goal

The purpose of this document is to provide a list of conditions to check when an item exists in the MTL_SYSTEM_ITEMS_B (MSIB) table, but cannot be queried in the Master Items Form and/or the Organization Items Form (INVIDITM.fmb).

The following error occurs in the Master Items or Organization Items Form (INVIDITM.fmb):
FRM-40350 Query caused no records to be retrieved.

How to create a Forms Runtime Diagnostics (FRD) Trace to further diagnose the issue.

A FRD trace can be used to identifiy in detail the errors that are occuring in the form. Refer to the following documents to assist with creating a FRD Trace:
Note 245974.1 - FAQ - How to Use Debug Tools and Scripts for the APS Suite:
Note 290210.1 - Forms FRD Trace with New variable FORMS60_TRACE_PATH:
Note 335872.1 - Creating an FRD Trace Log on 11.5.10 Instances:
Note 438652.1 - FRD Trace for R12 Instance

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms