Results for “cs_kb_set_type_links”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CS_KB_SET_TYPE_LINKS is a table in the CS (Service) product schema of Oracle E-Business Suite. It stores knowledge base set type links, implementing a one-to-many relationship between knowledge base set types and external entities. In practice, the table associates a given set type — held in CS_KB_SET_TYPES_B — with an external object type registered in JTF_OBJECTS_B, thereby defining which external entities a knowledge base set type may reference.
The ETRM metadata records that this table has not been used since before release 11.5.8. Its presence in 12.1.1 and 12.2.2 is therefore historical and structural rather than functional; Oracle retains it to preserve upgrade compatibility and referential integrity for legacy data, but no current application flow writes to or reads from it in a meaningful way. Consultants encountering it should treat it as a legacy artifact rather than an active configuration or transactional table.
The heuristic Data Vault classification mined from the foreign key structure is link. This suggests a modeling approach in which CS_KB_SET_TYPE_LINKS functions as an associative construct resolving relationships between independent hubs (set types and JTF object types), rather than as a descriptive satellite carrying attribute history. Any modernization effort should treat it as such.
Key Information Stored
The documented physical schema contains 28 columns. The most significant are outlined below; less relevant columns are omitted.
- LINK_ID — the surrogate primary key, defined by CS_KB_SET_TYPE_LINKS_PK and reinforced by unique index CS_KB_SET_TYPE_LINKS_U1. This is the internal identifier for each link row.
- SET_TYPE_ID — foreign key to CS_KB_SET_TYPES_B; identifies the knowledge base set type being linked.
- OBJECT_CODE — foreign key to JTF_OBJECTS_B; identifies the external entity or object type participating in the relationship.
- LINK_TYPE — a discriminator describing the nature or category of the link.
- OTHER_ID, OTHER_CODE — additional identifiers and codes qualifying the external entity side of the relationship.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling multi-organization and data-security access.
- CREATION_DATE, CREATED_BY — standard audit columns recording row creation.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns, available for customer-defined extension.
The business-key candidate identified by unique index is LINK_ID; no composite business key is documented for this table. SET_TYPE_ID and OBJECT_CODE together define the natural association but are not enforced as a unique constraint in the supplied metadata.
Common Use Cases and Queries
Because the table is documented as unused since before 11.5.8, routine querying is limited to data migration auditing, upgrade validation, and historical investigation. A typical diagnostic query joins the link table to its two parent tables to confirm which set types reference which object types:
SELECT link.link_id, link.set_type_id, link.object_code, link.link_type
FROM cs_kb_set_type_links link
WHERE link.set_type_id = :set_type_id;
A reconciliation query can identify orphaned or dangling rows that would block FK validation during an upgrade:
SELECT link.link_id
FROM cs_kb_set_type_links link
WHERE NOT EXISTS (SELECT 1 FROM cs_kb_set_types_b s WHERE s.set_type_id = link.set_type_id)
OR NOT EXISTS (SELECT 1 FROM jtf_objects_b o WHERE o.object_code = link.object_code);
Reporting use cases are essentially forensic: determining whether legacy knowledge base configurations defined external entity links, and confirming that no active interface depends on the rows before archiving or purging them during a migration to a later release.
Related Objects
- CS_KB_SET_TYPES_B — parent table referenced by SET_TYPE_ID; the base table for knowledge base set types.
- JTF_OBJECTS_B — parent table referenced by OBJECT_CODE; the registry of external object types used across CRM and Service modules.
- FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; governs row-level security across the EBS instance.
- CS_KB_SET_TYPE_LINKS_PK / CS_KB_SET_TYPE_LINKS_U1 — the primary key constraint and unique index on LINK_ID.
- CS_KB_SET_TYPES_TL — the translated-name table commonly joined to CS_KB_SET_TYPES_B when reporting set type descriptions.
No dependent views, APIs, or child tables are documented for CS_KB_SET_TYPE_LINKS, consistent with its status as a legacy, non-operational link table.
-
Knowledge base set type links. This table implements the one to many relationship between a set types and external entities. Not used since before 11.5.8
-
Knowledge base set type links. This table implements the one to many relationship between a set types and external entities. Not used since before 11.5.8
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - CS Tables and Views 12.1.1
Table to store web conference details for an SR.
-
eTRM - CS Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - CS Tables and Views 12.1.1
Table to store web conference details for an SR.
-
eTRM - CS Tables and Views 12.2.2