Results for “ahl_unit_deferrals_tl_u1”

10 results




Overview
Explore in AI Chat

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

Overview

AHL.AHL_UNIT_DEFERRALS_TL is the translation ("_TL") table that stores language-dependent columns for the base deferral entity AHL.AHL_UNIT_DEFERRALS_B in the Oracle E-Business Suite AHL (Complex Maintenance, Repair, and Overhaul / Advanced Service) schema. In the EBS 12.1.1 and 12.2.2 data model, a base table holds the language-independent attributes of a business entity, while its companion _TL table carries the translatable text columns keyed by language. Every deferral row in the base table may therefore have one or more corresponding translation rows here, one per installed language in which descriptive text has been entered. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and is marked VALID in the ETRM documentation.

From a Data Vault modeling perspective, the metadata suggests this object is satellite-leaning: it is dependent on the hub/business-key structure of its parent (_B) table and holds descriptive, context-bearing attributes rather than defining new relationships. It functions as a descriptive satellite keyed by (UNIT_DEFERRAL_ID, LANGUAGE).

Key Information Stored

The table contains eleven documented columns. Its primary key is AHL_UNIT_DEFERRALS_TL_PK, defined on (UNIT_DEFERRAL_ID, LANGUAGE), and the unique index AHL_UNIT_DEFERRALS_TL_U1 is documented on the same columns (UNIT_DEFERRAL_ID, LANGUAGE), making it the business-key candidate for this object. UNIT_DEFERRAL_ID is a NUMBER and the foreign key referencing the base table AHL_UNIT_DEFERRALS_B.

  • UNIT_DEFERRAL_ID — surrogate/foreign key to the base deferral record.
  • LANGUAGE — the language code identifying which translated row this is; part of the composite key.
  • SOURCE_LANG — the actual source language of the translated columns, used by the EBS translation framework.
  • REMARKS — VARCHAR2(4000), the translated remarks text for the deferral.
  • APPROVER_NOTES — VARCHAR2(4000), translated approver notes captured when a deferral is rejected.
  • SECURITY_GROUP_ID — NUMBER, used for application hosting; foreign key to FND_SECURITY_GROUPS.
  • Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide audit and concurrency tracking.

Common Use Cases and Queries

This table is queried whenever deferral remarks or approver notes must be displayed in a specific session language. Application code joins the translation table to the base table on UNIT_DEFERRAL_ID and filters LANGUAGE to the current runtime language (or falls back to SOURCE_LANG). A representative reporting pattern:

  • Joining translations to base: SELECT b.UNIT_DEFERRAL_ID, t.LANGUAGE, t.REMARKS, t.APPROVER_NOTES FROM AHL.AHL_UNIT_DEFERRALS_B b, AHL.AHL_UNIT_DEFERRALS_TL t WHERE b.UNIT_DEFERRAL_ID = t.UNIT_DEFERRAL_ID AND t.LANGUAGE = USERENV('LANG');
  • Auditing rejected deferrals by retrieving APPROVER_NOTES for a given deferral and language.
  • Multi-language reporting, comparing REMARKS across languages via the SOURCE_LANG column.
  • Data-quality checks confirming every base deferral has a translation row in each required language.

Related Objects

The most significant related objects, grounded in the documented dependencies and foreign keys, include:

  • AHL.AHL_UNIT_DEFERRALS_B — base table; the parent keyed by UNIT_DEFERRAL_ID (referenced FK).
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for application hosting.
  • AHL_UNIT_DEFERRALS_TL# — the internal object that references this table per the dependency listing.
  • AHL_UNIT_DEFERRALS_TL_U1 and AHL_UNIT_DEFERRALS_TL_PK — unique indexes enforcing the composite key.
  • FND Design Data object AHL.AHL_UNIT_DEFERRALS_TL — the AOL-registered definition used by the translation framework.

Because the table stores only translated text, any application that displays deferral remarks or approver notes depends on it, and AHL service/unit maintenance forms and concurrent programs join it to the base table on the deferral identifier.