Dispense Inquiry Tab Give 'Internal Server Error' Due to Performance Issue On OPM Batch (GME_BATCH_HEADER) Query

(Doc ID 2340371.1)

Last updated on DECEMBER 26, 2017

Applies to:

Oracle MES for Process Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
'Internal Server Error'
SQL on GME_BATCH_HEADER
BatchListVO.xml

Symptoms

On Application Release 12.1.3, under MES for Process Manufacturing pages:

When clicking the Inquiry tab in MES, the following error occurs.

ERROR
Internal Server Error

Cause

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