Search Results cs_forum_msg_attrs




Overview
Explore in AI Chat

Overview

CS_FORUM_MSG_ATTRS is a Service (CS) module table in Oracle E-Business Suite, documented as VALID under the CS schema in both release 12.1.1 and 12.2.2. Its documented description is "Forum message attributes." The table stores the attribute-level detail attached to forum messages within the Oracle Service interaction and knowledge-management framework. Forum messages in CS represent threaded discussions or notes associated with service objects such as service requests, and this table captures the individual attribute values and ordering that qualify each message.

From a modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This is consistent with the table's role as an associative entity that resolves the many-to-many relationship between forum messages and forum attribute definitions. The composite primary key, CS_FORUM_MSG_ATTRS_PK, is defined over MESSAGE_ID and ATTRIBUTE_ID, reinforcing the link interpretation: each row associates one message with one attribute definition and holds the attribute-specific payload.

Key Information Stored

The documented physical schema contains 26 columns. The most significant columns are:

  • MESSAGE_ID — Part of the composite primary key; identifies the parent forum message. Foreign key to CS_FORUM_MESSAGES_B.
  • ATTRIBUTE_ID — Part of the composite primary key; identifies the attribute definition. Foreign key to CS_FORUM_ATTRS_B.
  • ATTRIBUTE_ORDER — Determines display or processing sequence of attributes for the message.
  • OPTIONAL — Flag indicating whether the attribute is optional for the message.
  • ATTRIBUTE_CATEGORY — Descriptive flexfield context or category for the attribute relationship.
  • ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) segment columns, storing additional free-form attribute data.
  • SECURITY_GROUP_ID — Security group identifier; foreign key to FND_SECURITY_GROUPS, supporting multi-org and data security partitioning.
  • CREATION_DATE, CREATED_BY — Standard audit columns recording who created the row and when.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification and the responsible login.

The surrogate primary key is the composite CS_FORUM_MSG_ATTRS_PK (MESSAGE_ID, ATTRIBUTE_ID). A second unique index, CS_FORUM_MSG_ATTRS_U1, is defined over the same business-key pair, confirming that a message may define each attribute at most once.

Common Use Cases and Queries

Typical usage involves retrieving the ordered set of attributes defined for a given forum message, or enumerating messages that reference a particular attribute definition.

SELECT ma.MESSAGE_ID, ma.ATTRIBUTE_ID, ma.ATTRIBUTE_ORDER, ma.OPTIONAL
FROM   CS_FORUM_MSG_ATTRS ma
WHERE  ma.MESSAGE_ID = :p_message_id
ORDER BY ma.ATTRIBUTE_ORDER;
SELECT m.*, ma.ATTRIBUTE_ID
FROM   CS_FORUM_MESSAGES_B m, CS_FORUM_MSG_ATTRS ma
WHERE  m.MESSAGE_ID = ma.MESSAGE_ID
AND    ma.ATTRIBUTE_ID = :p_attribute_id;

Reporting scenarios include attribute-coverage analysis for forum messages, auditing optional versus mandatory attributes, and extracting DFF values held in ATTRIBUTE1 through ATTRIBUTE15. Because SECURITY_GROUP_ID is present, queries in multi-org deployments should honor the security group filter applied by the application.

Related Objects

The following objects are documented as directly related through primary and foreign key relationships:

  • CS_FORUM_MESSAGES_B — Parent table of forum messages; joined via MESSAGE_ID.
  • CS_FORUM_ATTRS_B — Parent table of forum attribute definitions; joined via ATTRIBUTE_ID.
  • FND_SECURITY_GROUPS — Security group reference; joined via SECURITY_GROUP_ID.
  • CS_FORUM_MSG_ATTRS_PK — Composite primary key constraint on (MESSAGE_ID, ATTRIBUTE_ID).
  • CS_FORUM_MSG_ATTRS_U1 — Unique index enforcing business-key uniqueness on (MESSAGE_ID, ATTRIBUTE_ID).
  • CS_FORUM_MESSAGES_TL — Translation table for message text, commonly joined with the message base table when reporting on forum content alongside its attributes.
  • CS_FORUM_ATTRS_TL — Translation table for attribute definitions, used when presenting attribute labels.