Results for “ahl_uf_headers”

50+ results




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

Overview

AHL_UF_HEADERS is the master header table for utilization forecasts within the Oracle E-Business Suite AHL (Complex Maintenance Repair and Overhaul) module. It stores the top-level definition of each utilization forecast, capturing which maintenance asset, unit configuration, and item instance the forecast applies to, along with the organizational context and security grouping needed for multi-org and access control. The table is primarily relevant to EBS Release 12.1.1 and 12.2.2, where AHL forms the backbone of complex MRO planning for repairable and rotable parts.

The primary key is UF_HEADER_ID, a surrogate identifier that uniquely keys each forecast header. From a Data Vault modeling perspective, the FK topology mined from the schema suggests a satellite-leaning classification: the table hangs off several parent hubs (unit configurations, item instances, PC nodes, and inventory items) and carries descriptive, time-stamped attributes typical of a satellite. Each header row appears once and is versioned via OBJECT_VERSION_NUMBER, so the pattern is closer to a hub-plus-satellite pairing than a link table.

Key Information Stored

The most significant columns are:

Common Use Cases and Queries

Typical usage centers on retrieving a header and its child detail lines, and on reporting forecast demand by item, instance, or organization. A direct lookup by the surrogate key is the most common starting point:

SELECT uf_header_id, unit_config_header_id, pc_node_id, inventory_item_id, inventory_org_id, csi_item_instance_id FROM ahl_uf_headers WHERE uf_header_id = :p_uf_header_id;

Joining to the detail table produces the full forecast structure:

SELECT h.uf_header_id, d.* FROM ahl_uf_headers h, ahl_uf_details d WHERE h.uf_header_id = d.uf_header_id AND h.inventory_item_id = :p_item_id;

Reporting frequently joins to MTL_SYSTEM_ITEMS_B for item descriptions and to CSI_ITEM_INSTANCES for serial numbers, and filters by INVENTORY_ORG_ID to scope multi-org reporting. Because SECURITY_GROUP_ID participates in access control, ad-hoc queries run outside the AHL UI must respect the security group filter that the application normally applies.

Related Objects

  • AHL_UF_DETAILS — child table; joined via AHL_UF_DETAILS.UF_HEADER_ID = AHL_UF_HEADERS.UF_HEADER_ID, holding the utilization forecast lines.
  • AHL_UNIT_CONFIG_HEADERS — parent unit configuration; joined via UNIT_CONFIG_HEADER_ID.
  • AHL_PC_NODES_B — planning/project node; joined via PC_NODE_ID.
  • MTL_SYSTEM_ITEMS_B — inventory item master; joined via INVENTORY_ITEM_ID and INVENTORY_ORG_ID.
  • CSI_ITEM_INSTANCES — installed base instance; joined via CSI_ITEM_INSTANCE_ID.
  • FND_SECURITY_GROUPS — security group definition; joined via SECURITY_GROUP_ID.