Results for “cs_kb_ele_type_links”

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

Overview

CS_KB_ELE_TYPE_LINKS is a Service (CS) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores knowledge base element type links. As the description states, the table implements the one-to-many relationship between element types and external entities. An element type defines a category of knowledge content (for example, a solution, a task, or a note), while the external entity identifies a specific object registered in the JTF object framework. This table records which element types may be associated with which external entities, and how.

The object is owned by the CS schema and is fully VALID. The documented physical schema in ETRM 12.2.2 lists 29 columns, reflecting the standard Oracle EBS column set: four WHO audit columns, a 15-column ATTRIBUTE DFF block, and a security group column. The table carries a primary key constraint, CS_KB_ELE_TYPE_LINKS_PK, on LINK_ID, and a unique index, CS_KB_ELE_TYPE_LINKS_U1, on (LINK_ID, ZD_EDITION_NAME). Based on the foreign key structure, the heuristic Data Vault classification of this object is a link table — a modeling suggestion rather than a documented fact. Its function is to resolve a relationship between independent entities rather than to hold descriptive history.

Key Information Stored

The most significant columns are those that define the link and its target entities:

• LINK_ID — the surrogate primary key, generated per row and enforced by CS_KB_ELE_TYPE_LINKS_PK. Also participates in the unique index CS_KB_ELE_TYPE_LINKS_U1 alongside ZD_EDITION_NAME.
• ELEMENT_TYPE_ID — foreign key to CS_KB_ELEMENT_TYPES_B; identifies the knowledge element type being linked.
• OBJECT_CODE — foreign key to JTF_OBJECTS_B; identifies the external entity (JTF registered object) participating in the link.
• LINK_TYPE — classifies the nature of the association between the element type and the external object.
• OTHER_ID and OTHER_CODE — alternate identifier and code values used when the link target is not fully described by OBJECT_CODE.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS; drives Multi-Org / data security filtering.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns recording insert and update provenance.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield block available for customer-specific extensions.
• ZD_EDITION_NAME — editioning support column; combined with LINK_ID in the unique business-key candidate index.

Common Use Cases and Queries

Typical uses of this table are: resolving which external entities an element type is permitted to reference; reporting the set of knowledge types configured against a JTF object; and auditing link configuration after upgrades. A standard join pattern resolves both parents:

• Join CS_KB_ELE_TYPE_LINKS.ELEMENT_TYPE_ID = CS_KB_ELEMENT_TYPES_B.ELEMENT_TYPE_ID to obtain element type names.
• Join CS_KB_ELE_TYPE_LINKS.OBJECT_CODE = JTF_OBJECTS_B.OBJECT_CODE to obtain the external entity description.
• Filter on SECURITY_GROUP_ID to enforce organizational access rules.

A representative query aggregates links by element type for configuration review: select et.element_type_id, count(l.link_id) from cs_kb_element_types_b et, cs_kb_ele_type_links l where l.element_type_id = et.element_type_id and l.security_group_id = :p_group group by et.element_type_id. Administrators also query by LINK_TYPE and OBJECT_CODE to determine whether a given external object is already registered against a knowledge type before inserting or deleting a link.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign keys and primary key structure:

• CS_KB_ELEMENT_TYPES_B — parent of ELEMENT_TYPE_ID; defines the knowledge element type.
• JTF_OBJECTS_B — parent of OBJECT_CODE; the registry of external entities.
• FND_SECURITY_GROUPS — parent of SECURITY_GROUP_ID; provides the security grouping used for access control.
• CS_KB_ELE_TYPE_LINKS_PK — primary key constraint on LINK_ID.
• CS_KB_ELE_TYPE_LINKS_U1 — unique index on (LINK_ID, ZD_EDITION_NAME), the documented business-key candidate.

Knowledge base setup and configuration forms in the Service module read and maintain this table; deleting an element type or a JTF object requires that dependent rows here be removed or reassigned first, since the foreign keys enforce referential integrity.