Search Results cs_systems_all_tl_pk

Overview

CS_SYSTEMS_ALL_TL is the translation table for the Service (CS) module's Systems entity in Oracle E-Business Suite. In EBS, "_TL" tables store language-specific, translated text for a corresponding base or "_B"/"_ALL" table, keyed by the primary key of the base entity plus a LANGUAGE code. This object holds the translated descriptive and display information for system definitions used within Oracle Service, allowing the same logical system record to carry a distinct name, description, or other textual attribute for each installed language.

Within Oracle EBS, systems are used by Service to group or classify assets, configurations, and service-related items. The translated table exists so that multilingual implementations can present system names and descriptions in the user's session language while the base definition remains language-neutral. The ETRM metadata notes that CS_SYSTEMS_ALL_TL is not implemented in the reference database, which indicates that the object is delivered by the product schema but may be absent or empty depending on installation and configuration.

The metadata classifies this object as a standalone data vault structure, mined heuristically from its foreign key relationships. As a modeling suggestion, this classification reflects the absence of documented outbound foreign keys from CS_SYSTEMS_ALL_TL itself; the translation table functions as an independent satellite-like store of descriptive attributes rather than a hub or link. Because it is not implemented in the sampled database, the heuristic classification should be treated as a structural observation rather than a confirmed integration model.

Key Information Stored

The documented metadata identifies two columns as the composite primary key, exposed through the constraint CS_SYSTEMS_ALL_TL_PK. These are:

• SYSTEM_ID — the surrogate identifier for the system record. It corresponds to the primary key of the base systems entity and links the translated row back to its parent definition.
• LANGUAGE — the language code identifying which translated version of the text is held on the row. The combination of SYSTEM_ID and LANGUAGE uniquely identifies each translated record.

Beyond the composite key, the "_TL" construct in Oracle EBS conventionally carries the translated textual attributes for the entity, most commonly a translated NAME and DESCRIPTION alongside the language-specific columns. These are the columns most often reported against. Because the ETRM excerpt only documents the key structure, no additional columns can be asserted from the metadata; the presence of name and description attributes is a conventional expectation of EBS translation tables rather than a documented fact for this specific object. The primary key columns, SYSTEM_ID and LANGUAGE, are the only business-relevant identifiers explicitly confirmed in the source documentation, while the constraint name CS_SYSTEMS_ALL_TL_PK confirms the composite surrogate-plus-language design.

Common Use Cases and Queries

The primary use case is multilingual presentation of system definitions. Reporting and integration queries typically join the translated table to the base systems object on SYSTEM_ID, filtering by the LANGUAGE that matches the reporting or session locale. A representative pattern is:

• Selecting the translated name and description for a given system and language, joining CS_SYSTEMS_ALL_TL to the base systems table on SYSTEM_ID and restricting LANGUAGE to the target code.
• Auditing which languages have translations available for each system by grouping on SYSTEM_ID and counting distinct LANGUAGE values.
• Detecting missing translations by comparing the set of systems in the base table against the languages present in CS_SYSTEMS_ALL_TL.
• Feeding downstream service and asset reporting where localized system labels are required.

Because the object is documented as not implemented in the reference environment, queries should defensively handle the possibility that the table is absent or empty. Reports should fall back to the base system name when no translation row exists for the requested language.

Related Objects

The metadata describes CS_SYSTEMS_ALL_TL as standalone for data vault classification, meaning no outbound foreign keys were mined. The significant relationships are therefore logical rather than enforced:

• The base systems table (CS_SYSTEMS_/_ALL/_B family) — the parent entity whose SYSTEM_ID is referenced by CS_SYSTEMS_ALL_TL. Joins occur on SYSTEM_ID.
• CS_SYSTEMS_ALL_TL_PK — the composite primary key constraint over SYSTEM_ID and LANGUAGE, defining uniqueness and supporting lookup by system and language.
• Service asset and configuration objects — service items and assets that reference a system definition indirectly through SYSTEM_ID on the base systems entity.
• FND language and territory reference data — the source of valid LANGUAGE codes applied to translated rows.
• Multilingual reporting and concurrent programs — consumers that join base and translated tables to produce localized output.

No further FK relationships are documented for this object, consistent with its standalone classification.