R12 Select Available Inventory of Batch Ingredient Item Transaction Material with Error FRM-40350 (Doc ID 2051917.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to Select Available Inventory of batch ingredient item transaction material,
the following error occurs.

FRM-40350: Query caused no records to be retrieved.

The issue can be reproduced at will with the following steps:
1. Batch Details (THL) > Document XXX> Ingredient Item A
2. Click button 'Transact Material'
3. Checked 'Transact', Transaction Type: WIP Issue, Quantity: 9999
4. Click button 'Select Available Inventory'
5. New forms window dialogue comes out with the error message


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