Results for “cn_dimensions_all_tl”

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

Overview

CN_DIMENSIONS_ALL_TL is a translation table within the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite. It stores the language-dependent, translated attributes of the dimension definitions maintained for incentive compensation processing. In EBS, dimension records represent the analytical breakdowns — such as sales channels, product categories, or territory groupings — that drive plan qualification, crediting, and measurement logic. Because these labels must be presented in each user's preferred language, the base definitions are held in a non-translated companion table while CN_DIMENSIONS_ALL_TL supplies the language-specific text.

From a data-modeling standpoint, the metadata classifies this object heuristically as standalone, meaning it does not participate in a strict hub, link, or satellite hierarchy within the Data Vault sense. As a modeling suggestion, the table behaves most like a descriptive satellite attached to the dimension business key, carrying the translated name attribute alongside the language and operating unit context rather than acting as a fact or relationship link.

Key Information Stored

The table retains twelve documented columns. The most significant are described below.

• DIMENSION_ID — The surrogate identifier for the dimension. It forms the leading element of the primary key and links each translated row back to the base dimension record.
• ORG_ID — The operating unit (multi-org) context, ensuring dimension translations are isolated by organization.
• LANGUAGE — The language code for the translated text, comprising the third component of the primary key.
• NAME — The translated display name of the dimension, and the business attribute that drives the CN_DIMENSIONS_ALL_TL_UK1 unique key.
• SOURCE_LANG — The source language from which the translation was derived, used by the translation framework for language comparison.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and supports data-level security filtering across the translated rows.
• ZD_EDITION_NAME — The editioning column characteristic of the 12.2 online patching architecture, included in both unique indexes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns maintained by the EBS who-column framework.

The surrogate primary key CN_DIMENSIONS_ALL_TL_UK combines DIMENSION_ID, ORG_ID, and LANGUAGE. Business-key candidates are captured by CN_DIMENSIONS_ALL_TL_U1 (DIMENSION_ID, ORG_ID, LANGUAGE, ZD_EDITION_NAME) and by CN_DIMENSIONS_ALL_TL_U2, which substitutes NAME for DIMENSION_ID and so enforces translated name uniqueness within an organization and language.

Common Use Cases and Queries

Typical usage centers on validation, name resolution for reporting, and translation completeness audits. Administrators frequently verify that every dimension has a translation in each installed language before going live with a multilingual deployment.

• Resolving translated dimension names for a user's session language:

  SELECT t.dimension_id, t.name FROM cn_dimensions_all_tl t WHERE t.language = USERENV('LANG') AND t.org_id = :org_id;

• Detecting dimensions missing a translation in a given language by outer-joining to the base dimension table.
• Confirming uniqueness of translated names per organization to prevent ambiguous prompt displays in compensation worksheets.
• Filtering rows by SECURITY_GROUP_ID when restricting report output to the appropriate security context.

Related Objects

The most significant related objects are:

• CN_DIMENSIONS_ALL_B — The base (non-translated) dimension table, joined on DIMENSION_ID and ORG_ID. Together the _B/_TL pair forms the standard EBS translation pattern.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID; controls which translated rows a responsibility may access.
• CN_DIMENSIONS_ALL_VL — The translated view that abstracts the _B and _TL join for user-facing queries and forms.
• CN_DIMENSIONS_VL — The organization-specific translated view exposing dimension names to runtime features.
• CN_TP_MAPPINGS — Transaction and plan mappings that consume dimension identifiers resolved to translated names.
• FND_LANGUAGES — Supplies the valid LANGUAGE codes and the meaning of SOURCE_LANG.

These relationships make CN_DIMENSIONS_ALL_TL a dependency for any component that must present incentive compensation dimensions in a language-aware manner.