Skip Headers
JD Edwards EnterpriseOne Applications Interoperability Fundamentals Implementation Guide
Release 9.1

E15081-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

12 Processing Interoperability for Capital Asset Management

This chapter contains the following topics:

12.1 Processing Inbound Interoperability for Capital Asset Management

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.

12.1.1 Understanding Meter Reading Interoperability

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:

  1. 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).

    Data can also be loaded into the F12120Z1 table by using any other method supported by JD Edwards EnterpriseOne software.

  2. Use the Meter Reading Transactions Revisions program (P12120Z1) to review or modify the records in the F12120Z1 table.

  3. Run the Inbound Meter Readings Processor program (R12120Z1I) to validate the data in the F12120Z1 table.

    If validation fails, the system issues errors and does not update the records to the meter reading database.

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

12.1.2 Prerequisites

Before you complete the tasks in this section:

12.1.3 Setting Processing Options for Inbound Meter Readings Processor (R12120Z1I)

Processing options enable you to specify the default processing for programs and reports.

12.1.3.1 Defaults

1. Job Status Message Recipient

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.

12.1.3.2 Process

1. Proof or Final Mode

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.

2. Write Errors to Work Center or Report

Specify where the system writes errors. Values are:

Blank: Write errors to the Work Center.

1: Write errors on the report.

3. Equipment Identifier to Use

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.

4. Update Children Current Meters

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.

12.1.3.3 Edits

1. Tolerance Level

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.

12.1.3.4 Versions

1. Update PM Schedule (R12807) Version

Specify which version of Update PM Schedule Status program (R12807) the system uses when updating PM schedules.

Blank: Do not update PM schedules.

12.1.4 Processing Inbound Meter Readings

Select Meter Reading Interoperability (G1332), Inbound Meter Readings Processor.

12.2 Reviewing and Revising Interoperability Transactions for Capital Asset Management

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

12.2.1 Understanding Reviewing and Revising Interoperability Transactions for Capital Asset Management

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.

12.2.2 Forms Used to Review and Revise Interoperability Transactions for Capital Asset Management

Form Name FormID Navigation Usage
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.

12.2.3 Setting Processing Options for Meter Reading Transactions Revisions (P12120Z1)

Processing options enable you to specify the default processing for programs and reports.

12.2.3.1 Defaults

1. Transaction Type

Specify the transaction type for meter reading transactions. If you leave this processing option blank, the system using the transaction type METERS.

2. View Mode

Specify the default view mode. Values are:

Blank: Display unprocessed records only.

1: Display successfully processed records only.

2: Display records with errors only.

12.3 Purging Interoperability Transactions for Capital Asset Management

This section provides an overview of purging interoperability transactions and discusses how to purge interoperability transactions.

12.3.1 Understanding Purging Meter Reading 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.

See JD Edwards EnterpriseOne Tools Interoperability Guide

12.3.2 Purging Meter Reading Interoperability Transactions

Select Meter Reading Interoperability menu (G1332), Purge Meter Reading Transactions.