Search Results csi_counters_tl_n01




Overview
Explore in AI Chat

Overview

CSI.CSI_COUNTERS_TL is the translation-enabled child table of the Oracle E-Business Suite Counters model in the Customer Intelligence (CSI) schema. Physically it is a standard EBS translatable ("_TL") table residing in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, and it stores the language-specific presentation attributes of a counter — its name and description — keyed by language code. The base entity itself (counter instance data) is held in the corresponding non-translated table, while this object holds only the rows that may be rendered in a session or installation language other than the source language. Because it is a translation table it is populated for every installed language, and its rows are maintained by the standard EBS translation framework rather than by ad hoc DML.

The ETRM metadata classifies this table heuristically as standalone within the Data Vault model, meaning no foreign key path was mined to a parent hub beyond the security-group reference. In practical modeling terms it behaves as a multi-active satellite attached to the counter entity: COUNTER_ID identifies the parent counter, LANGUAGE identifies the specific translation row, and the descriptive columns are the versioned, language-dependent payload.

Key Information Stored

  • COUNTER_ID (NUMBER) — the auto-generated internal primary key of the counter; the join back to the base counter entity.
  • LANGUAGE (VARCHAR2) — the language code of the translation row.
  • NAME (VARCHAR2 80) — the translated counter name; also a non-unique index (CSI_COUNTERS_TL_N01) exists on this column, reflecting the need to search counters by display name.
  • DESCRIPTION (VARCHAR2 240) — the translated long description of the counter.
  • SOURCE_LANG (VARCHAR2) — the language from which the row was originally translated.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns used for audit and change tracking.
  • SECURITY_GROUP_ID (NUMBER) — the security group identifier, with a documented foreign key reference to FND_SECURITY_GROUPS, supporting multi-organization/security-group data partitioning.
  • MIGRATED_FLAG (VARCHAR2) — indicator used to identify rows that originated from a data migration rather than native entry.

The surrogate primary key is CSI_COUNTERS_TL_PK, defined on (COUNTER_ID, LANGUAGE), and it is backed by the unique index CSI_COUNTERS_TL_U01, also on (COUNTER_ID, LANGUAGE) in APPS_TS_TX_IDX. The user-searched index name, csi_counters_tl_u01, is therefore the business-key enforcer that guarantees exactly one translation row per counter per language. The NAME index (CSI_COUNTERS_TL_N01) is non-unique and supports name-oriented lookups.

Common Use Cases and Queries

Typical usage centers on retrieving the display name and description for a counter in a requested language, falling back to the source-language row when a translation is absent. A reporting query commonly joins this table to the base counter table and filters by LANGUAGE, for example:

  • Multi-language extraction: SELECT c.counter_id, t.name, t.description FROM csi.csi_counters_tl t WHERE t.language = :lang AND t.counter_id = :id;
  • Missing-translation audit: compare the set of counters against the set of rows for a given LANGUAGE to find counters never translated.
  • Migration validation: SELECT migrated_flag, COUNT(*) FROM csi.csi_counters_tl GROUP BY migrated_flag; to confirm migrated records loaded cleanly.
  • Security-group scoped reporting: restrict results by SECURITY_GROUP_ID joined to FND_SECURITY_GROUPS.
  • Search by name: leverage the CSI_COUNTERS_TL_N01 index when resolving a counter from a user-entered name string.

A direct column list query against the twelve documented columns is used for data extracts and staging loads into downstream warehouses.

Related Objects

  • FND_SECURITY_GROUPS — referenced by CSI_COUNTERS_TL.SECURITY_GROUP_ID; the documented foreign key path for security-group partitioning.
  • CSI_COUNTERS_TL_U01 — the unique composite index enforcing the (COUNTER_ID, LANGUAGE) business key.
  • CSI_COUNTERS_TL_N01 — the non-unique NAME index supporting display-name retrieval.
  • CSI_COUNTERS_TL_PK — the primary key constraint on (COUNTER_ID, LANGUAGE).
  • APPS synonym CSI_COUNTERS_TL — the APPS-layer synonym through which application code and reports access the table.
  • The base counter entity (identified by COUNTER_ID) — the parent that this translation table decorates with language-specific name and description values.

Because the ETRM metadata records only the FND_SECURITY_GROUPS reference explicitly, all other relationships should be confirmed against the live data dictionary before being used in custom integrations.