Search Results csi_ctr_property_template_tl

Overview

CSI_CTR_PROPERTY_TEMPLATE_TL is a translation (TL) table within the CSI — Install Base product schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the language-specific, translated text for counter template properties defined in the Install Base module. Counter templates are used to define the metadata and behavior of counters associated with installed base assets, enabling customers to track usage, meter readings, and performance metrics on customer products. The base definition of each counter property resides in the corresponding non-TL table, while this table holds the translated NAME and DESCRIPTION values for each supported language.

Because it carries descriptive, attribute-level context keyed to a parent entity, the heuristic Data Vault classification mined from the foreign-key structure suggests this object is best modeled as a satellite. The table is treated as standalone in the relationship data vault classification, with its principal external reference being SECURITY_GROUP_ID toward FND_SECURITY_GROUPS.

Key Information Stored

The table is composed of 12 documented columns. The most significant are:

• COUNTER_PROPERTY_ID — Surrogate identifier linking the translation row back to the parent counter property definition in the base table. It forms part of both the primary key and the unique business-key candidate.
• LANGUAGE — The NLS language code identifying the locale of the translated text; part of the composite primary key.
• NAME — The translated display name of the counter property.
• DESCRIPTION — The translated descriptive text for the counter property.
• SOURCE_LANG — The source language from which the translation was derived, used by the standard EBS translation framework.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant / operating unit data segregation.
• MIGRATED_FLAG — Indicator used during data migration to mark records processed by upgrade or conversion routines.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO-column audit trail capturing creation and last modification metadata.

The surrogate primary key is CSI_CTR_PROP_TEMPLATE_TL_PK (LANGUAGE, COUNTER_PROPERTY_ID). A separate unique index, CSI_CTR_PROPERTY_TEMPLATE_TL_U01 (COUNTER_PROPERTY_ID, LANGUAGE), enforces business-key uniqueness on the same column pair.

Common Use Cases and Queries

Typical usage patterns include building multi-language reports of counter templates, validating translation completeness, and joining translations to parent definitions. A representative query to retrieve translations for a given locale is:

• SELECT t.counter_property_id, t.name, t.description, t.language FROM csi_ctr_property_template_tl t WHERE t.language = USERENV('LANG');

Translation completeness reporting compares the base table against available languages:

• SELECT b.counter_property_id, t.language FROM csi_ctr_property_template_b b, csi_ctr_property_template_tl t WHERE b.counter_property_id = t.counter_property_id(+);

System administrators and localization teams use these queries to identify counter properties missing translations, audit security-group assignments, and verify that MIGRATED_FLAG has been set correctly after an upgrade or data conversion.

Related Objects

The following objects are most significant to this table:

• CSI_CTR_PROPERTY_TEMPLATE_B — The base (non-translated) table carrying the primary definition of each counter property, joined on COUNTER_PROPERTY_ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID to scope rows to a security group.
• CSI_CTR_PROPERTY_TEMPLATES — The counter template header table whose properties this translation supports.
• CSI_COUNTER_TEMPLATES — Template definitions used when constructing counters against installed base assets.
• FND_LANGUAGES — Provides the valid LANGUAGE codes used in the LANGUAGE column.
• CSI_INSTALLED_BASE_PUB / CSI_CTR_PROPERTY_PUB APIs — Public APIs that surface translated property names to Install Base counter configuration screens.