My Oracle Support Banner

Cannot Query An Item In Child Organization Even Though It Is Assigned - FRM-40350: Query caused no records to be retrieved. (Doc ID 2768255.1)

Last updated on JANUARY 13, 2022

Applies to:

Oracle Item Master - Version 12.2.9 and later
Information in this document applies to any platform.


One item cannot be queried in the Organization Items form even though it is assigned to that organization.
It can be queried in other child organizations and in the Master Organization form.

The following message is received:

FROM-40350: Query caused no records to be retrieved

The steps in the following note were followed but the issue remains.

<Note 1933028.1> - FRM-40654 or FRM-40735 / ORA-20001 Errors In The Master Item Or Organization Item Form INVIDITM.fmb

Neither Trace nor Forms Runtime Diagnostic identify the issue.


  1. Navigate: Inventory > Items > Organization Items
  2. Query for the item and receive the error.




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.