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

Last updated on MAY 10, 2023

Applies to:

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

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