Search Results cs_forum_user_cats




Overview
Explore in AI Chat

Overview

CS_FORUM_USER_CATS is a Service (CS) module table in the Oracle E-Business Suite schema CS. As its documented description states, it "stores the association info between user and categories." In practical terms, the table functions as a cross-reference holding the assignment of application users (FND_USER) to forum categories (CS_FORUM_CATEGORIES_B), together with a USAGE_TYPE discriminator that distinguishes the nature of each association. It is a low-volume, high-connectivity junction object whose purpose is to drive which users are linked to which service forum categories and under what usage context.

Under the heuristic Data Vault classification mined from the foreign key structure, this table is best modeled as a link. It sits between two reference entities — users and categories — and carries its own descriptive metadata, which is a classic link-table pattern. Treating it as a link (rather than a hub or satellite) aligns with its composite primary key built entirely from foreign-key business identifiers.

Key Information Stored

The table contains 25 documented columns, most of which are standard EBS audit and descriptive flexfield (DFF) columns. The functionally significant attributes are:

  • USER_ID — Foreign key to FND_USER identifying the associated application user. Part of the composite primary key.
  • CATEGORY_ID — Foreign key to CS_FORUM_CATEGORIES_B identifying the forum category. Part of the composite primary key.
  • USAGE_TYPE — Discriminator describing the type of user-to-category relationship; also part of the composite primary key.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-organization/security-group partitioning.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns (WHO columns) recording insert and update metadata.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield supporting attributes for customer-defined extension data.

The surrogate/primary key is CS_FORUM_USER_CATS_PK, defined across (USER_ID, CATEGORY_ID, USAGE_TYPE). A unique index, CS_FORUM_USER_CATS_U1, covers the same three columns, so there is no separate single-column surrogate key; the business key and physical primary key coincide, meaning a given user/category/usage-type combination can appear only once.

Common Use Cases and Queries

Typical uses center on determining which users are associated with which categories and reporting on those assignments. A common pattern resolves user and category names via joins:

  • List all categories assigned to a given user for reporting or access review.
  • List all users associated with a category, filtered by USAGE_TYPE.
  • Detect orphaned or duplicate associations during data cleanup.

Representative SQL:

SELECT u.user_name, c.category_name, f.usage_type
FROM cs_forum_user_cats f, fnd_user u, cs_forum_categories_b c
WHERE f.user_id = u.user_id
AND f.category_id = c.category_id;

Because the table participates in security-group partitioning, queries that cross operating units should include SECURITY_GROUP_ID filters when the Multi-Org or security-group model is enabled.

Related Objects

The following are the most significant objects related to CS_FORUM_USER_CATS, based on the documented foreign-key and key relationships:

  • FND_USER — joined on CS_FORUM_USER_CATS.USER_ID = FND_USER.USER_ID; source of the associated application user.
  • CS_FORUM_CATEGORIES_B — joined on CS_FORUM_USER_CATS.CATEGORY_ID = CS_FORUM_CATEGORIES_B.CATEGORY_ID; the base category entity.
  • FND_SECURITY_GROUPS — joined on CS_FORUM_USER_CATS.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID; governs security-group scoping.
  • CS_FORUM_CATEGORIES_TL — the translated category name table, typically joined through CS_FORUM_CATEGORIES_B for multilingual reporting.
  • CS_FORUM_USER_CATS_PK / CS_FORUM_USER_CATS_U1 — the primary key constraint and unique index enforcing uniqueness of the user/category/usage-type combination.

These relationships confirm that CS_FORUM_USER_CATS serves as the linking layer between the user directory and the service forum category structure, with security-group partitioning applied across the association.