Search Results cs_forum_categories_tl




Overview
Explore in AI Chat

Overview

CS_FORUM_CATEGORIES_TL is the translation (TL) table for forum categories within the Oracle E-Business Suite CS (Service) product family. It stores the language-dependent, user-facing text attributes of a forum category — principally the category name and description — keyed by language so that the same logical category can be presented in multiple installed languages. The corresponding base table, CS_FORUM_CATEGORIES_B, holds the language-independent attributes and the canonical category identity.

The table resides in the CS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. Its physical schema contains 11 columns and is anchored by the composite primary key CS_FORUM_CATEGORIES_TL_PK over (CATEGORY_ID, LANGUAGE). A unique index, CS_FORUM_CATEGORIES_TL_U1, is defined on the same pair of columns and serves as the business-key candidate.

From a Data Vault modeling perspective — a heuristic classification derived from the foreign-key structure rather than a documented Oracle construct — this table is best characterized as a link. Its composite key combines a reference to the category entity (CATEGORY_ID) with the language dimension (LANGUAGE), and it additionally references SOURCE_LANG and SECURITY_GROUP_ID, reflecting the many-to-many-style association between categories, languages, and language sources rather than an independent business entity.

Key Information Stored

The most significant columns are:

  • CATEGORY_ID — Surrogate identifier for the forum category; part of the composite primary key and the foreign key to CS_FORUM_CATEGORIES_B.
  • LANGUAGE — The language of the translated row; part of the primary key and a foreign key to FND_LANGUAGES.
  • SOURCE_LANG — The source language from which the translation was derived; foreign key to FND_LANGUAGES.
  • NAME — The translated display name of the forum category.
  • DESCRIPTION — The translated descriptive text for the category.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used for multi-organization/security partitioning.
  • CREATION_DATE, CREATED_BY — Audit columns recording when and by whom the translation row was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Audit columns recording the most recent modification and the login context under which it occurred.

The surrogate primary key is the composite (CATEGORY_ID, LANGUAGE). The unique index CS_FORUM_CATEGORIES_TL_U1 mirrors this same column pair, confirming it as the business-key candidate. Notably, the language-independent attributes live in the base table, so NAME and DESCRIPTION here are strictly translation data.

Common Use Cases and Queries

Typical usage centers on resolving category identifiers to localized display text for service forums, knowledge portals, and reporting extracts. A user-language join is the standard pattern:

  • Display all categories in the session language by joining CS_FORUM_CATEGORIES_B to CS_FORUM_CATEGORIES_TL on CATEGORY_ID and filtering LANGUAGE = the current locale.
  • Reporting on translation coverage — identifying categories that have no TL row for a given LANGUAGE.
  • Auditing translation staleness by comparing LAST_UPDATE_DATE across languages or against SOURCE_LANG.

A representative query:

SELECT b.category_id, t.name, t.description FROM cs_forum_categories_b b, cs_forum_categories_tl t WHERE b.category_id = t.category_id AND t.language = USERENV('LANG');

Because SOURCE_LANG and LANGUAGE both reference FND_LANGUAGES, reports frequently join FND_LANGUAGES twice to obtain readable language names for both the translation and its source.

Related Objects

  • CS_FORUM_CATEGORIES_B — Base table; joined on CS_FORUM_CATEGORIES_TL.CATEGORY_ID = CS_FORUM_CATEGORIES_B.CATEGORY_ID.
  • FND_LANGUAGES — Referenced by LANGUAGE and by SOURCE_LANG via two distinct foreign keys.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for security partitioning.
  • CS_FORUM_CATEGORIES_TL_PK — Primary key constraint over (CATEGORY_ID, LANGUAGE).
  • CS_FORUM_CATEGORIES_TL_U1 — Unique index over (CATEGORY_ID, LANGUAGE).

These objects should be treated as a unit when querying or extending forum category functionality.