Results for “ak_objects_tl”

50+ results




Overview
Explore in AI Chat

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

Overview

AK_OBJECTS_TL is the translation (TL) table for AK_OBJECTS within the AK – Common Modules-AK product in Oracle E-Business Suite. AK_OBJECTS serves as the metadata repository for the Oracle Application Object Library and the Oracle EBS "AK" region/attribute framework, storing definitions of database objects, regions, and attributes that drive the OA Framework and MRC-related metadata. The "_TL" suffix indicates that this table holds language-specific, translatable text attributes — specifically the NAME and DESCRIPTION of each object — keyed by the base object identifier and a LANGUAGE code. The base table AK_OBJECTS stores the non-translatable structural definition; AK_OBJECTS_TL supplies the human-readable labels for each installed language.

From a Data Vault modeling standpoint, the heuristic classification of AK_OBJECTS_TL is satellite-leaning. It functions as a satellite attached to the AK_OBJECTS hub, carrying descriptive and language-dependent attributes rather than representing an independent business entity or relationship.

Key Information Stored

AK_OBJECTS_TL contains 11 documented columns. The most significant are:

  • DATABASE_OBJECT_NAME – Part of the composite primary key (AK_OBJECTS_TL_PK) and the foreign key to AK_OBJECTS. It identifies the base database object whose translation is being stored.
  • LANGUAGE – The other component of the primary key, indicating the language of the translated text (e.g., US, DE, FR).
  • NAME – The translated display name of the object in the given language.
  • DESCRIPTION – The translated description of the object.
  • SOURCE_LANG – The source language from which the translation was derived.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit/WHO columns tracking row creation and modification.
  • ZD_EDITION_NAME – Editioning column supporting Oracle EBS 12.2 online patching and edition-based redefinition.

The primary key is the surrogate/business composite AK_OBJECTS_TL_PK (DATABASE_OBJECT_NAME, LANGUAGE). A unique index AK_OBJECTS_TL_U1 (DATABASE_OBJECT_NAME, LANGUAGE, ZD_EDITION_NAME) acts as the business-key candidate, extending the PK with the edition name to enforce uniqueness across editions. The only documented foreign key is AK_OBJECTS_TL.DATABASE_OBJECT_NAME → AK_OBJECTS.

Common Use Cases and Queries

AK_OBJECTS_TL is typically queried to resolve translated labels for AK metadata objects, often joined back to AK_OBJECTS. A common pattern retrieves the localized name and description for a given language:

  • Join AK_OBJECTS_TL to AK_OBJECTS on DATABASE_OBJECT_NAME to combine structural metadata with its translated text.
  • Filter by LANGUAGE to display object names in a specific locale.
  • Filter by ZD_EDITION_NAME to isolate the correct edition during or after an online patch cycle in 12.2.2.
  • Report on which objects lack a translation for a target language by comparing base rows against TL rows (outer join with NULL check).
  • Audit translation currency using LAST_UPDATE_DATE and SOURCE_LANG.

A representative query pattern filters AK_OBJECTS_TL WHERE LANGUAGE = :lang joined to AK_OBJECTS USING (DATABASE_OBJECT_NAME).

Related Objects

  • AK_OBJECTS – The base (non-translated) table; parent in the FK relationship via DATABASE_OBJECT_NAME.
  • AK_OBJECTS_TL_PK – Primary key constraint (DATABASE_OBJECT_NAME, LANGUAGE).
  • AK_OBJECTS_TL_U1 – Unique index (DATABASE_OBJECT_NAME, LANGUAGE, ZD_EDITION_NAME).
  • AK_OBJECT_ATTRIBUTES and related AK attribute/region tables – Reference the same object namespace.
  • FND_LANGUAGES – Resolves the LANGUAGE code to installed language descriptions.
  • AK_REGIONS / OA framework metadata tables – Depend on AK object definitions for rendering.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS – Contextualize the AK product scope.

Because AK_OBJECTS_TL is the sole documented translation satellite for AK_OBJECTS, its integrity depends on the AK_OBJECTS parent row existing for every DATABASE_OBJECT_NAME value.