Results for “ak_attributes_tl_pk”

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

Overview

AK_ATTRIBUTES_TL is the translation (language-dependent) table for AK_ATTRIBUTES within the AK – Common Modules-AK product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the multilingual descriptive text associated with attribute definitions maintained by the Oracle Application Object Library and the Extensible Attribute / Descriptive Flexfield framework. For each attribute row in AK_ATTRIBUTES, this table holds one row per installed language (LANGUAGE), supplying the user-facing labels and descriptions that appear on forms, reports, and self-service pages. It is not a transactional table; it is metadata infrastructure that drives how attribute prompts are rendered to end users in their session language.

The owner schema is AK, the object status is VALID, and the documented column count is 14 in the 12.2.2 physical schema. The ETRM metadata classifies the table heuristically as satellite-leaning in a Data Vault sense. This should be treated as a modeling suggestion: the table behaves as a descriptive satellite keyed to the AK_ATTRIBUTES hub by attribute identity, with LANGUAGE acting as an additional differentiating attribute supplying localized descriptive content.

Key Information Stored

The primary key is the composite AK_ATTRIBUTES_TL_PK, defined over three columns:

• ATTRIBUTE_CODE – the attribute identifier; also part of the foreign key back to AK_ATTRIBUTES.
• ATTRIBUTE_APPLICATION_ID – the owning application, completing the foreign key to AK_ATTRIBUTES.
• LANGUAGE – the NLS language code for the translated row.

A separate unique index, AK_ATTRIBUTES_TL_U1, adds ZD_EDITION_NAME to the same three columns, representing the business-key candidate under the edition-based redefinition (EBR) model used in 12.2.x.

The principal translated content columns are:

• NAME – the display name of the attribute in the given language.
• ATTRIBUTE_LABEL_LONG – the long-form label used on forms and pages.
• ATTRIBUTE_LABEL_SHORT – the condensed label used where space is constrained, such as list columns.
• DESCRIPTION – explanatory text shown in help or lookup contexts.
• SOURCE_LANG – the language of the source (typically US) row from which the translation derives.

Standard EBS who-columns are also present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ZD_EDITION_NAME for EBR edition tracking.

Common Use Cases and Queries

Reporting and troubleshooting typically join the translation table back to the base via the composite FK. A representative query retrieves localized labels for a given attribute:

• Join AK_ATTRIBUTES a to AK_ATTRIBUTES_TL t on t.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE and t.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID, filtering by t.LANGUAGE = userenv('LANG').
• Diagnose missing-translation defects by left-joining AK_ATTRIBUTES to AK_ATTRIBUTES_TL and selecting rows where the translated NAME is null, revealing attributes lacking a row for a target language.
• Audit translation currency by comparing LAST_UPDATE_DATE between the base and translation rows.
• In 12.2.x, filter or group by ZD_EDITION_NAME to isolate the active edition during upgrades.

These queries are common during multilanguage implementations, localization testing, and post-patch validation.

Related Objects

• AK_ATTRIBUTES – the base (language-independent) table; joined via ATTRIBUTE_CODE and ATTRIBUTE_APPLICATION_ID.
• AK_ATTRIBUTES_TL_PK – the composite primary key constraint supporting unique access.
• AK_ATTRIBUTES_TL_U1 – the EBR-aware unique index.
• AK_ATTRIBUTES_VL – the translated views layered over the base and translation tables for NLS-aware access.
• FND_LANGUAGES – supplies valid LANGUAGE codes and installed-language status.
• AK_ATTRIBUTE_GROUPS / AK_REGIONS – related AK metadata describing how attributes are grouped and presented.

Together these objects form the attribute-metadata layer used by the Oracle EBS common modules.