Results for “ahl_mr_intervals”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AHL_MR_INTERVALS is a table in the AHL schema belonging to the Complex Maintenance Repair and Overhaul (AHL) product of Oracle E-Business Suite, and is documented for both release 12.1.1 and 12.2.2. It stores the frequency at which a given maintenance requirement is to be performed, effectively defining the interval logic that drives recurring maintenance program scheduling. Because maintenance programs in AHL are expressed as requirements attached to units, positions, or effectivities, the interval record supplies the numeric or counter-based cadence — for example, after a fixed number of operating hours, cycles, or elapsed days — that determines when the next occurrence of the requirement becomes due.

The table has a documented physical schema of 36 columns and is owned by AHL. Its surrogate primary key is AHL_MR_INTERVALS_PK, defined on MR_INTERVAL_ID, with a corresponding unique index AHL_MR_INTERVALS_U1 on the same column, which identifies it as the single business-key candidate documented in the ETRM metadata. The mined Data Vault classification is satellite-leaning: AHL_MR_INTERVALS describes the interval attributes of maintenance requirement effectivities rather than acting as a standalone hub or a pure many-to-many link. This classification is a heuristic modeling suggestion derived from the foreign-key structure, not a physical constraint imposed by the product.

Key Information Stored

Each row captures the interval definition for one maintenance requirement effectivity and, where a counter governs the cadence, the specific counter to which the interval applies. The most significant documented columns are:

• MR_INTERVAL_ID — the surrogate primary key and the sole documented unique business-key candidate.
• MR_EFFECTIVITY_ID — foreign key to AHL_MR_EFFECTIVITIES, tying the interval to the maintenance requirement effectivity it qualifies.
• COUNTER_ID — foreign key to CS_COUNTERS, identifying the meter or counter used when the interval is counter-based.
• INTERVAL_VALUE — the frequency itself, i.e. how often the maintenance requirement recurs.
• START_VALUE, STOP_VALUE, RESET_VALUE, EARLIEST_DUE_VALUE — the counter thresholds bounding the interval window and defining when the requirement is first due and when the counter resets.
• START_DATE, STOP_DATE — the calendar boundaries within which the interval is active.
• TOLERANCE_BEFORE, TOLERANCE_AFTER — permitted scheduling slack on either side of the due point.
• CALC_DUEDATE_RULE_CODE — the rule used to calculate the due date for the interval.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for multi-org access control.
• Standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER) and the 15 descriptive flexfield columns (ATTRIBUTE_CATEGORY, ATTRIBUTE1–15).

Common Use Cases and Queries

Typical usage centers on retrieving the interval definition behind a maintenance requirement, reporting upcoming maintenance workload, and auditing interval configuration. A simple retrieval by requirement effectivity:

• SELECT MR_INTERVAL_ID, INTERVAL_VALUE, START_VALUE, STOP_VALUE, CALC_DUEDATE_RULE_CODE FROM AHL.AHL_MR_INTERVALS WHERE MR_EFFECTIVITY_ID = :mr_effectivity_id;

Joining to AHL_MR_EFFECTIVITIES resolves which requirement the interval serves, while joining to CS_COUNTERS resolves the meter name for counter-driven intervals. Reporting use cases include listing all counter-based intervals by counter to forecast upcoming meter triggers, auditing tolerance settings for a maintenance program, and extracting intervals that reference the same effectivity to detect overlapping or duplicate cadences. The OBJECT_VERSION_NUMBER column supports optimistic locking, so update statements should include the version predicate.

Related Objects

The following objects are the most significant participants in the documented relationship graph:

• AHL_MR_EFFECTIVITIES — joined on AHL_MR_INTERVALS.MR_EFFECTIVITY_ID; the parent effectivity record whose frequency this table defines.
• CS_COUNTERS — joined on AHL_MR_INTERVALS.COUNTER_ID; supplies the counter or meter used for counter-based intervals.
• AHL_UNIT_EFFECTIVITIES_B — references AHL_MR_INTERVALS.MR_INTERVAL_ID; the unit-level effectivity that consumes an interval definition.
• FND_SECURITY_GROUPS — joined on AHL_MR_INTERVALS.SECURITY_GROUP_ID; governs secured access to interval rows.
• Standard WHO and descriptive flexfield infrastructure tables in the FND schema, referenced through the ATTRIBUTE columns.