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
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". . 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'.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!