Search Results fa_maint_events




Overview
Explore in AI Chat

Overview

FA_MAINT_EVENTS is a table in the FA (Assets) schema of Oracle E-Business Suite, owned by the OFA – Assets product module. Its documented purpose is to store scheduled maintenance events associated with fixed assets. In practice, the table records individual maintenance activities planned or performed against an asset, capturing the event identity, timing, responsible party, and associated cost. It supports the maintenance-tracking dimension of the Oracle Assets application rather than the core depreciation and financial posting logic.

From a heuristic Data Vault modeling perspective, the FK structure mined from the documented relationships suggests FA_MAINT_EVENTS behaves as a link object, connecting assets, vendors, books, and employees through its foreign key columns. This is a modeling suggestion based on relationship data rather than a declared EBS attribute; the table itself is a standard transactional OFA table with a composite primary key.

Key Information Stored

The table contains 33 documented columns. Its composite primary key, FA_MAINT_EVENTS_PK, is defined on ASSET_EVENT_ID and ASSET_ID. A unique index, FA_MAINT_EVENTS_U1, covers the same two columns (ASSET_EVENT_ID, ASSET_ID), which serves as the documented business-key candidate.

  • ASSET_EVENT_ID – Identifier for an individual maintenance event; combined with ASSET_ID it forms the primary key.
  • ASSET_ID – Foreign key to FA_ADDITIONS_B, identifying the asset to which the event belongs.
  • EVENT_NAME and DESCRIPTION – Textual identification and detail of the scheduled maintenance.
  • MAINTENANCE_DATE – The date the maintenance event is scheduled or recorded.
  • FREQUENCY_IN_DAYS – Interval for recurring maintenance schedules.
  • SCHEDULE_ID – Reference to the schedule under which the event was generated.
  • COST – Monetary amount associated with the maintenance event.
  • STATUS – Current state of the event (for example, scheduled versus completed).
  • VENDOR_ID – Foreign key to PO_VENDORS, identifying the servicing vendor.
  • EMPLOYEE_ID – Foreign key to PSB_EMPLOYEES, identifying the responsible employee.
  • BOOK_TYPE_CODE – Foreign key to FA_BOOK_CONTROLS, linking the event to an asset book.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 – The standard Oracle descriptive flexfield (DFF) columns for customer-defined extensions.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE – Standard auditing columns captured for every row.

The surrogate-style key here is ASSET_EVENT_ID in combination with ASSET_ID; because the unique index matches the primary key, no separate single-column surrogate is documented, and business-key identity is carried by the asset/event pairing.

Common Use Cases and Queries

Typical scenarios include listing all scheduled maintenance for a specific asset, reviewing upcoming or overdue maintenance by date, and reporting maintenance cost per asset, vendor, or book.

  • Retrieve events for one asset, joining to FA_ADDITIONS_B for the asset number:
SELECT m.ASSET_EVENT_ID, m.EVENT_NAME, m.MAINTENANCE_DATE,
       m.STATUS, m.COST
FROM   FA_MAINT_EVENTS m
WHERE  m.ASSET_ID = :asset_id
ORDER BY m.MAINTENANCE_DATE;
  • Report maintenance scheduled within a date range, enriched with vendor and book information by joining PO_VENDORS on VENDOR_ID and FA_BOOK_CONTROLS on BOOK_TYPE_CODE.
  • Aggregate total maintenance cost per asset using SUM(COST) grouped by ASSET_ID.
  • Extract DFF context and segment values via ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for custom maintenance classifications.
  • Audit recently modified events using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

The documented foreign keys establish the primary dependencies of FA_MAINT_EVENTS on other EBS objects:

  • FA_ADDITIONS_B – joined on FA_MAINT_EVENTS.ASSET_ID; provides asset master details.
  • PO_VENDORS – joined on FA_MAINT_EVENTS.VENDOR_ID; provides servicing vendor information.
  • FA_BOOK_CONTROLS – joined on FA_MAINT_EVENTS.BOOK_TYPE_CODE; identifies the asset book.
  • PSB_EMPLOYEES – joined on FA_MAINT_EVENTS.EMPLOYEE_ID; identifies the responsible employee.

Together these relationships make FA_MAINT_EVENTS a central link table for asset maintenance reporting, connecting asset, vendor, book, and employee dimensions within the Oracle Assets module.