Search Results uf_header_id




Overview
Explore in AI Chat

Overview

The AHL_UF_HEADERS table is a core data object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (AHL). It functions as the primary repository for header-level information pertaining to utilization forecasts. A utilization forecast is a critical planning tool used to predict the future usage, wear, or operational cycles of a high-value asset or component, enabling proactive maintenance scheduling and resource planning. This table anchors the forecast by defining the asset or configuration being analyzed and serves as the parent entity for detailed forecast line items stored in the related AHL_UF_DETAILS table.

Key Information Stored

The table's primary identifier is the UF_HEADER_ID column, which is its primary key. Key relational columns establish links to other fundamental EBS entities, defining the scope of the forecast. The UNIT_CONFIG_HEADER_ID links to the AHL_UNIT_CONFIG_HEADERS table, associating the forecast with a specific unit configuration or assembly. The CSI_ITEM_INSTANCE_ID provides a direct foreign key to the CSI_ITEM_INSTANCES table, tying the forecast to a specific installed item instance. Alternatively, a forecast can be linked to a generic item and organization via the INVENTORY_ITEM_ID and INVENTORY_ORG_ID columns, which reference MTL_SYSTEM_ITEMS_B. The PC_NODE_ID column links to the AHL_PC_NODES_B table, allowing the forecast to be associated with a specific node in a product configuration model.

Common Use Cases and Queries

This table is central to reporting and data extraction for asset utilization analysis. A common use case involves generating a list of all utilization forecasts for a specific asset configuration to review planning history. Another typical scenario is joining forecast headers to their detail lines to analyze predicted usage metrics over time. A sample query to retrieve basic forecast header information with associated asset details might follow this pattern:

  • SELECT ufh.uf_header_id, ufh.unit_config_header_id, uch.unit_config_number, msib.segment1 item_code FROM ahl_uf_headers ufh, ahl_unit_config_headers uch, mtl_system_items_b msib WHERE ufh.unit_config_header_id = uch.unit_config_header_id AND ufh.inventory_item_id = msib.inventory_item_id AND ufh.inventory_org_id = msib.organization_id;

Data from this table is also integral to APIs and business logic that create, update, or process utilization forecasts within the AHL module's workflows.

Related Objects

The AHL_UF_HEADERS table maintains defined foreign key relationships with several key EBS tables, as documented in the ETRM metadata. It is a child table to:

  • AHL_UNIT_CONFIG_HEADERS via UNIT_CONFIG_HEADER_ID.
  • MTL_SYSTEM_ITEMS_B via the composite key of INVENTORY_ITEM_ID and INVENTORY_ORG_ID.
  • CSI_ITEM_INSTANCES via CSI_ITEM_INSTANCE_ID.
  • AHL_PC_NODES_B via PC_NODE_ID.

Conversely, it acts as a parent table to:

  • AHL_UF_DETAILS, which stores the detailed line items for each forecast, linked via UF_HEADER_ID.