My Oracle Support Banner

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

Last updated on DECEMBER 14, 2022

Applies to:

Oracle Utilities Customer Care and Billing - Version to [Release 2.6 to 2.9]
Information in this document applies to any platform.


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



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.