How To Resolve An Item That Errors With FRM-40350 And Cannot Be Queried In The Master Or Organization Items Form
Last updated on APRIL 16, 2018
Applies to:Oracle Item Master - Version 126.96.36.199 and later
Information in this document applies to any platform.
Item Master - Version: 188.8.131.52 and later
FORM:INVIDITM.FMB - Define Item Information
This document includes all versions of Oracle EBS 11i and R12 and later
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
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