Results for “cs_kb_element_links”

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

Overview

CS_KB_ELEMENT_LINKS is a transactional table in the Oracle E-Business Suite Service (CS) module, owned by the CS schema. It implements the one-to-many relationship between a knowledge base element and external entities, allowing a single element stored in the knowledge repository to be associated with multiple targets such as products, categories, or other JTF-registered objects. The object is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and contains 27 columns.

In Data Vault modeling terms, the mined metadata classifies this table heuristically as a link object. This reflects its structural role: it resolves many-to-many and one-to-many associations between the CS_KB_ELEMENTS_B hub and the external object referenced through JTF_OBJECTS_B. The classification is a modeling suggestion rather than a native Oracle construct; the table itself is a standard EBS intersection table.

Key Information Stored

The primary key is the surrogate identifier LINK_ID, enforced by the unique index CS_KB_ELEMENT_LINKS_PK. A second unique index, CS_KB_ELEMENT_LINKS_U2, spans OBJECT_CODE, ELEMENT_ID, and OTHER_ID, and this composite key is the strongest documented business-key candidate, preventing duplicate associations for the same element and external entity.

• LINK_ID — surrogate primary key uniquely identifying each link record.
• ELEMENT_ID — foreign key to CS_KB_ELEMENTS_B, identifying the knowledge base element being linked.
• OBJECT_CODE — foreign key to JTF_OBJECTS_B, identifying the type of external entity participating in the link.
• OTHER_ID — identifier of the specific external entity instance associated with the element.
• LINK_TYPE — classifies the nature of the relationship between the element and the external entity.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-organization and data security filtering.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns capturing who created and last modified each link.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns used for customer-specific extensions.

Common Use Cases and Queries

Typical usage centers on reporting and troubleshooting the associations between knowledge base elements and the products, categories, or other JTF objects they are exposed against. A common query joins the links table to its parent element and to the JTF object definition:

• List all external entities linked to a specific knowledge element: SELECT OBJECT_CODE, OTHER_ID FROM CS_KB_ELEMENT_LINKS WHERE ELEMENT_ID = :p_element_id;
• Resolve the linked object type name: SELECT l.ELEMENT_ID, o.OBJECT_CODE FROM CS_KB_ELEMENT_LINKS l, JTF_OBJECTS_B o WHERE l.OBJECT_CODE = o.OBJECT_CODE;
• Locate duplicate or conflicting links using the business key: group by OBJECT_CODE, ELEMENT_ID, OTHER_ID and filter counts greater than one.
• Security-scoped reporting: filter by SECURITY_GROUP_ID to respect multi-org access in extracts and BI reports.
• Data-warehouse staging: extract LINK_ID with the audit and flexfield columns for incremental loads keyed on LAST_UPDATE_DATE.

Related Objects

• CS_KB_ELEMENTS_B — parent element table; CS_KB_ELEMENT_LINKS.ELEMENT_ID references it.
• CS_KB_ELEMENTS_TL — translation table supplying element display names for reports.
• JTF_OBJECTS_B — object registry; CS_KB_ELEMENT_LINKS.OBJECT_CODE references it, defining the external entity type.
• FND_SECURITY_GROUPS — security group definition referenced by SECURITY_GROUP_ID.
• CS_KB_ELEMENT_LINKS_PK / CS_KB_ELEMENT_LINKS_U1 / CS_KB_ELEMENT_LINKS_U2 — supporting unique indexes enforcing identity and business-key integrity.
• CS knowledge base APIs — the Service module's knowledge management PL/SQL interfaces that maintain element-to-object associations through this table.