Search Results csi_counter_properties_tl_u01




Overview
Explore in AI Chat

Overview

CSI.CSI_COUNTER_PROPERTIES_TL is the translation (TL) table for counter instance property definitions within the Oracle E-Business Suite TeleService and field service foundation, owned by the CSI (Customer Support Intelligence / Installed Base) schema. In Oracle EBS 12.1.1 and 12.2.2, the counter model tracks meter-style readings against counters installed on an instance, and each counter exposes a set of named properties. The _TL suffix identifies this table as the multilingual companion to the base counter property definition table: it stores the language-dependent NAME and DESCRIPTION for each counter property, keyed by language, so the same logical property can be presented in multiple installed languages.

The table resides in the APPS_TS_TX_DATA tablespace, with its unique index in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the mined foreign-key structure classifies this object heuristically as standalone; however, because it carries descriptive, translatable attributes attached to a business key, it is best modeled as a satellite keyed to the counter property entity, with LANGUAGE as an additional component of the degenerate key.

Key Information Stored

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

  • COUNTER_PROPERTY_ID (NUMBER) — Auto-generated internal primary key identifying the counter property; this is the surrogate business identifier and the leading column of the unique index.
  • LANGUAGE (VARCHAR2) — The language of the translated row; combined with COUNTER_PROPERTY_ID it forms both the primary key (CSI_COUNTER_PROPERTIES_TL_PK) and the unique business-key index CSI_COUNTER_PROPERTIES_TL_U01.
  • NAME (VARCHAR2 50) — The translated counter property name presented in the UI.
  • DESCRIPTION (VARCHAR2 240) — The translated description of the counter property.
  • SOURCE_LANG (VARCHAR2) — The source language from which the translation was derived, used by the translation framework.
  • SECURITY_GROUP_ID (NUMBER) — Security group discriminator, with a documented foreign-key relationship to FND_SECURITY_GROUPS; in standalone mode this value is typically constrained, with referential integrity validated at the application layer.
  • MIGRATED_FLAG (VARCHAR2) — Indicator denoting whether the row was introduced by a migration or upgrade process.
  • WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard audit metadata.

Common Use Cases and Queries

The table is used primarily by translation and reporting processes that need to render counter property labels in a specific language. A typical query retrieves the translated name and description for a property in the session’s language:

  • Reporting of counter property names by language for Installed Base administration.
  • Validating translation coverage, for example identifying properties lacking a row for a given LANGUAGE.
  • Auditing migrated rows via MIGRATED_FLAG and the WHO audit columns.

Sample SQL:

  • SELECT cp.counter_property_id, cp.name, cp.description, cp.language FROM csi.csi_counter_properties_tl cp WHERE cp.language = USERENV('LANG') AND cp.counter_property_id = :property_id;
  • Coverage check: SELECT counter_property_id FROM csi.csi_counter_properties_tl WHERE language = 'US' MINUS SELECT counter_property_id FROM csi.csi_counter_properties_tl WHERE language = 'FR';

Because the table is narrow and carries no foreign keys to the base definition, queries should join back to the base counter property table on COUNTER_PROPERTY_ID to obtain untranslated attributes.

Related Objects

The documented dependency data shows CSI.CSI_COUNTER_PROPERTIES_TL does not reference any other database object directly, but it is referenced by a synonym-like object CSI_COUNTER_PROPERTIES_TL#. The most significant related objects are:

  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID to enforce data security partitioning.
  • CSI_COUNTER_PROPERTIES_TL# — the referencing object maintained by the schema, typically an editioning view or synonym layer.
  • CSI_COUNTER_PROPERTIES — the base (non-translated) counter property definition table, joined on COUNTER_PROPERTY_ID.
  • FND_LANGUAGES — reference for valid values of LANGUAGE and SOURCE_LANG.