My Oracle Support Banner

INVMWBIV - After Depot Patch 12831979, Material Workbench Error: FRM-40105: Unable to resolve reference to item PARAMETER.G_QUERY_FIND (Doc ID 1374142.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Form:INVMATWB.FMB - Material Workbench
Form:INVMWBIV.FMB - Material Workbench


After installing Depot Repair <Patch 12831979>, when attempting to open On-Hand, Availability, the following error occurs.

A series of errors appear including the following:
1. FRM-47023: No such parameter named G_Query_Find exists in invmwbiv.
2. FRM-40105: Unable to resolve reference to item Parameter.g_Query_find
3. FRM-47023: No such parameter named no_item exists in form invmwbiv
4. FRM-47023: No such parameter named no_orgs exists in form invmwbiv

Here are some example screen shots of the errors:

1. Connect to Inventory Responsibility
2. Go to On-Hand, Availability and the error is generated.

Business Impact
Due to this issue, users cannot continue with the Testings of the application impacting Production.


Applied Depot Repair <Patch 12831979>.
(Or Depot Repair <Patch 12988917> that supersedes <Patch 12831979>).


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
 A. Workaround - Quick Fix
 B. Patch - Best Option

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.