Search Results cs_forum_msg_attrs_n1

Overview

CS.CS_FORUM_MSG_ATTRS is a child table within the Oracle E-Business Suite Customer Support (CS) schema that stores attribute-level detail associated with individual forum messages. In EBS 12.1.1 and 12.2.2, this table functions as the intersection between a message header and the attributes that apply to it, defining which attributes are present on a message, their display ordering, and whether they are mandatory or optional. The table resides in the APPS_TS_ARCHIVE tablespace and is flagged in the ETRM documentation with the "Oracle Internal Use Only" warning, indicating that direct access is not supported outside of standard Oracle Applications programs.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object heuristically as a link table. Its dual foreign-key references to CS_FORUM_MESSAGES_B and CS_FORUM_ATTRS_B, combined with a composite unique key, are characteristic of a link construct that resolves a many-to-many relationship between messages and attribute definitions.

Key Information Stored

The table's identity is anchored by its composite primary key, CS_FORUM_MSG_ATTRS_PK, comprising MESSAGE_ID and ATTRIBUTE_ID. These same two columns form the unique index CS_FORUM_MSG_ATTRS_U1, which serves as the business-key candidate for the relationship. MESSAGE_ID references the parent forum message, while ATTRIBUTE_ID references the attribute definition in CS_FORUM_ATTRS_B.

• MESSAGE_ID — surrogate key linking to the forum message header.
• ATTRIBUTE_ID — surrogate key linking to the attribute definition.
• ATTRIBUTE_ORDER — controls the sequence in which attributes appear within a given message.
• OPTIONAL — flag indicating whether the attribute is optional for the associated message.
• ATTRIBUTE_CATEGORY — descriptive flexfield structure-defining column, enabling context-sensitive DFF segments.
• ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield segments (VARCHAR2(150)) holding user-defined attribute values.
• CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — the standard Who columns providing audit lineage.
• SECURITY_GROUP_ID — reference to FND_SECURITY_GROUPS, supporting multi-organization data security.

The non-unique index CS_FORUM_MSG_ATTRS_N1 on ATTRIBUTE_ID supports reverse lookups from an attribute to all messages referencing it.

Common Use Cases and Queries

Typical usage involves retrieving the ordered set of attributes for a message, or determining which messages carry a particular attribute.

• Attribute listing by message:

  SELECT attribute_id, attribute_order, optional
  FROM   cs_forum_msg_attrs
  WHERE  message_id = :p_message_id
  ORDER  BY attribute_order;

• Reverse lookup by attribute:

  SELECT message_id
  FROM   cs_forum_msg_attrs
  WHERE  attribute_id = :p_attribute_id;

• DFF value extraction for reporting, reading ATTRIBUTE_CATEGORY and the relevant ATTRIBUTE segment.

These patterns support message-template validation, dynamic form rendering in the customer support UI, and reporting on attribute usage across forum messages.

Related Objects

• CS.CS_FORUM_MESSAGES_B — parent message header; joined via MESSAGE_ID.
• CS.CS_FORUM_ATTRS_B — attribute definition; joined via ATTRIBUTE_ID.
• FND_SECURITY_GROUPS — security group master; joined via SECURITY_GROUP_ID.
• CS.CS_FORUM_MSG_ATTRS_U1 — unique index enforcing the composite business key.
• CS.CS_FORUM_MSG_ATTRS_N1 — non-unique index on ATTRIBUTE_ID.