Results for “ahl_space_unavailable_b”

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

Overview

The AHL_SPACE_UNAVAILABLE_B table is a foundational database object within the Oracle E-Business Suite (EBS) module AHL – Complex Maintenance Repair and Overhaul. It stores information about space restrictions, recording periods during which specific physical spaces or locations within a maintenance, repair, or overhaul facility are unavailable for use. This capability is essential in complex MRO environments, where hangars, bays, docks, test cells, and specialized work areas must be scheduled and reserved. By tracking unavailability windows, the application prevents double-booking and supports accurate capacity planning across maintenance execution.

The table resides in the AHL schema and is marked VALID in both Oracle EBS 12.1.1 and 12.2.2. Its physical schema is documented with 27 columns. Based on the foreign key structure, the heuristic Data Vault classification is satellite-leaning. In a Data Vault modeling sense, this suggests the table behaves as a satellite attached to the space entity, capturing descriptive, time-bounded attributes about a parent space rather than defining a standalone business entity or a pure many-to-many link.

Key Information Stored

The table is anchored by the surrogate primary key SPACE_UNAVAILABILITY_ID, enforced through the AHL_SPACE_UNAVAILABLE_B_PK constraint and reinforced by the unique index AHL_SPACE_UNAVAILABLE_B_U1. This identifier is the business-key candidate used across dependent objects.

• SPACE_UNAVAILABILITY_ID — Surrogate primary key and unique business-key candidate; the join key to translations and external references.
• SPACE_ID — Foreign key to AHL_SPACES_B; identifies the space whose availability is being restricted.
• START_DATE and END_DATE — Define the effective interval of the unavailability window, the core scheduling data.
• OBJECT_VERSION_NUMBER — Supports optimistic locking and concurrent-update control.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS; enforces multi-tenant/multi-org data security.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified the record.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The DFF (Descriptive Flexfield) columns enabling customer-specific extension without schema modification.

Common Use Cases and Queries

Typical scenarios include determining whether a space is free for a given maintenance window, generating availability reports, and feeding scheduling engines. A standard query joins availability restrictions to the parent space:

• Find current/future restrictions: SELECT space_id, start_date, end_date FROM ahl_space_unavailable_b WHERE TRUNC(SYSDATE) <= NVL(end_date, SYSDATE);
• Check conflicts for a proposed window: ... WHERE space_id = :p_space AND start_date < :p_end AND NVL(end_date, :p_end) > :p_start;
• Join to space master data: SELECT b.space_unavailability_id, s.space_code FROM ahl_space_unavailable_b b, ahl_spaces_b s WHERE b.space_id = s.space_id;
• Retrieve translated descriptions: join to AHL_SPACE_UNAVAILABLE_TL on SPACE_UNAVAILABILITY_ID.

Reporting use cases include space utilization dashboards, downtime analysis, and planned-outage calendars for MRO facilities.

Related Objects

• AHL_SPACES_B — Parent space entity; joins on SPACE_ID. Provides the space master record.
• AHL_SPACE_UNAVAILABLE_TL — Translation table referencing SPACE_UNAVAILABILITY_ID; stores language-specific descriptions.
• FND_SECURITY_GROUPS — Security framework reference via SECURITY_GROUP_ID, governing row-level access.
• AHL_SPACE_UNAVAILABLE_B_PK / _U1 — Primary-key constraint and unique index enforcing identifier integrity.
• AHL_SPACES_TL — Companion translation of the parent space, frequently joined for fully described availability reporting.

Together these objects form the space-availability sub-model within AHL, supporting both transactional scheduling and analytical reporting.