Results for “composite_assoc_col”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_FORUM_MESSAGES_TL is the translation table for forum messages within the Oracle E-Business Suite Service (CS) module. It stores the language-dependent, translatable attributes of records whose language-independent definition resides in the base table CS_FORUM_MESSAGES_B. In Oracle's standard multilanguage ("_TL") design, a single base row is paired with one or more translation rows, one per installed language, so that the descriptive content of a forum message can be presented in the user's session language. The table is owned by the CS schema and is documented as VALID in ETRM releases 12.1.1 and 12.2.2, with a documented physical schema of twelve columns.

Under the heuristic Data Vault classification mined from its foreign-key structure, this object is best modeled as a link. It links the language-independent message entity to the language definition held in FND_LANGUAGES, resolving the many-to-many relationship between a message and the set of languages in which that message carries translated content. This classification is a modeling suggestion derived from the constraint topology rather than an Oracle-declared attribute.

Key Information Stored

The table's identity is defined by the composite primary key CS_FORUM_MESSAGES_TL_PK, comprising MESSAGE_ID and LANGUAGE. MESSAGE_ID is a foreign key to CS_FORUM_MESSAGES_B and identifies the parent message; LANGUAGE identifies the specific translation row and references FND_LANGUAGES. A unique index, SYS_C00219660, covers the same (MESSAGE_ID, LANGUAGE) pair, confirming it as the business-key candidate for the table.

• MESSAGE_ID — surrogate identifier inherited from the base table; one half of the primary key and the join to CS_FORUM_MESSAGES_B.
• LANGUAGE — the translation language of the row; the second half of the primary key.
• SOURCE_LANG — the source language from which the translation was derived; references FND_LANGUAGES.
• NAME — the translatable name or subject of the forum message.
• DESCRIPTION — the translatable descriptive text of the forum message.
• SECURITY_GROUP_ID — the security group under which the row is visible; references FND_SECURITY_GROUPS.
• COMPOSITE_ASSOC_COL — a composite association column used in the translated-entity framework.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle who-columns capturing audit and concurrency information.

Common Use Cases and Queries

Typical access patterns join the translation table to its base table and constrain on the session or requested language. A representative retrieval of translated message content is:

• SELECT b.message_id, t.name, t.description FROM cs_forum_messages_b b, cs_forum_messages_tl t WHERE b.message_id = t.message_id AND t.language = USERENV('LANG');
• Reporting on translation coverage: identify base messages lacking a row for a given language by outer-joining CS_FORUM_MESSAGES_B to this table and filtering on a NULL LANGUAGE.
• Language inventory: grouping by LANGUAGE and SOURCE_LANG to quantify translated versus source-language content.
• Security-group scoping: filtering by SECURITY_GROUP_ID to restrict translated content to an operating unit or security context.

Related Objects

The following objects are most significant in relation to this table, based on the documented foreign-key and primary-key structure:

• CS_FORUM_MESSAGES_B — the base table; joined on MESSAGE_ID, providing the language-independent message definition.
• FND_LANGUAGES — referenced twice, once by LANGUAGE and once by SOURCE_LANG, supplying installed language definitions.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, controlling row visibility.
• CS_FORUM_MESSAGES_TL_PK — the composite primary key constraint over (MESSAGE_ID, LANGUAGE).
• SYS_C00219660 — the unique index over (MESSAGE_ID, LANGUAGE), the business-key candidate.