MES: Unexpected ORA-01403 Messages When Transacting Components Without Onhand (Doc ID 1637385.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, In MES Operator when issuing components from a subinventory with no qty available, user gets the error message:
ERROR
-----------------------
1. ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
2. ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
3. XXXXXXXX failed validation. Quantity must be less than or equal to Available to transact

EXPECTED BEHAVIOR
-------------------------
User expect to only see the legit error:
 XXXXXXXXXX failed validation. Quantity must be less than or equal to Available to transact




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. MES Workstation
2. Transact Component
3.  Fill the form with a quantity greater than the available component quantity:

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
This impacting Go live which is  planned end of Nov 2013

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