Results for “attribute_label_short”

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

Overview

AK_OBJECT_ATTRIBUTES_TL is the translation (language) table for AK_OBJECT_ATTRIBUTES within the AK — Common Modules product family of Oracle E-Business Suite. It resides in the AK schema and holds the language-specific presentation attributes associated with registered Oracle EBS application objects. In Oracle EBS 12.1.1 and 12.2.2, this table supports the Oracle Application Framework (OAF) and related AK metadata infrastructure, allowing attribute labels and descriptions to be rendered in a user's session language rather than in a single base language.

The table is a satellite table in Data Vault modeling terms. The heuristic classification derived from the foreign key structure confirms this: it carries descriptive, language-dependent attributes that change over time and reference the base AK_OBJECT_ATTRIBUTES entity, rather than acting as a hub (business key) or a link (relationship). Designers should treat it as a dependent satellite keyed by language and edition context.

Key Information Stored

AK_OBJECT_ATTRIBUTES_TL contains 13 documented columns. The most business-significant columns are:

• DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID — the composite foreign key referencing AK_OBJECT_ATTRIBUTES. These identify the specific object and attribute being translated.
• LANGUAGE — the NLS language code identifying which translation is stored. Combined with the three columns above, it forms the primary key AK_OBJECT_ATTRIBUTES_TL_PK.
• ATTRIBUTE_LABEL_LONG and ATTRIBUTE_LABEL_SHORT — the translated display labels used in the UI when the session language matches.
• SOURCE_LANG — indicates the source language from which the translation was derived.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard who-columns for audit and concurrency control.
• ZD_EDITION_NAME — the edition context used in EBS 12.2's edition-based redefinition (EBR) mechanics.

The surrogate PK is the composite AK_OBJECT_ATTRIBUTES_TL_PK. The unique index AK_OBJECT_ATTRIBUTES_TL_U1 (DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID, LANGUAGE, ZD_EDITION_NAME) functions as the true business key and additionally scopes the row to an edition, which is essential for online patching in 12.2.x.

Common Use Cases and Queries

Typical usage involves resolving a user's attribute labels based on LANGUAGE and, in 12.2, on the active edition. A common reporting query joins the translation table to the base table:

• SELECT a.DATABASE_OBJECT_NAME, a.ATTRIBUTE_CODE, t.ATTRIBUTE_LABEL_SHORT FROM AK_OBJECT_ATTRIBUTES a, AK_OBJECT_ATTRIBUTES_TL t WHERE a.DATABASE_OBJECT_NAME = t.DATABASE_OBJECT_NAME AND a.ATTRIBUTE_CODE = t.ATTRIBUTE_CODE AND a.ATTRIBUTE_APPLICATION_ID = t.ATTRIBUTE_APPLICATION_ID AND t.LANGUAGE = USERENV('LANG');
• Translations completeness checks — detecting attributes lacking rows for a target LANGUAGE.
• Auditing who modified a label, using LAST_UPDATED_BY and LAST_UPDATE_DATE.
• EBS 12.2 edition-aware reporting that filters on ZD_EDITION_NAME.

Related Objects

The principal related objects are:

• AK_OBJECT_ATTRIBUTES — the base table; joined on DATABASE_OBJECT_NAME, ATTRIBUTE_CODE, and ATTRIBUTE_APPLICATION_ID.
• AK_OBJECTS (base) and its translation tables — the broader AK metadata registry into which these object attribute translations feed.
• FND_LANGUAGES — validated against LANGUAGE for the active NLS environment.
• AK_REGIONS and associated OAF metadata tables — consumers of the translated labels for UI rendering.

These relationships make AK_OBJECT_ATTRIBUTES_TL an important, if infrastructure-focused, component of the AK metadata and OAF presentation layer in Oracle EBS 12.1.1 and 12.2.2.