Search Results cs_forum_cat_links




Overview
Explore in AI Chat

Overview

CS_FORUM_CAT_LINKS is a Service (CS) module table that stores the associations between forum categories and the business objects they are linked to. In Oracle E-Business Suite 12.1.1 and 12.2.2, forums provide discussion and collaboration functionality for service requests, knowledge articles, and other JTF-based objects. This table acts as the intersection point that determines which forum categories are available for a given object type, thereby driving how discussion threads are organized and surfaced to end users.

From a Data Vault modeling perspective, the metadata heuristic classifies CS_FORUM_CAT_LINKS as a link table. This is consistent with its structure: it resolves a many-to-many style relationship between forum categories and external business objects, carrying no descriptive business attributes beyond audit and descriptive flexfield columns. The primary key CS_FORUM_CAT_LINKS_PK is composed of OBJECT_CODE, CATEGORY_ID, and OTHER_ID, which together uniquely identify each association row.

Key Information Stored

The table contains 25 documented columns. The most significant are:

  • CATEGORY_ID — The forum category identifier. Foreign key to CS_FORUM_CATEGORIES_B, this column ties the link to a specific category definition.
  • OBJECT_CODE — Identifies the type of business object being linked. Foreign key to JTF_OBJECTS_B, this column establishes which object class the category association applies to.
  • OTHER_ID — The third component of the composite primary key and the column most commonly searched by users. It provides the specific object instance reference that completes the link relationship beyond the object type.
  • SECURITY_GROUP_ID — Supports multi-tenant or multi-org data security partitioning, referencing FND_SECURITY_GROUPS.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns tracking who created and last modified each link row.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns for extensible, customer-specific attributes.

The primary key is the combination of OBJECT_CODE, CATEGORY_ID, and OTHER_ID. The unique index CS_FORUM_CAT_LINKS_U1 mirrors this same column set, confirming the business key is identical to the physical key. Because OTHER_ID participates directly in both the primary key and the unique index, it is a first-class identifying attribute rather than a mere attribute.

Common Use Cases and Queries

Typical use cases include determining which forum categories are configured for a particular object, auditing link configurations, and joining forum content back to its originating business object.

To find all category links for a given object instance:

  • SELECT category_id, object_code, other_id FROM cs_forum_cat_links WHERE other_id = :other_id;

To resolve category names for reporting, join to the categories table:

  • SELECT c.category_name, l.object_code, l.other_id FROM cs_forum_cat_links l, cs_forum_categories_b c WHERE l.category_id = c.category_id AND l.other_id = :other_id;

To identify link rows for a specific object type:

  • SELECT other_id, category_id FROM cs_forum_cat_links WHERE object_code = :object_code;

Because OTHER_ID is indexed as part of CS_FORUM_CAT_LINKS_U1 (with OBJECT_CODE and CATEGORY_ID in leading positions), queries filtering on OTHER_ID alone will not fully benefit from that index; adding OBJECT_CODE to the predicate improves performance.

Related Objects

The following objects are most directly related through foreign keys and the primary key definition:

  • CS_FORUM_CATEGORIES_B — Referenced by CATEGORY_ID; holds the forum category definitions.
  • JTF_OBJECTS_B — Referenced by OBJECT_CODE; defines the object types that forums can attach to.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for data security partitioning.
  • CS_FORUM_CAT_LINKS_PK — Primary key constraint (OBJECT_CODE, CATEGORY_ID, OTHER_ID).
  • CS_FORUM_CAT_LINKS_U1 — Unique index on the same composite column set.

Together these objects form the forum categorization model within the Service module, with CS_FORUM_CAT_LINKS functioning as the associative link that enables categories to be scoped to specific JTF object instances.