Results for “negative_assoc_index”

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

Overview

The CS_KB_SETS_TL table is the translation table for Knowledge Base Sets within the Oracle E-Business Suite Service (CS) module. Knowledge Base Sets are logical groupings of knowledge base articles that allow support organizations to partition, organize, and secure knowledge content according to business rules such as product line, audience, or service category. Because Oracle EBS is a multi-language application, every base-language record stored in the companion base table, CS_KB_SETS_B, has one or more translated rows in CS_KB_SETS_TL — one per installed language. This table therefore holds the language-dependent textual attributes (name and description) alongside edition and indexing metadata that the knowledge management engine uses to assemble and query knowledge sets.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying CS_KB_SETS_TL as a link entity. It resolves the association between a knowledge base set (CS_KB_SETS_B) and a language (FND_LANGUAGES), while also carrying descriptive and index-related attributes specific to each language edition.

Key Information Stored

The primary key, CS_KB_SETS_TL_PK, is the composite of SET_ID and LANGUAGE. SET_ID identifies the knowledge base set and maps to the base table, while LANGUAGE identifies the translation language. A unique index, CS_KB_SETS_TL_U1, mirrors this composite on (SET_ID, LANGUAGE), reinforcing it as the business-key candidate. The most important columns include:

• SET_ID — surrogate identifier for the knowledge base set; foreign key to CS_KB_SETS_B.
• LANGUAGE — the language of this translated row; foreign key to FND_LANGUAGES.
• SOURCE_LANG — the language from which this translation was derived; also references FND_LANGUAGES.
• NAME — the language-specific display name of the knowledge set.
• DESCRIPTION — the language-specific descriptive text of the set.
• COMPOSITE_ASSOC_INDEX, POSITIVE_ASSOC_INDEX, NEGATIVE_ASSOC_INDEX — indexing metadata used by the knowledge association engine to rank and retrieve articles associated with the set.
• COMPOSITE_ASSOC_ATTACH_INDEX — index metadata for attached content associations.
• CONTENT_CACHE and ATTACHMENT_CONTENT_CACHE — cached content and attachment content, stored as LOB columns.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-organization data security.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and modified each translation row.

Common Use Cases and Queries

Typical reporting scenarios include listing knowledge sets available in a given language, verifying translation completeness, and resolving the name of a set for a user session. A common query joins the translation table to the base table and restricts by language:

• SELECT b.set_id, t.name, t.description FROM cs_kb_sets_b b, cs_kb_sets_tl t WHERE b.set_id = t.set_id AND t.language = USERENV('LANG');
• Detecting sets lacking a translation: SELECT b.set_id FROM cs_kb_sets_b b WHERE NOT EXISTS (SELECT 1 FROM cs_kb_sets_tl t WHERE t.set_id = b.set_id AND t.language = 'US');
• Auditing recently modified translations using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Resolving source language lineage via SOURCE_LANG joined to FND_LANGUAGES.

Because content caches are LOB columns, reporting queries should avoid selecting CONTENT_CACHE and ATTACHMENT_CONTENT_CACHE unless required, to preserve performance.

Related Objects

The following objects are most significant to CS_KB_SETS_TL:

• CS_KB_SETS_B — base table; joined on SET_ID. Stores language-independent set attributes.
• FND_LANGUAGES — reference table for LANGUAGE and SOURCE_LANG.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for data security.
• CS_KB_SETS_VL — the MLS view typically exposing base and translation columns for concurrent programs and forms.
• Knowledge association tables that consume COMPOSITE_ASSOC_INDEX and related index columns when retrieving set-linked articles.

Together these objects form the knowledge set subsystem within Oracle Service, with CS_KB_SETS_TL providing the multilingual presentation layer for knowledge base sets.