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 APRIL 29, 2022

Applies to:

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

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

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


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