Results for “assoc_degree”

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

Overview

CS_KB_SET_ELES is a Service (CS) module table in the Oracle E-Business Suite that stores knowledge base set elements. As its description states, the table implements the many-to-many relationship between knowledge base sets and knowledge base elements, allowing a single element to participate in multiple sets and a single set to contain multiple elements. In Oracle EBS 12.1.1 and 12.2.2 it resides in the CS schema, is registered as VALID, and is part of the Service knowledge base data model. The object is exposed through the standard EBS dictionary and is therefore accessible to concurrent programs, Oracle Reports, OAF pages, and custom SQL for reporting and integration.

From a Data Vault modeling perspective, the metadata's heuristic classification is link. This is consistent with its structure: the table carries no descriptive attributes of a business entity, but instead materializes the association between two independent business entities (sets and elements), with the composite key formed by two foreign keys.

Key Information Stored

The table contains 26 documented columns. The most significant columns are:

• SET_ID — Foreign key to CS_KB_SETS_B. Identifies the parent knowledge base set.
• ELEMENT_ID — Foreign key to CS_KB_ELEMENTS_B. Identifies the associated knowledge base element.
• ELEMENT_ORDER — Sequence position of the element within the set; supports ordered presentation of set contents.
• ASSOC_DEGREE — Degree or weight associated with the set-to-element association, used in knowledge base ranking or scoring logic.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS; enforces multi-org / security group isolation of the record.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns that identify who created and last modified the association and when.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) columns, available for customer-specific extensions without schema modification.

The primary key constraint is CS_KB_SET_ELES_PK, defined on (SET_ID, ELEMENT_ID). A unique index, CS_KB_SET_ELES_U1, is also documented on the same two columns, so the business-key candidate for uniquely identifying one association row is the SET_ID + ELEMENT_ID combination. There is no independent surrogate key: the two foreign keys together serve as the primary identifier of the link. Foreign keys reference CS_KB_SETS_B (SET_ID), CS_KB_ELEMENTS_B (ELEMENT_ID), and FND_SECURITY_GROUPS (SECURITY_GROUP_ID).

Common Use Cases and Queries

Typical use cases include determining which elements belong to a given set, determining which sets reference a given element, and reporting the ordered contents of a set for documentation or training material generation.

Query all elements belonging to a specific set, ordered as stored:

• SELECT element_id, element_order, assoc_degree FROM cs_kb_set_eles WHERE set_id = :set_id ORDER BY element_order;

Query all sets that contain a specific element:

• SELECT set_id FROM cs_kb_set_eles WHERE element_id = :element_id;

Join the link to its two parent entities to produce a denormalized set-content report:

• SELECT s.set_id, s.name, e.element_id, e.name FROM cs_kb_set_eles l JOIN cs_kb_sets_b s ON s.set_id = l.set_id JOIN cs_kb_elements_b e ON e.element_id = l.element_id ORDER BY s.set_id, l.element_order;

Administrative checks include detecting orphan associations (rows whose SET_ID or ELEMENT_ID no longer exists in the parent tables) and verifying that ELEMENT_ORDER sequences have no gaps. Because SECURITY_GROUP_ID participates in the schema, multi-org aware reports should filter or join on FND_SECURITY_GROUPS.

Related Objects

• CS_KB_SETS_B — Parent set table; joined on CS_KB_SET_ELES.SET_ID = CS_KB_SETS_B.SET_ID.
• CS_KB_ELEMENTS_B — Parent element table; joined on CS_KB_SET_ELES.ELEMENT_ID = CS_KB_ELEMENTS_B.ELEMENT_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID to enforce security group partitioning.
• CS_KB_SET_ELES_PK / CS_KB_SET_ELES_U1 — Primary key and unique index constraints that enforce uniqueness of the SET_ID + ELEMENT_ID combination.
• The corresponding _TL tables for sets and elements (translations) and the knowledge base concurrent programs and OAF pages that maintain set composition should also be considered when building end-to-end traceability.