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 JULY 08, 2020
Oracle Item Master - Version 22.214.171.124 and later Information in this document applies to any platform.
Item Master - Version: 126.96.36.199 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 identify in detail the errors that are occurring 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!