My Oracle Support Banner

Error When Setting The MES Parameter Reason Codes For Exception Types At Any Level Lower Than Site (Doc ID 2494498.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle MES for Discrete Manufacturing - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Mobile Mfg

When attempting to navigate to Responsibility Level to validate the Inherit flag was turned on, the following error occurs.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select
  wpv.attribute_value_code lookup_code,
  ml.meaning meaning,
from wip_preference_values wpv, mfg_lookups ml
 wpv.preference_id = :1 and
 wpv.level_id = :2 and
 ml.enabled_flag = 'Y' and
 ml.lookup_type = :3 and
 ml.lookup_code = wpv.attribute_value_code and

The issue can be reproduced at will with the following steps:
1. Navigate to MES Administrator to input parameter values
2. Change Level to Role
3. Select Responsibility = MES Operator

4. Navigate to Parameter
5. Reason Codes for Exception Types. Select the pencil.
6. Get the aforementioned error message.


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

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