Search Results cs_kb_set_links




Overview
Explore in AI Chat

Overview

The CS_KB_SET_LINKS table is a core data structure within the Oracle E-Business Suite Service (CS) module, specifically supporting the Knowledge Base (KB) functionality. Its primary role is to implement a one-to-many relationship between a knowledge base set and various external entities. In essence, it acts as a junction table that links a defined collection of knowledge content (a set) to other objects within the application, enabling the association of solution sets with diverse items such as service requests, tasks, or other cataloged objects. This linkage is fundamental for contextual knowledge management and for delivering relevant solution articles or documentation based on related transactional data.

Key Information Stored

The table's structure is designed to capture the essential identifiers for creating these relationships. While a full column list is not provided in the metadata, the documented foreign key relationships highlight the critical fields. The primary key column, LINK_ID, uniquely identifies each link record. The SET_ID column holds the foreign key reference to the specific knowledge base set (CS_KB_SETS_B). The OBJECT_CODE column stores the foreign key reference to the type of external entity being linked, as defined in the JTF_OBJECTS_B table. This design allows a single set to be associated with multiple object codes, fulfilling its one-to-many relationship purpose.

Common Use Cases and Queries

A primary use case is retrieving all external object associations for a specific knowledge set to understand its scope of application. For instance, an application may query this table to determine which object types (e.g., Service Request, Problem) a particular solution set supports. Conversely, a common operational query involves finding all relevant knowledge sets linked to a given transactional entity type to filter or recommend solutions. A typical reporting query pattern would join CS_KB_SET_LINKS to CS_KB_SETS_B for set details and to JTF_OBJECTS_B for the object description.

SELECT s.name AS set_name, o.obj_name AS linked_object
  FROM cs.cs_kb_set_links l,
       cs.cs_kb_sets_b s,
       apps.jtf_objects_b o
 WHERE l.set_id = s.set_id
   AND l.object_code = o.obj_code
   AND s.status = 'PUBLISHED';

Related Objects

  • CS_KB_SETS_B: This is the parent table for knowledge base sets. The relationship is defined by the foreign key CS_KB_SET_LINKS.SET_ID referencing CS_KB_SETS_B.
  • JTF_OBJECTS_B: This table defines the various object entities within the EBS framework. The relationship is defined by the foreign key CS_KB_SET_LINKS.OBJECT_CODE referencing JTF_OBJECTS_B.
  • The table's primary key constraint, CS_KB_SET_LINKS_PK, is enforced on the LINK_ID column.
  • Table: CS_KB_SET_LINKS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_LINKS,  object_name:CS_KB_SET_LINKS,  status:VALID,  product: CS - Service ,  description: Knowledge base set links. This table implements the one to many relationship between a set and external entities. ,  implementation_dba_data: CS.CS_KB_SET_LINKS , 

  • Table: CS_KB_SET_LINKS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_LINKS,  object_name:CS_KB_SET_LINKS,  status:VALID,  product: CS - Service ,  description: Knowledge base set links. This table implements the one to many relationship between a set and external entities. ,  implementation_dba_data: CS.CS_KB_SET_LINKS , 

  • Table: CS_KB_SOLN_CATEGORIES_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SOLN_CATEGORIES_B,  object_name:CS_KB_SOLN_CATEGORIES_B,  status:VALID,  product: CS - Service ,  description: This table stores non-translated data defining a category for solutions. This is a self referencing, one to many, tree structure of categories and subcategories. Solutions are linked to categories via CS_KB_SET_LINKS. ,  implementation_dba_data: CS.CS_KB_SOLN_CATEGORIES_B , 

  • Table: CS_KB_SETS_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SETS_B,  object_name:CS_KB_SETS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base sets (base table). ,  implementation_dba_data: CS.CS_KB_SETS_B , 

  • Table: CS_KB_SETS_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SETS_B,  object_name:CS_KB_SETS_B,  status:VALID,  product: CS - Service ,  description: Knowledge base sets (base table). ,  implementation_dba_data: CS.CS_KB_SETS_B , 

  • Table: CS_KB_SOLN_CATEGORIES_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SOLN_CATEGORIES_B,  object_name:CS_KB_SOLN_CATEGORIES_B,  status:VALID,  product: CS - Service ,  description: This table stores non-translated data defining a category for solutions. This is a self referencing, one to many, tree structure of categories and subcategories. Solutions are linked to categories via CS_KB_SET_LINKS. ,  implementation_dba_data: CS.CS_KB_SOLN_CATEGORIES_B , 

  • View: CS_SR_KB_SOLUTION_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_SOLUTION_LINKS_V,  object_name:CS_SR_KB_SOLUTION_LINKS_V,  status:VALID,  product: CS - Service ,  description: This is the base view in the notes section of the workbench tab for Knowledge Base solution notes. ,  implementation_dba_data: APPS.CS_SR_KB_SOLUTION_LINKS_V , 

  • View: CS_KB_LINKED_SOLUTIONS_VIEW 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_LINKED_SOLUTIONS_VIEW,  object_name:CS_KB_LINKED_SOLUTIONS_VIEW,  status:VALID,  product: CS - Service ,  description: Linked Solutions View ,  implementation_dba_data: APPS.CS_KB_LINKED_SOLUTIONS_VIEW , 

  • View: CS_KB_LINKED_SOLUTIONS_VIEW 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_LINKED_SOLUTIONS_VIEW,  object_name:CS_KB_LINKED_SOLUTIONS_VIEW,  status:VALID,  product: CS - Service ,  description: Linked Solutions View ,  implementation_dba_data: APPS.CS_KB_LINKED_SOLUTIONS_VIEW , 

  • View: CS_SR_KB_SOLUTION_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_SOLUTION_LINKS_V,  object_name:CS_SR_KB_SOLUTION_LINKS_V,  status:VALID,  product: CS - Service ,  description: This is the base view in the notes section of the workbench tab for Knowledge Base solution notes. ,  implementation_dba_data: APPS.CS_SR_KB_SOLUTION_LINKS_V , 

  • View: CS_KB_INTEGRATION_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_INTEGRATION_V,  object_name:CS_KB_INTEGRATION_V,  status:VALID,  product: CS - Service ,  description: View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any application module. ,  implementation_dba_data: APPS.CS_KB_INTEGRATION_V , 

  • View: CS_SR_KB_NOTE_LINKS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_NOTE_LINKS_V,  object_name:CS_SR_KB_NOTE_LINKS_V,  status:VALID,  product: CS - Service ,  description: This view combines JTF notes with knowledge management element links and set links. Used by Oracle Support for integration from Service Requests to Knowledge Management. ,  implementation_dba_data: APPS.CS_SR_KB_NOTE_LINKS_V , 

  • View: CS_SR_KB_NOTE_LINKS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_SR_KB_NOTE_LINKS_V,  object_name:CS_SR_KB_NOTE_LINKS_V,  status:VALID,  product: CS - Service ,  description: This view combines JTF notes with knowledge management element links and set links. Used by Oracle Support for integration from Service Requests to Knowledge Management. ,  implementation_dba_data: APPS.CS_SR_KB_NOTE_LINKS_V , 

  • View: CS_KB_INTEGRATION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_INTEGRATION_V,  object_name:CS_KB_INTEGRATION_V,  status:VALID,  product: CS - Service ,  description: View combines JTF notes with knowledge management element links and set links. Used by Knowledge Management for integration from any application module. ,  implementation_dba_data: APPS.CS_KB_INTEGRATION_V ,