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 JUNE 28, 2019

Applies to:

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

Symptoms

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.

ERROR
-----------------------
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,
  wpv.attribute_name
from wip_preference_values wpv, mfg_lookups ml
where
 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



STEPS
-----------------------
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.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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