How You Import and Export Meter Readings
Create and update asset meter readings in bulk using the File-Based Data Import process.
How You Import Meter Readings
Use meter reading imports to:
-
Create new sequential readings by value and date/time for an asset-based meter
-
Create new sequential readings by value and date/time for a subscription-based meter
For more details, refer to the File-Based Data Import for Oracle Supply Chain Management Cloud and Scheduled Processes for SCM guides.
Purge Batch Data from Maintenance Import Interfaces
The upload or import of data may result in a warning or error status sue to issues with the data. When this occurs, the data can't be further processed from the interface tables. In such a case, the Asset Administrator can run the Purge Maintenance Records from Interface scheduled process to delete the asset data from the interface tables from all or just a specific import process. The scheduled process can be run on demand or setup on a schedule as required by your business processes.
How You Export Asset Meters for Bulk Recording
On the Manage Assets page, you can search for a range of assets and export their Meters details. You can then use the information as the basis for creating a meter reading import template.
To begin, search for a range of assets in the Manage Assets page, then click the Export Asset Meters icon at the search header, to open the Meter Export Parameters dialog box On this dialog box, if you use the Include child assets check box, the exported file includes child asset meters for the parent assets returned in the results.
Click the OK button to generate the Export Asset Meters scheduled process job with a reference number. When the job is successfully completed, an output file in Excel format is created to closely match an asset's File-Based Data Import format. You can click the file name, called Default Document, to download the output file to your desktop for further editing.
The exported asset meter file includes the asset number, meter code, last active reading date and value. The format is very similar to the readings tab in the import file. You can copy and paste the applicable asset meters into the meter reading import template, update the reading date and value as required, in reference to the last reading date, time and value.