This chapter contains the following topics:
This section provides an overview of meter reading interoperability, lists prerequisites, and discusses how to:
Set processing options for Inbound Meter Readings Processor (R12120Z1I).
Process inbound meter readings.
The interoperability programs for meter readings enable you to transfer meter reading data from other systems into the JD Edwards EnterpriseOne meter readings database. You can review and modify meter reading records before updating the meter readings database, and you can purge meter reading interoperability transactions.
These steps illustrate the flow of information through the meter reading interoperability programs:
Run the Inbound Meter Readings File Conversion program (R47002C) to load the data from the flat file into the Unedited Meter Reading Transactions table (F12120Z1).
If validation fails, the system issues errors and does not update the records to the meter reading database.
If validation succeeds, the system:
Writes the data to the Account Ledger table (F0911).
Updates the Asset Account Balances table (F1202).
(Optional) Updates the Maintenance Schedule table (F1207).
Marks the records in the F12120Z1 table as successfully processed.
The Inbound Meter Readings Processor program (R12120Z1I) requires that the F12120Z1 interface table have data in these fields:
Meter Type (MTTP)
Define which meter reading is being processed.
Amount - Current Balance (BALOW) or Amount - Net Increase (NIOWM).
Use BALOW if you are supplying the current meter reading. Use NIOWM if are supplying the net increase (decrease) in the current amount.
Before you complete the tasks in this section:
Set up flat file cross-references.
Note:The system provides transaction type METERS for inbound meter reading transactions.
Run the Inbound Flat File Conversion program (R47002C).
Specify the address book number of the recipient of job status messages that result from this program. If you leave this processing option blank, the system uses the address book number of the current user.
Specify whether the system runs the program in proof mode or final mode.
In proof mode, the system generates a report but does not update the tables. In final mode, the system generates a report and updates the tables. Values are:
Blank: Run program in proof mode.
1: Run program in final mode.
Specify where the system writes errors. Values are:
Blank: Write errors to the Work Center.
1: Write errors on the report.
Specify the equipment identifier in the Unedited Meter Reading Transactions table (F12120Z1) that this program uses.
The selected identifier is also printed on the report. Values are:
Blank: Use equipment (asset) number.
1: Use unit number.
2: Use serial number.
Specify whether the system automatically updates the current meters of child assets when updating the parent's current meter. Values are:
Blank: Do not update current meters of child assets.
1: Update current meters of child assets.
Specify whether the system displays a tolerance level warning.
Enter the specific percentage difference in meter readings that the system uses to signal the warning.
For example, if you enter 5 in this field, then the system issues a warning if the new net increase amount differs by more than 5 percent from the net increase amount of the last meter entry.
Blank: Do not check for tolerance levels and do not display a tolerance level warning.
Specify which version of Update PM Schedule Status program (R12807) the system uses when updating PM schedules.
Blank: Do not update PM schedules.
Select Meter Reading Interoperability (G1332), Inbound Meter Readings Processor.
This section provides an overview of reviewing and revising interoperability transactions for Capital Asset Management, lists the forms used to review and revise interoperability transactions for Capital Asset Management, and discusses how to set processing options for Meter Reading Transactions Revisions (P12120Z1).
Running a transaction process, such as Inbound Meter Readings Processor (R12120Z1I), often identifies one or more inbound transactions that contain invalid transactions. The Inbound Meter Readings Processor program identifies the invalid transaction and sends an error message to the Work Center (P012501). The error message indicates the transaction number for the transaction in error.
You can use on the Meter Reading Transactions Revision program (P12120Z1) to review and revise inbound transactions. You can add, change, or delete transactions containing errors. Then run the transaction process again. Continue to make corrections and rerun the transaction process until the program runs without errors.
|Work With Meter Reading Transactions||W12120Z1A||Meter Reading Interoperability (G1332), Meter Reading Transactions Revision||Locate meter reading transactions.|
|Meter Reading Transactions Revisions||W12120Z1B||On Work With Meter Reading Transactions, locate the applicable transaction and select Revisions from the Row menu.||Revise the information and click OK.|
Specify the transaction type for meter reading transactions. If you leave this processing option blank, the system using the transaction type METERS.
Specify the default view mode. Values are:
Blank: Display unprocessed records only.
1: Display successfully processed records only.
2: Display records with errors only.
This section provides an overview of purging interoperability transactions and discusses how to purge interoperability transactions.
When data becomes obsolete or when you need more disk space, you can use the Unedited Meter Reading Transactions Purge program (R12120Z1P) to remove data from the Unedited Meter Reading Transactions table (F12120Z1).
For records in the Processing Log table (F0046) that are marked as processed, the program purges the associated transactions in the F12120Z1 table, as well as the records in the F0046 table. If the records in the F0046 table are not marked as processed, the program does not purge any records.
Select Meter Reading Interoperability menu (G1332), Purge Meter Reading Transactions.