Search Results csi_systems_tl




Overview
Explore in AI Chat

Overview

CSI_SYSTEMS_TL is the translation (TL) table for Oracle EBS Install Base system definitions. It resides in the CSI schema and stores the language-dependent descriptive attributes of a "system," which in Oracle E-Business Suite Install Base (CSI) represents a logical grouping of related customer products, components and instances that are tracked together as a single maintainable entity. Each row represents the translated name and description of a system in a specific installed language.

The table follows the standard Oracle EBS multi-language pattern: the base (non-translated) attributes of a system live in the corresponding base table (CSI_SYSTEMS), while CSI_SYSTEMS_TL carries the human-readable NAME and DESCRIPTION per LANGUAGE, keyed by SOURCE_LANG. The primary key, CSI_SYSTEMS_TL_PK, is defined on (SYSTEM_ID, LANGUAGE), and a unique index, CSI_SYSTEMS_TL_U01, is also documented on the same (SYSTEM_ID, LANGUAGE) pair — effectively the business key that guarantees one translation row per system per language.

From a Data Vault modeling perspective, the metadata classifies this object as standalone (heuristic, mined from the foreign-key structure). As a modeling suggestion, this reflects its nature as a reference/descriptive satellite: it hangs off the system identity (SYSTEM_ID) and holds descriptive, slowly changing attributes, with no dependent child tables of its own. It is not a hub or link in the strict sense, but the SYSTEM_ID plus LANGUAGE combination behaves as the natural business key.

Key Information Stored

The most significant columns are:

  • SYSTEM_ID — the surrogate/foreign key identifying the system; part of the composite primary key and the join back to the base system record.
  • LANGUAGE — the NLS language of the translated text; the second half of the primary key.
  • SOURCE_LANG — the base language from which the translation originates, used by the EBS translation framework to track the source.
  • NAME — the translated system name.
  • DESCRIPTION — the translated system description.
  • SECURITY_GROUP_ID — the security grouping value, foreign-keyed to FND_SECURITY_GROUPS, used for multi-org/security partitioning.
  • MIGRATED_FLAG — indicates whether the row was migrated from a legacy source.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE and LAST_UPDATE_LOGIN capture the standard who/when audit trail required on all EBS transactional tables.

The documented unique index CSI_SYSTEMS_TL_U01 (SYSTEM_ID, LANGUAGE) is the true business-key candidate; SYSTEM_ID alone is not unique because a system has one row per installed language.

Common Use Cases and Queries

Typical scenarios include building Install Base reports that display system names in the correct session language, and auditing translations for completeness. A common query pattern is:

  • Join CSI_SYSTEMS_TL to CSI_SYSTEMS on SYSTEM_ID to retrieve both base and translated attributes.
  • Filter by LANGUAGE to return only the desired locale, or by SOURCE_LANG to find untranslated rows.
  • Detect missing translations by comparing the set of systems in the base table against the TL rows for a given LANGUAGE.
  • Reporting on systems per security group by joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS.
  • Data-cleansing checks for rows where MIGRATED_FLAG is set, supporting migration reconciliation.

A representative statement selects s.system_id, t.name, t.description from CSI_SYSTEMS s, CSI_SYSTEMS_TL t where s.system_id = t.system_id and t.language = userenv('LANG').

Related Objects

  • CSI_SYSTEMS — the base table holding language-independent system attributes; joined on SYSTEM_ID.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for security partitioning.
  • CSI_SYSTEMS_TL_PK and CSI_SYSTEMS_TL_U01 — the primary key and unique index enforcing row identity.
  • CSI_ITEM_INSTANCES — instances that may be associated with a system, indirectly linked through the system definition.
  • FND_LANGUAGES — the reference table validating LANGUAGE and SOURCE_LANG values.
  • CSI_SYSTEMS_EFC / dependent EFC (eBusiness Financials) synonyms and views that expose translated system data for reporting.

Because the metadata classifies the object as standalone, no child tables depend on it; consumers are reporting views, translation-maintenance screens and Install Base inquiry functions that resolve NAME and DESCRIPTION for display.