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 APRIL 19, 2021
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:
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.
- Navigate: Inventory > Items > Organization Items
- 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