C1-SMSYX Batch Job Is Not Extracting Records In Sequence Of Meter Remove Followed By Meter Install (Doc ID 2865555.1)

Last updated on MAY 22, 2024

Applies to:

Symptoms

Running Meter History Extract for Data Connect (C1-SMSYX) batch job daily to extract SP/meter history sync records. We are giving output file of this job to external MDM system to upload the records into their system. Batch is extracting in random order some time install records first and then removal records causing failure on MDM system.
Here is one example, where file has install record first then remove record.

INSTALL :2019-06-29-10.15.47|8571122765|A|5.00|L+G|FOCUS|1188294|1188294|2355727748|2019-04-29|R60|2019-06-29-08.03.23|2019-06-29-08.03.24||1.000000|Axe-R60 12_18|B|Y|LNG|MULTRATE|Y|CLASS200|2|240V||||
REMOVAL :2019-06-29-10.16.01|8571122765|A|5.00|ELSTER|R2SD|T78929|T78929|8570633277|2009-10-30|R60|2018-04-25-14.31.35|2018-04-25-14.31.35|2019-06-29-07.57.46|1.000000|TOU-E|B|Y|MAS|MULTRATE|N|CLASS200|2|240V||||

Changes

Cause

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