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 16, 2020

Applies to:

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


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".
MTHPTXN: MTH: Process Transactions

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


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

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