Search Results ahl_fleet_headers_b




Overview
Explore in AI Chat

Overview

AHL_FLEET_HEADERS_B is the base table that stores fleet definitions within the Oracle E-Business Suite Complex Maintenance, Repair and Overhaul (AHL) module. In EBS 12.1.1 and 12.2.2, a "fleet" represents a logical grouping of maintainable units — aircraft, vehicles, engines, or other rotable assets — that are managed and maintained together under shared operational and departmental ownership. The header record established in this table anchors all subsequent fleet-level maintenance activity performed through the AHL maintenance management and execution flows.

Under the heuristic Data Vault classification mined from the foreign key structure, this table is modeled as a standalone entity. This suggests that, in a Data Vault representation, AHL_FLEET_HEADERS_B behaves as an independent hub or reference dimension rather than a link table joining two or more business keys. The classification is a modeling suggestion based on the observed FK topology and should be validated against the formal AHL data model before being used for warehouse design.

Key Information Stored

The table carries 30 documented columns. The most significant are:

Common Use Cases and Queries

The table is primarily queried to resolve fleet names, validate org-level access, and drive fleet-based maintenance reporting. A typical lookup joins the header to its department:

SELECT f.fleet_header_id, f.name, f.status_code, d.department_code
FROM ahl_fleet_headers_b f, bom_departments d
WHERE f.department_id = d.department_id
AND f.operating_org_id = :org_id;

Common reporting scenarios include listing all active fleets per operating organization, auditing fleets by department for maintenance cost roll-up, and extracting DFF attributes for customer-specific fleet categorization. Because the table is multi-org secured, any reporting query should filter by OPERATING_ORG_ID or run within the appropriate MOAC context. Extraction queries for data warehousing should include OBJECT_VERSION_NUMBER and the WHO columns to enable reliable incremental loads.

Related Objects

  • BOM_DEPARTMENTS — joined via DEPARTMENT_ID; supplies the responsible maintenance department.
  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; drives data security filtering.
  • AHL_FLEET_HEADERS_TL — the translation table supplying language-specific fleet names and descriptions.
  • AHL_MAINTAINABLE_OBJECTS / AHL_UNITS — the maintainable units assigned to a fleet, linked through the fleet header.
  • AHL_FLEET_POSITIONS or AHL_FLEET_MEMBERS — child entities defining unit positions or membership within the fleet.
  • AHL_MAINTENANCE_* interfaces — the AHL maintenance work-order and visit APIs that consume fleet headers when creating maintenance visits for units in the fleet.

Together, these related objects form the fleet maintenance hierarchy, with AHL_FLEET_HEADERS_B serving as the definitional anchor for units, positions, and maintenance execution.