In Manufacturing Operations Center - Concurrent Program Error When Have A Negative Value For An Unmapped Tag

(Doc ID 2099503.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Manufacturing Operations Center - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On a 12.2.4 Instance in Manufacturing Operations Center

Concurrent Program Error when have a negative value for an undefined tag  

When loading a csv file (MTH_TAG_READINGS_RAW.csv) which has a tag reading record for a tag that has not been created and has a negative value, the concurrent program ends with an error of "No Data Found".
.
ERROR
-----------------------
MTHPTXN: MTH: Process Transactions

    INCR_READINGS_FROM_RAW start
      Exception OTHERS in INCR_READINGS_FROM_RAW
      ORA-01403: no data found

Root Cause: This happens when we have defined the tag and
miss to map to attribute, and try to pass negative value in
mth_tag_readings_raw.

Expected behavior: The CP should write a message in log file
and complete with warning.STEPS
-----------------------
The issue can be reproduced at will with the following steps:

(1)  Create a CSV (MTH_TAG_READINGS_RAW.csv) with an invalid tag, I.E. tag which does not exist in the MOC instance, and give it a negative value.  
(2)  Run the Scenario MTH_PKG_TAG_READINGS_RAW
(3)  Run the concurrent program "MTH: PROCESS TRANSACTIONS".  
(4)  The request will end with a staus = '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