Results for “element_id_1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_KB_ELE_ELES is a Service (CS) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model that stores Knowledge Base element element associations. As stated in the ETRM documentation, the table "implements the many to many relationship among the elements." Each row therefore represents a single relationship between two Knowledge Base elements, with the two related element identifiers held in the columns ELEMENT_ID_1 and ELEMENT_ID_2.

Within the CS Knowledge Base schema, which organizes questions, answers, and logical groupings into reusable elements, this table is the association layer that ties those elements together. It does not store the descriptive content of an element; that content resides in CS_KB_ELEMENTS_B. Instead, CS_KB_ELE_ELES records which elements are related to which other elements and carries relationship-level metrics and weighting attributes.

The heuristic Data Vault classification mined from the foreign key structure is "link." This is consistent with the table's two foreign keys to CS_KB_ELEMENTS_B, which is the classic pattern of a link table resolving a many-to-many relationship between instances of a single hub entity. As a modeling suggestion, CS_KB_ELE_ELES is best understood as a self-referencing link between Knowledge Base elements, with the auxiliary columns acting as relationship attributes.

Key Information Stored

The documented physical schema contains 30 columns in the CS schema. The most significant are the two relationship keys, the usage and weighting attributes, the audit columns, the descriptive flexfield attributes, and the security group identifier.

• ELEMENT_ID_1 and ELEMENT_ID_2 — the two Knowledge Base element identifiers that define the relationship. Both are foreign keys to CS_KB_ELEMENTS_B.
• SET_COUNT — count of the number of times the element relationship has been included in a set.
• CUSTOMER_USED_COUNT and AGENT_USED_COUNT — usage counters tracking how often the relationship has been used by customers and by service agents respectively.
• CONFIG_WEIGHT, WEIGHT, and WEIGHT1 — weighting values used to rank or prioritize the relationship, typically for search, ranking, or recommendation purposes.
• SECURITY_GROUP_ID — the security group that owns the row, a foreign key to FND_SECURITY_GROUPS, used for multi-organization data security.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield segments available for customer-specific extensibility.

The surrogate primary key is CS_KB_ELE_ELES_PK, defined as the composite of ELEMENT_ID_1 and ELEMENT_ID_2. This same column pair forms the unique index CS_KB_ELE_ELES_U1, which is documented as the business-key candidate and enforces that no pair of elements is linked more than once.

Common Use Cases and Queries

Because the table captures relationships between Knowledge Base elements, it supports reporting on element linkage, popularity ranking, and set composition. A typical pattern joins both element columns back to CS_KB_ELEMENTS_B twice to retrieve the names of both ends of the relationship.

• Listing all relationships for one element: select ELEMENT_ID_1, ELEMENT_ID_2 from CS_KB_ELE_ELES where ELEMENT_ID_1 = :element_id or ELEMENT_ID_2 = :element_id.
• Ranking relationships by usage: order by CUSTOMER_USED_COUNT + AGENT_USED_COUNT descending to identify the most frequently used element associations.
• Identifying the strongest associations: order by WEIGHT or CONFIG_WEIGHT to surface prioritized relationships.
• Security-restricted reporting: filter by SECURITY_GROUP_ID to respect multi-organization access rules.
• Set membership analysis: aggregate by SET_COUNT to determine how often a relationship participates in problem sets.

Related Objects

The most significant related objects are the referenced element table, the security group table, and the Knowledge Base views and packages that read the associations. Join columns are identified from the documented foreign keys.

• CS_KB_ELEMENTS_B — referenced twice; CS_KB_ELE_ELES.ELEMENT_ID_1 and CS_KB_ELE_ELES.ELEMENT_ID_2 both join to CS_KB_ELEMENTS_B.ELEMENT_ID.
• FND_SECURITY_GROUPS — referenced by CS_KB_ELE_ELES.SECURITY_GROUP_ID.
• CS_KB_ELEMENTS_TL — provides translated element names for display in relationship reports.
• CS_KB_ELES_B and related Knowledge Base element tables that provide set and element context.
• CS Knowledge Base views and PL/SQL APIs that expose element relationships to the Service user interface and search functions.