Search Results ak_custom_region_items_tl




Overview
Explore in AI Chat

Overview

AK_CUSTOM_REGION_ITEMS_TL is the translation (TL) table corresponding to AK_CUSTOM_REGION_ITEMS in the Oracle E-Business Suite AK (Common Modules–AK) product. The AK module underpins the Oracle Application Framework's extensible region and attribute model, allowing administrators to configure custom regions, attributes, and their associated display properties without modifying base application code. The base table stores the primary (source-language) definitions, while this TL table stores the language-specific renditions of each customizable property, keyed by the LANGUAGE column. In a 12.1.1 or 12.2.2 environment, the TL table is the authoritative source for translated property values presented at runtime when users select a non-base language.

The ETRM metadata classifies this object heuristically as standalone from a Data Vault modeling perspective—it is not modeled as a hub, link, or satellite because no foreign-key relationships were mined. Where a surrogate key exists in the base table, the TL table here relies on a composite natural key rather than a generated surrogate. Practically, the TL table functions as a satellite-like extension of the base entity, but the documented classification remains standalone.

Key Information Stored

The table contains 16 documented columns in the 12.2.2 physical schema. The most significant are:

The primary key is AK_CUSTOM_REGION_ITEMS_TL_PK, comprising all eight business columns plus LANGUAGE. A unique index, AK_CUSTOM_REGION_ITEMS_TL_U1, mirrors this key and additionally includes ZD_EDITION_NAME, ensuring translation uniqueness per edition. There is no generated surrogate key; the business-key candidate is the composite uniqueness documented above.

Common Use Cases and Queries

Typical uses involve auditing and reporting on translated customization properties, verifying completeness of translations across languages, and joining to the base table for bilingual comparisons.

  • Listing all translations for a given region and attribute: 
    SELECT language, property_name, property_varchar2_value
FROM   ak.ak_custom_region_items_tl
WHERE  customization_code = :cust_code
AND    region_code = :region_code
AND    attribute_code = :attr_code;
  • Detecting missing translations by comparing base and TL rows, or flagging rows where LANGUAGE equals SOURCE_LANG.
  • Reporting the last update audit trail for translated properties to satisfy change-control reviews.
  • Joining to AK_CUSTOM_REGION_ITEMS to resolve the base value versus the translated value for a specific language.

Related Objects

  • AK_CUSTOM_REGION_ITEMS — the base table; join on the seven business columns shared with the TL table.
  • AK_CUSTOM_REGIONS / AK_CUSTOM_REGIONS_TL — parent region definitions referenced by REGION_APPLICATION_ID and REGION_CODE.
  • AK_ATTRIBUTES / AK_ATTRIBUTES_TL — attribute definitions referenced by ATTRIBUTE_APPLICATION_ID and ATTRIBUTE_CODE.
  • AK_CUSTOMIZATIONS — the customization header referenced by CUSTOMIZATION_APPLICATION_ID and CUSTOMIZATION_CODE.
  • FND_LANGUAGES — joins on LANGUAGE to resolve NLS language names.
  • FND_APPLICATION — resolves application IDs to application names for reporting.
  • AK_CUSTOM_REGION_ITEMS_TL_PK / AK_CUSTOM_REGION_ITEMS_TL_U1 — supporting indexes used by the join patterns above.