Search Results ahl_unit_thresholds

Overview

The AHL_UNIT_THRESHOLDS table is a core data object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). It serves as the primary repository for storing threshold values associated with specific item instances (serialized units or components). These thresholds represent the "Due at" counter values that trigger maintenance requirements. The table is essential for managing condition-based maintenance, as it holds the baseline or target counter readings against which actual usage is compared to determine when a maintenance task becomes due. Its data is populated either from production systems or during the initial setup of a component when historical accomplishment data is unavailable.

Key Information Stored

The table's structure is designed to link a threshold to a specific unit effectivity and counter. The primary identifier is the UNIT_THRESHOLD_ID. The most critical functional columns are UNIT_EFFECTIVITY_ID and COUNTER_ID, which together form a unique key (AHL_UNIT_THRESHOLDS_UK1). This combination ties a specific threshold value to a particular maintenance requirement (unit effectivity) for a given measurement counter (e.g., flight hours, cycles, miles). The table also includes a foreign key column, UNIT_DEFERRAL_ID, which links the threshold to any applicable deferral records, allowing the system to track instances where a due task has been formally postponed.

Common Use Cases and Queries

A primary use case is generating work orders by identifying item instances that have reached or exceeded their defined thresholds. Planners run processes that compare current counter readings from the item instance against the "Due at" values stored in this table. Common reporting queries involve joining this table with unit effectivity and item instance data to list all active thresholds for an asset. A sample SQL pattern to find due thresholds for a specific counter would be:

• SELECT aut.unit_effectivity_id, aut.counter_id, [current_counter_value] FROM ahl_unit_thresholds aut, ahl_unit_effectivities_b aue WHERE aue.unit_effectivity_id = aut.unit_effectivity_id AND [current_counter_value] >= aut.due_counter_value;

The table is also crucial during the initial provisioning of a new component into the maintenance program, where initial threshold values are established.

Related Objects

The table maintains defined relationships with other key AHL entities through its primary and foreign keys. Its primary key, AHL_UNIT_THRESHOLDS_PK, is on the UNIT_THRESHOLD_ID column. The documented foreign key relationship shows that the table references another object via its UNIT_DEFERRAL_ID column. As per the provided metadata, this is a self-reference: AHL_UNIT_THRESHOLDS.UNIT_DEFERRAL_ID is a foreign key to the AHL_UNIT_THRESHOLDS table itself (likely to a parent threshold record associated with a deferral). Furthermore, the unique key (AHL_UNIT_THRESHOLDS_UK1) on UNIT_EFFECTIVITY_ID and COUNTER_ID implies a strong relationship with the AHL_UNIT_EFFECTIVITIES_B table and the counter definition tables, which are essential for contextualizing the threshold data.