Search Results eam_pm_last_service




Overview
Explore in AI Chat

Overview

The EAM_PM_LAST_SERVICE table is a core operational data object within the Oracle E-Business Suite Enterprise Asset Management (EAM) module, owned by the EAM schema. Its documented description, "PM Last Service Information," indicates that it stores the most recent preventive maintenance service readings for asset activities that are driven by meter or counter values. In EAM, preventive maintenance programs frequently trigger work orders based on cumulative usage rather than elapsed calendar time; this table preserves the last-known meter reading at the point a service was performed, allowing the application to determine when the next maintenance threshold has been crossed.

The object carries a documented physical schema of eleven columns and is classified heuristically under a Data Vault modeling suggestion as a link. This classification is consistent with its structure: the table resolves a relationship between a meter (captured in CSI_COUNTERS_B) and an asset activity association (captured in MTL_EAM_ASSET_ACTIVITIES), rather than acting as a standalone descriptive hub or a purely historical satellite.

Key Information Stored

The table's primary key, EAM_PM_LAST_SERVICE_PK, is defined as a composite of METER_ID and ACTIVITY_ASSOCIATION_ID. A second unique index, EAM_PM_LAST_SERVICE_U1, covers the same two columns in reverse order (ACTIVITY_ASSOCIATION_ID, METER_ID), confirming that this pair functions as the business key. The most important columns are:

  • METER_ID — Foreign key to CSI_COUNTERS_B; identifies the counter or meter against which service usage is measured.
  • ACTIVITY_ASSOCIATION_ID — Foreign key to MTL_EAM_ASSET_ACTIVITIES; links the reading to a specific preventive maintenance activity association.
  • LAST_SERVICE_READING — The meter value recorded at the most recent service event.
  • PREV_SERVICE_READING — The meter value captured at the preceding service, enabling usage-delta calculations.
  • WIP_ENTITY_ID — Foreign key to WIP_DISCRETE_JOBS; the work order under which the last service was performed.
  • MIGRATED_FLAG — Indicates whether the record was introduced through a data migration rather than native EAM processing.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns tracking creation and modification.

Common Use Cases and Queries

Typical applications include preventive maintenance scheduling, meter-based service forecasting, and audit reporting on asset utilization. A common query retrieves service history for a given meter:

  • SELECT activity_association_id, last_service_reading, prev_service_reading FROM eam_pm_last_service WHERE meter_id = :meter_id;
  • Join to CSI_COUNTERS_B to resolve meter names and units of measure.
  • Join to MTL_EAM_ASSET_ACTIVITIES to obtain the associated asset and PM definition.
  • Join to WIP_DISCRETE_JOBS to identify the work order that closed the last service.

Related Objects

  • CSI_COUNTERS_B — referenced via METER_ID; provides counter definitions.
  • MTL_EAM_ASSET_ACTIVITIES — referenced via ACTIVITY_ASSOCIATION_ID; defines the maintenance activity.
  • WIP_DISCRETE_JOBS — referenced via WIP_ENTITY_ID; source work order for the last service.
  • EAM_PM_LAST_SERVICE_PK / EAM_PM_LAST_SERVICE_U1 — indexes enforcing business-key uniqueness.