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:
- UF_HEADER_ID — surrogate primary key and the unique business-key candidate in index AHL_UF_HEADERS_U1; the value users search for when drilling into a forecast.
- UNIT_CONFIG_HEADER_ID — FK to AHL_UNIT_CONFIG_HEADERS, identifying the unit configuration being forecast; also enforced by unique index AHL_UF_HEADERS_U2.
- PC_NODE_ID — FK to AHL_PC_NODES_B, tying the forecast to a specific project or planning node; enforced by unique index AHL_UF_HEADERS_U3.
- INVENTORY_ITEM_ID — FK to MTL_SYSTEM_ITEMS_B, the inventory item being forecast; enforced by unique index AHL_UF_HEADERS_U4.
- INVENTORY_ORG_ID — the inventory organization in which the item resides.
- CSI_ITEM_INSTANCE_ID — FK to CSI_ITEM_INSTANCES, linking the forecast to a specific installed/fielded instance.
- USE_UNIT_FLAG — flag governing whether unit-based utilization is applied.
- SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS, driving row-level access control.
- OBJECT_VERSION_NUMBER — optimistic locking counter maintained by the AHL OAF UI.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard who-columns for audit and concurrency.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF placeholder columns available for customer extensions.
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.
-
This table stores information about utilization forecast header.
-
This table stores information about utilization forecast header.
-
SYNONYM: APPS.AHL_UF_HEADERS 12.2.2
-
SYNONYM: APPS.AHL_UF_HEADERS 12.1.1
-
TABLE: AHL.AHL_UF_HEADERS 12.1.1
-
TABLE: AHL.AHL_UF_HEADERS 12.2.2
-
This view holds the utilization forecast header information and utilization forcast details.
APPS.AHL_UTILIZATION_FORECAST_V·↳ AHL_UF_DETAILS·↳ AHL_UF_HEADERS·Explore AHL module →
-
VIEW: AHL.AHL_UF_HEADERS# 12.2.2
-
This view holds the utilization forecast header information and utilization forcast details.
APPS.AHL_UTILIZATION_FORECAST_V·↳ AHL_UF_DETAILS·↳ AHL_UF_HEADERS·Explore AHL module →
-
This table stores information about unit forcast details
-
This table stores information about unit forcast details
-
VIEW: AHL.AHL_UF_HEADERS# 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
TABLE: AHL.AHL_UF_DETAILS 12.1.1