Results for “space_unavailability_id”

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

Overview

AHL_SPACE_UNAVAILABLE_TL is a translation (TL) table within the AHL schema, which supports the Complex Maintenance Repair and Overhaul (MRO) product in Oracle EBS 12.1.1 and 12.2.2. It stores language-specific, user-facing descriptive text for records that define space restrictions or space unavailability — for example, periods or locations in which a maintenance bay, hangar, dock, or similar facility is declared unavailable for scheduling or work execution. The "_TL" suffix indicates that the table follows the standard Oracle Applications multilingual pattern, where translatable attributes (here, the DESCRIPTION column) are held separately for each installed language, keyed by the base entity identifier plus the LANGUAGE code.

Its role in the EBS data model is strictly subordinate to its base table, AHL_SPACE_UNAVAILABLE_B, which owns the non-translatable, operational attributes. In Data Vault terms, the heuristic classification of this object is satellite-leaning: it hangs off the base entity by foreign key and carries descriptive context (translations) rather than independent business events. It should therefore be modeled as a descriptive satellite keyed to the base space-unavailability hub, not as a hub or link in its own right.

Key Information Stored

The documented physical schema contains ten columns. The most significant are:

• SPACE_UNAVAILABILITY_ID — the surrogate identifier of the parent base record in AHL_SPACE_UNAVAILABLE_B. Part of the composite primary key and the foreign key back to the base table.
• LANGUAGE — the NLS language code identifying which translation row applies. Together with SPACE_UNAVAILABILITY_ID, it forms the primary key AHL_SPACE_UNAVAILABLE_TL_PK and the unique index AHL_SPACE_UNAVAILABLE_TL_U1.
• DESCRIPTION — the translated, user-visible description of the space restriction. This is the primary payload of the table.
• SOURCE_LANG — the language of the source (base) record, used by the translation framework to determine the origin language.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing Multi-Org/security-group access control on the translated row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard Oracle Applications "WHO" audit columns tracking who created and last modified each translation row.

The surrogate primary key is AHL_SPACE_UNAVAILABLE_TL_PK on (SPACE_UNAVAILABILITY_ID, LANGUAGE). The business-key candidate is the unique index AHL_SPACE_UNAVAILABLE_TL_U1 on the same column pair; the true business identifier of the underlying restriction is inherited from the base table.

Common Use Cases and Queries

Typical uses include multilingual reporting on facility unavailability, validating that a required description exists for every active language, and joining translations back to base records for display in OAF or Forms-based MRO screens.

A standard join to the base table:

• SELECT b.space_unavailability_id, t.description, t.language FROM ahl_space_unavailable_b b, ahl_space_unavailable_tl t WHERE b.space_unavailability_id = t.space_unavailability_id AND t.language = USERENV('LANG');

Detecting missing translations (records lacking a row for a given language):

• SELECT b.space_unavailability_id FROM ahl_space_unavailable_b b WHERE NOT EXISTS (SELECT 1 FROM ahl_space_unavailable_tl t WHERE t.space_unavailability_id = b.space_unavailability_id AND t.language = 'US');

Audit-oriented queries can filter on LAST_UPDATE_DATE or SECURITY_GROUP_ID to isolate recently changed descriptions or restrict results to a security group.

Related Objects

• AHL_SPACE_UNAVAILABLE_B — base table holding operational attributes; joined via SPACE_UNAVAILABILITY_ID. This is the principal parent.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for access control.
• FND_LANGUAGES / FND_LANGUAGE — lookup of installed languages corresponding to the LANGUAGE column values.
• AHL_SPACE_UNAVAILABLE_TL_PK / AHL_SPACE_UNAVAILABLE_TL_U1 — primary key and unique index enforcing the (SPACE_UNAVAILABILITY_ID, LANGUAGE) relationship.
• AHL MRO scheduling and work-order objects — transactions that validate availability against the base table and surface the translated DESCRIPTION.

Because translations are maintained through the standard Oracle translation framework, INSERT/UPDATE access is generally performed by the framework rather than directly by end users; application logic should therefore treat this table as read-mostly.