Results for “csi_counter_template_tl”

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

Overview

CSI_COUNTER_TEMPLATE_TL is a translation (TL) table within the Oracle E-Business Suite Install Base module (CSI). It holds the language-specific, translated counter template data that backs the base counter template definition. In a multi-language Oracle EBS deployment, the base table (typically CSI_COUNTER_TEMPLATE_B) stores the operational counter template attributes, while this _TL companion stores the user-facing translatable text — the counter template NAME and DESCRIPTION — for each installed language. Counters in Install Base represent measured usage or meter values captured against an installed asset or instance, and templates provide the reusable definitions from which counters are instantiated. This table therefore supplies the localized labels that end users see when selecting or configuring counter templates.

From a data-modeling perspective, the metadata's heuristic classification is standalone. Because the only foreign key documented is a reference to FND_SECURITY_GROUPS (a security/reference table) rather than to a parent business entity, the table does not present the characteristic hub, link, or satellite join signature that mined FK structures normally reveal. It is best modeled as a satellite-style descriptor attached to the base counter template entity, keyed by the template identifier plus language, rather than as an independent hub in its own right.

Key Information Stored

The table contains 12 documented columns. The most significant are:

• COUNTER_ID — Part of the composite primary key; the surrogate identifier that links this translated row to its base counter template definition. This is the join column back to the base template entity.
• LANGUAGE — The second component of the composite primary key; the language code of the translated row. Together with COUNTER_ID it uniquely identifies each translation.
• SOURCE_LANG — Indicates the source language from which the translation was derived, supporting Oracle's multilingual (MLS) translation workflow.
• NAME — The translated name of the counter template, displayed to users in the corresponding language.
• DESCRIPTION — The translated descriptive text for the counter template.
• MIGRATED_FLAG — A flag indicating the migration status of the row, used during data conversion or upgrade activities.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and enforces multi-tenant/operating-unit data segregation.
• Standard audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

The surrogate/composite primary key is CSI_COUNTER_TEMPLATE_TL (COUNTER_ID, LANGUAGE). The unique index CSI_COUNTER_TEMPLATE_TL_U01 on (COUNTER_ID, LANGUAGE) serves as the business-key candidate, confirming that exactly one translation row exists per template per language.

Common Use Cases and Queries

The primary use case is localized reporting and display of counter template names. A typical query joins the translation table to the base table and restricts to the session or reporting language:

• Retrieve translated template names for a specific language:
  SELECT t.counter_id, t.name, t.description FROM csi_counter_template_tl t WHERE t.language = USERENV('LANG');
• Join back to the base template entity on the shared key:
  SELECT b.counter_id, t.name FROM csi_counter_template_b b, csi_counter_template_tl t WHERE b.counter_id = t.counter_id AND t.language = USERENV('LANG');
• Audit translation coverage by counting distinct languages per template:
  SELECT counter_id, COUNT(*) FROM csi_counter_template_tl GROUP BY counter_id HAVING COUNT(*) > 1;
• Identify rows flagged for migration: WHERE migrated_flag = 'Y'.

These patterns support multilingual UI rendering, translation completeness audits, and upgrade validation of the Install Base counter configuration.

Related Objects

• CSI_COUNTER_TEMPLATE_B — The base (non-translated) counter template table; joined on COUNTER_ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID to enforce data security segregation.
• FND_LANGUAGES — Provides the valid language codes referenced by the LANGUAGE column.
• CSI_COUNTERS — Counters instantiated from templates, indirectly linked through the base template entity.
• CSI_COUNTER_VALUES — Captured counter readings, dependent on counters and their templates.
• CSI_ITEM_INSTANCES — Installed instances to which counters and their localized templates apply.

Collectively these objects form the counter configuration and measurement chain in the Install Base module, with CSI_COUNTER_TEMPLATE_TL supplying the localization layer for the underlying template definitions.