Results for “ak_foreign_keys_tl”

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

Overview

AK_FOREIGN_KEYS_TL is the translation (TL) table for AK_FOREIGN_KEYS, residing in the AK schema, which belongs to the Common Modules-AK product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The AK module underpins the Oracle Application Object Library (FND) and provides the runtime metadata that describes application objects, including the foreign key definitions used by the Oracle Forms-based dictionary and by diagnostic utilities. Because foreign key metadata carries user-facing labels and descriptive text, Oracle stores those translatable attributes separately in a TL table keyed by language, keeping language-independent structural information in the base table and language-dependent text in this companion object.

Under a heuristic Data Vault classification mined from its foreign key structure, AK_FOREIGN_KEYS_TL is satellite-leaning. This is a modeling suggestion rather than a physical design fact: the table hangs off the AK_FOREIGN_KEYS business key and carries descriptive, language-qualified attributes, which is the classic signature of a satellite rather than a hub or a link.

Key Information Stored

The primary key, AK_FOREIGN_KEYS_TL_PK, is composed of FOREIGN_KEY_NAME and LANGUAGE. Together these form the composite identifier that links each translated row back to the parent AK_FOREIGN_KEYS record and pins it to a specific NLS language. A separate unique index, AK_FOREIGN_KEYS_TL_U1, covers FOREIGN_KEY_NAME, LANGUAGE, and ZD_EDITION_NAME, reflecting the edition-aware structure introduced in Release 12.2 multi-tenant architectures.

• FOREIGN_KEY_NAME — the business key of the parent foreign key definition; also the join column to AK_FOREIGN_KEYS.
• LANGUAGE — the NLS language code for the translated row, completing the primary key.
• FROM_TO_NAME / FROM_TO_DESCRIPTION — the translated display name and description for the parent-to-child relationship of the foreign key.
• TO_FROM_NAME / TO_FROM_DESCRIPTION — the translated display name and description for the inverse (child-to-parent) navigation.
• SOURCE_LANG — the language from which the row was originally seeded, used by the translation tooling.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who created and last modified each translated row.
• ZD_EDITION_NAME — the edition identifier supporting online patching and edition-based redefinition in 12.2.

All 13 documented columns follow the conventional EBS TL pattern, combining translation text with auditing and edition tracking.

Common Use Cases and Queries

Queries against this table typically resolve the translated friendly name of a foreign key relationship for a given language, or drive the Forms dictionary and diagnostics that render relationship labels. A typical lookup joins the translation to its parent:

• SELECT t.foreign_key_name, t.language, t.from_to_name, t.to_from_name FROM ak.ak_foreign_keys_tl t WHERE t.language = USERENV('LANG');
• Reporting on untranslated foreign keys by comparing AK_FOREIGN_KEYS rows against existing translations.
• Metadata extraction for data dictionary and impact-analysis utilities that need bilingual relationship descriptions.

Always filter by LANGUAGE (or use USERENV('LANG')) to avoid returning every translated row for a key.

Related Objects

• AK_FOREIGN_KEYS — the base (non-translated) table; joined on FOREIGN_KEY_NAME.
• AK_FOREIGN_KEY_COLUMNS — defines the column-level makeup of each foreign key, referenced by FOREIGN_KEY_NAME.
• AK_FOREIGN_KEYS_TL_PK / AK_FOREIGN_KEYS_TL_U1 — the primary and unique indexes enforcing identity.
• AK_TABLES / AK_TABLES_TL — the table-level metadata that foreign keys reference.
• AK_REGIONS / AK_ATTRIBUTES — sibling AK metadata objects sharing the same translation pattern and schema.
• FND_LANGUAGES — the source of valid LANGUAGE values used here.

These dependencies make AK_FOREIGN_KEYS_TL a small but integral part of the AK metadata fabric in both 12.1.1 and 12.2.2.