Select Available Inventory From OPM Batch Error 'Query caused no records to be retrieved' (Doc ID 2059640.1)

Last updated on OCTOBER 16, 2015

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Batches

For few orders, access 'Select Available Inventory' through Batch > transact material give error saying 'Query caused no records to be retrieved'
For the same order the same form from 'Reservation' form shows data correctly.

Not to get the message 'Query caused no records to be retrieved'

The issue can be reproduced at will with the following steps:
1. Production Supervisor > Batch Details > Transact Material > Select Available Inventory -

This is NOT WORKING for some batches


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