Search Results cs_forum_categories_b




Overview
Explore in AI Chat

Overview

CS_FORUM_CATEGORIES_B is the base table for forum categories within the Oracle E-Business Suite Service (CS) module. It stores the master definitions of categories used to organize, classify, and thread discussion content in Oracle's forum/knowledge collaboration features, such as those associated with iSupport and the Service module's interaction and knowledge management capabilities. The table is owned by the CS schema and is marked VALID in the ETRM 12.2.2 repository. Because it functions as the single source of category identity — anchored by a surrogate identifier and referenced widely by transactional and descriptive child tables — it plays the role of a central organizational entity rather than a transactional ledger.

From a modeling perspective, the ETRM heuristic Data Vault classification places this object as hub-leaning. In Data Vault terms, that suggests treating CS_FORUM_CATEGORIES_B as a hub that holds the durable category business key, with its descriptive and audit attributes preferably managed through satellites, while its relationships to child tables (categories, attributes, links, messages, user categories) are captured as link structures. This is a heuristic, not a mandated design, and should be validated against actual integration requirements.

Key Information Stored

CS_FORUM_CATEGORIES_B contains 26 documented columns. The most significant are:

  • CATEGORY_ID — the surrogate primary key, defined by the CS_FORUM_CATEGORIES_B_PK constraint and also the sole unique index (CS_FORUM_CATEGORIES_B_U1). It uniquely identifies each forum category.
  • CATEGORY_NAME — the descriptive label of the category used for display and reporting.
  • CATEGORY_TYPE — classifies the nature of the category, allowing different kinds of forum or discussion groupings to coexist.
  • STATUS — the lifecycle state of the category (for example active or inactive), which governs whether it is available for use.
  • SECURITY_GROUP_ID — the foreign key into FND_SECURITY_GROUPS, enforcing multi-org/security-group scoping so categories are visible only within the appropriate boundary.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle EBS "Who" audit columns that record insertion and modification history.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns that allow customers to extend category records with their own context-sensitive attributes.

The surrogate key (CATEGORY_ID) is distinct from any business identifier; the metadata does not document a separate business-key column, so CATEGORY_ID serves as both the physical and, in practice, the logical identifier for joins across the model.

Common Use Cases and Queries

Typical usage centers on listing available categories, filtering by status or type, resolving category names for discussions, and auditing security-group assignment. Sample patterns:

  • Retrieving active categories for a given security group: SELECT CATEGORY_ID, CATEGORY_NAME, CATEGORY_TYPE, STATUS FROM CS_FORUM_CATEGORIES_B WHERE STATUS = 'Y' AND SECURITY_GROUP_ID = :p_security_group;
  • Joining to child message tables to report discussion volume by category, using CATEGORY_ID as the join key between CS_FORUM_CATEGORIES_B and CS_FORUM_CAT_MSGS.
  • Resolving translated names via CS_FORUM_CATEGORIES_TL on CATEGORY_ID when multi-language display is required.
  • Auditing recently created or modified categories using CREATION_DATE and LAST_UPDATE_DATE.

Because the table is relatively small and definitional, it is usually queried as a lookup joined to higher-volume transactional forum tables rather than being the large fact source itself.

Related Objects

The FK metadata identifies several dependent objects that reference CS_FORUM_CATEGORIES_B through CATEGORY_ID, along with one upstream reference:

  • CS_FORUM_CATEGORIES_TL (join on CATEGORY_ID) — holds the translatable name/description rows.
  • CS_FORUM_CAT_CATS (CATEGORY_ID_1 and CATEGORY_ID_2) — models parent/child or sibling relationships between categories.
  • CS_FORUM_CAT_ATTRS (CATEGORY_ID) — category attribute assignments.
  • CS_FORUM_CAT_LINKS (CATEGORY_ID) — links associated with categories.
  • CS_FORUM_CAT_MSGS (CATEGORY_ID) — messages/discussion entries posted under a category.
  • CS_FORUM_USER_CATS (CATEGORY_ID) — user subscription/preference mapping to categories.
  • FND_SECURITY_GROUPS — the upstream reference via SECURITY_GROUP_ID that governs visibility and org scoping.