Auto Detail Batch Receiving Error "Could Not Query Reservations"

(Doc ID 1095144.1)

Last updated on JULY 29, 2016

Applies to:

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


In OPM Batches, when attempting to do 'Auto Detail Batch', or, 'Auto Detail Line', on some Batches, the following error occurs:

Could not query reservations

The error happens for ingredient items that are set up as Dual UOM Control = Fixed, or Dual UOM control with or without Default and a very small deviation.

On the Batch, the Ingredient qtys are issued in the Secondary UOM.  The conversion between primary and secondary UOM goes out to many decimal places

1. Navigation Path: Production Supervisor --> Batch Details --> New button --> Product Output tab: Enter Product number and Product Quantity. --> "OK" button --> click "Actions" menu --> Select "Release" --> Accept default date and click "OK" --> click "Inventory" menu --> Select "Auto Detail Batch" option --> Error results.


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