Search Results csi_counters_tl_pk

Overview

CSI_COUNTERS_TL is the translation table for counter instance data within the Oracle E-Business Suite Install Base (CSI) module. It stores the language-specific, multilingual attributes of counters — namely the user-facing name and description text — so that the same logical counter record can be presented in multiple installed languages. In Oracle EBS Release 12.1.1 and 12.2.2, the CSI schema separates a base (non-translated) table from its "_TL" translation counterpart, and CSI_COUNTERS_TL follows this pattern: the base counter instance is defined once, while each translatable attribute is duplicated per language row.

The table resides in the CSI schema and is classified as VALID. From a data modeling perspective, the ETRM metadata offers a heuristic Data Vault classification of standalone, with no inbound foreign-key dependencies other than SECURITY_GROUP_ID. This suggests the table behaves as a satellite-like descriptive store keyed by a compound business key (COUNTER_ID plus LANGUAGE) rather than as a hub or link; the suggested model is that of a translation satellite attached to the counter instance identity rather than an independent entity.

Key Information Stored

The documented physical schema exposes twelve columns. The most significant are:

• COUNTER_ID — the surrogate identifier of the parent counter instance; part of the composite primary key and the join key back to the base counter table.
• LANGUAGE — the NLS language code identifying the translation; the second component of the composite primary key.
• NAME — the translated counter name displayed to the user in the given language.
• DESCRIPTION — the translated descriptive text for the counter.
• SOURCE_LANG — the source language of the original text, used by the translation framework to identify the base-language record.
• MIGRATED_FLAG — indicates whether the translation row was populated through a data migration process.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group isolation.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns tracking who created and last modified each row and when.

The surrogate primary key is CSI_COUNTERS_TL_PK, defined over (COUNTER_ID, LANGUAGE). A unique index, CSI_COUNTERS_TL_U01, covers the same (COUNTER_ID, LANGUAGE) pair, confirming that this combination is the business-key candidate and that at most one translation row may exist per counter per language.

Common Use Cases and Queries

Applications and reports typically join CSI_COUNTERS_TL to its base counter table on COUNTER_ID and filter by the session language to retrieve display-ready text. A representative pattern is:

• Retrieve the translated name and description for a specific counter: SELECT name, description FROM csi_counters_tl WHERE counter_id = :id AND language = USERENV('LANG');
• Audit which languages have been seeded for a counter: SELECT language, name FROM csi_counters_tl WHERE counter_id = :id ORDER BY language;
• Find counters missing a translation in a target language by left-joining the base table to the _TL table and testing for NULL NAME.
• Report on migrated translations using WHERE migrated_flag = 'Y'.

Reporting use cases include multilingual counter listings, translation completeness dashboards, and security-group-scoped extracts that honor SECURITY_GROUP_ID.

Related Objects

The most significant relationships are:

• CSI_COUNTERS (base table, inferred) — joined via COUNTER_ID to supply non-translated counter attributes.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, providing security-group scoping.
• CSI_COUNTERS_TL_PK / CSI_COUNTERS_TL_U01 — the primary key constraint and unique index enforcing uniqueness on (COUNTER_ID, LANGUAGE).
• FND_LANGUAGES — conceptually related through LANGUAGE and SOURCE_LANG for NLS resolution.

Together these objects let the Install Base module serve translated counter instance data consistently across locales and security groups.