Query regarding meter reading import from third party device using EAM_METER_READINGS_INTERFACE
Hi all, We are trying to update the meter readings of asset from a third party device.So to test the same,we inserted a single record in the EAM_METER_READINGS_INTERFACE table using the below code.
insert into EAM_METER_READINGS_INTERFACE
(group_id,process_status,process_phase,meter_id,meter_name,reset_flag,organization_id,organization_code,reading_date,
reading_value)
values ('12345','1','2','406171','FL1010 Hour Meter','N','3159','EM1','11-OCT-2011','15000');
The record got inserted into the table.
When we try to import the same using'EAM Meter Reading Import' Program. But it fails.
insert into EAM_METER_READINGS_INTERFACE
(group_id,process_status,process_phase,meter_id,meter_name,reset_flag,organization_id,organization_code,reading_date,
reading_value)
values ('12345','1','2','406171','FL1010 Hour Meter','N','3159','EM1','11-OCT-2011','15000');
The record got inserted into the table.
When we try to import the same using'EAM Meter Reading Import' Program. But it fails.
0