My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.