Search Results cs_kb_sets_b




Overview
Explore in AI Chat

Overview

The CS_KB_SETS_B table is the core base table for storing knowledge base set definitions within Oracle E-Business Suite Service (CS) modules, specifically for versions 12.1.1 and 12.2.2. It functions as the central repository for the metadata that defines a "set," which is a fundamental container for organizing knowledge content. A set can represent a solution, a collection of related articles, a FAQ library, or other structured information repositories. This table holds the foundational attributes of a set, while related tables manage multilingual descriptions, content, categories, and usage tracking. Its primary role is to establish the unique identity and core properties of a knowledge object, enabling the structured management, retrieval, and workflow processing of service knowledge.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond key identifiers, the structure and foreign key relationships indicate the critical data points stored. The primary key, SET_ID, is the unique identifier for every knowledge set. Other essential foreign key columns link a set to its defining characteristics: SET_TYPE_ID (references CS_KB_SET_TYPES_B) classifies the set's purpose; VISIBILITY_ID (references CS_KB_VISIBILITIES_B) controls access and viewing permissions; and FLOW_DETAILS_ID (references CS_KB_WF_FLOW_DETAILS) associates the set with an approval or publishing workflow process. Additional columns in the base table typically include creation dates, last update dates, created by, and last updated by user IDs, which are standard for EBS audit trails.

Common Use Cases and Queries

This table is central to knowledge management operations. Common use cases include administering the knowledge base catalog, generating reports on set utilization, and integrating set data with service requests. A frequent query pattern involves joining the base table with its translated descriptions (CS_KB_SETS_TL) to retrieve a list of sets for a specific language. For example, to find all active sets of a particular type, one might use a query such as: SELECT b.SET_ID, tl.NAME FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl WHERE b.SET_ID = tl.SET_ID AND tl.LANGUAGE = USERENV('LANG') AND b.SET_TYPE_ID = <type_id>;. Reporting on set popularity often involves joining CS_KB_SETS_B with the usage summary table (CS_KB_SET_USED_SUMS). Implementation teams may also query this table to validate data integrity or to extract set metadata for migration or integration projects.

Related Objects

As evidenced by its extensive foreign key relationships, CS_KB_SETS_B is the hub for a significant portion of the Service Knowledge Base schema. Key related objects include: CS_KB_SETS_TL for translated set names and descriptions; CS_KB_SET_ELES for the actual content elements (articles, paragraphs) within a set; and CS_KB_SET_CATEGORIES, CS_KB_SET_PRODUCTS, and CS_KB_SET_PLATFORMS for classification. The tables CS_KB_SET_USED_SUMS and CS_KB_SET_USED_HISTS track usage metrics. Furthermore, CS_KB_SET_SETS manages hierarchical relationships between sets, and CS_KB_SET_CHG_HISTS logs modification history. The table is referenced by numerous child entities, including CS_KB_SET_ATTR_VALS, CS_KB_SET_LINKS, and CS_KB_SET_RECS, underscoring its pivotal role in the knowledge architecture.

  • 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_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_SET_SETS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_SETS,  object_name:CS_KB_SET_SETS,  status:VALID,  product: CS - Service ,  description: Knowledge base set sets. This table implements the many to many relationship between sets and sets. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_SETS , 

  • 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 , 

  • Table: CS_KB_SET_SETS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_SETS,  object_name:CS_KB_SET_SETS,  status:VALID,  product: CS - Service ,  description: Knowledge base set sets. This table implements the many to many relationship between sets and sets. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_SETS , 

  • 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_KB_SETS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_SETS_VL,  object_name:CS_KB_SETS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_SETS_B and CS_KB_SETS_TL tables. ,  implementation_dba_data: APPS.CS_KB_SETS_VL , 

  • View: CS_KB_SETS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_SETS_VL,  object_name:CS_KB_SETS_VL,  status:VALID,  product: CS - Service ,  description: Multi-lingual view for CS_KB_SETS_B and CS_KB_SETS_TL tables. ,  implementation_dba_data: APPS.CS_KB_SETS_VL , 

  • Table: CS_KB_SET_PLATFORMS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_PLATFORMS,  object_name:CS_KB_SET_PLATFORMS,  status:VALID,  product: CS - Service ,  description: Knowledge base set-platform linking table ,  implementation_dba_data: CS.CS_KB_SET_PLATFORMS , 

  • Table: CS_KB_SET_USED_HISTS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_USED_HISTS,  object_name:CS_KB_SET_USED_HISTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set used histories. ,  implementation_dba_data: CS.CS_KB_SET_USED_HISTS , 

  • Table: CS_KB_SETS_TL 12.1.1

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

  • Table: CS_KB_SET_USED_HISTS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_USED_HISTS,  object_name:CS_KB_SET_USED_HISTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set used histories. ,  implementation_dba_data: CS.CS_KB_SET_USED_HISTS , 

  • Table: CS_KB_SETS_TL 12.2.2

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

  • Table: CS_KB_SET_RECS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_RECS,  object_name:CS_KB_SET_RECS,  status:VALID,  product: CS - Service ,  description: Knowledge base set recommendations. This table maintains a list of recommended sets or solutions. ,  implementation_dba_data: CS.CS_KB_SET_RECS , 

  • Table: CS_KB_SET_PRODUCTS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_PRODUCTS,  object_name:CS_KB_SET_PRODUCTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set-product linking table ,  implementation_dba_data: CS.CS_KB_SET_PRODUCTS , 

  • Table: CS_KB_SET_PRODUCTS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_PRODUCTS,  object_name:CS_KB_SET_PRODUCTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set-product linking table ,  implementation_dba_data: CS.CS_KB_SET_PRODUCTS , 

  • Table: CS_KB_SET_CATEGORIES 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_CATEGORIES,  object_name:CS_KB_SET_CATEGORIES,  status:VALID,  product: CS - Service ,  description: Knowledge Base Solution Categories (Linking Table) ,  implementation_dba_data: CS.CS_KB_SET_CATEGORIES , 

  • Table: CS_KB_WF_FLOW_DETAILS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_WF_FLOW_DETAILS,  object_name:CS_KB_WF_FLOW_DETAILS,  status:VALID,  product: CS - Service ,  description: Solution flow details table ,  implementation_dba_data: CS.CS_KB_WF_FLOW_DETAILS , 

  • Table: CS_KB_SET_RECS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_RECS,  object_name:CS_KB_SET_RECS,  status:VALID,  product: CS - Service ,  description: Knowledge base set recommendations. This table maintains a list of recommended sets or solutions. ,  implementation_dba_data: CS.CS_KB_SET_RECS , 

  • Table: CS_KB_VISIBILITIES_B 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_VISIBILITIES_B,  object_name:CS_KB_VISIBILITIES_B,  status:VALID,  product: CS - Service ,  description: Knowledge Base Visibility Levels (Base Table) ,  implementation_dba_data: CS.CS_KB_VISIBILITIES_B , 

  • Table: CS_KB_VISIBILITIES_B 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_VISIBILITIES_B,  object_name:CS_KB_VISIBILITIES_B,  status:VALID,  product: CS - Service ,  description: Knowledge Base Visibility Levels (Base Table) ,  implementation_dba_data: CS.CS_KB_VISIBILITIES_B , 

  • Table: CS_KB_SET_TYPES_B 12.1.1

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

  • Table: CS_KB_SET_ELES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ELES,  object_name:CS_KB_SET_ELES,  status:VALID,  product: CS - Service ,  description: Knowledge base set elements. This table implements the many to many relationship between sets and elements. ,  implementation_dba_data: CS.CS_KB_SET_ELES , 

  • 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_USED_SUMS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_USED_SUMS,  object_name:CS_KB_SET_USED_SUMS,  status:VALID,  product: CS - Service ,  description: Knowledge base set used summaries. This table keep track of the used count over a period of time defined in the CS_KB_USED_SUM_DEFS_VL. ,  implementation_dba_data: CS.CS_KB_SET_USED_SUMS , 

  • Table: CS_KB_SET_USED_SUMS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_USED_SUMS,  object_name:CS_KB_SET_USED_SUMS,  status:VALID,  product: CS - Service ,  description: Knowledge base set used summaries. This table keep track of the used count over a period of time defined in the CS_KB_USED_SUM_DEFS_VL. ,  implementation_dba_data: CS.CS_KB_SET_USED_SUMS , 

  • Table: CS_KB_SET_ATTR_VALS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ATTR_VALS,  object_name:CS_KB_SET_ATTR_VALS,  status:VALID,  product: CS - Service ,  description: Knowledge base set attribute values. This table implements the many to many relationship between sets and attribute values. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_ATTR_VALS , 

  • Table: CS_KB_SET_CHG_HISTS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_CHG_HISTS,  object_name:CS_KB_SET_CHG_HISTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set change histories. This table implements the many to many relationship between sets and histories. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_CHG_HISTS , 

  • Table: CS_KB_SET_ATTR_VALS 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ATTR_VALS,  object_name:CS_KB_SET_ATTR_VALS,  status:VALID,  product: CS - Service ,  description: Knowledge base set attribute values. This table implements the many to many relationship between sets and attribute values. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_ATTR_VALS , 

  • Table: CS_KB_SET_PLATFORMS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_PLATFORMS,  object_name:CS_KB_SET_PLATFORMS,  status:VALID,  product: CS - Service ,  description: Knowledge base set-platform linking table ,  implementation_dba_data: CS.CS_KB_SET_PLATFORMS , 

  • Table: CS_KB_SET_CATEGORIES 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_CATEGORIES,  object_name:CS_KB_SET_CATEGORIES,  status:VALID,  product: CS - Service ,  description: Knowledge Base Solution Categories (Linking Table) ,  implementation_dba_data: CS.CS_KB_SET_CATEGORIES , 

  • Table: CS_KB_WF_FLOW_DETAILS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_WF_FLOW_DETAILS,  object_name:CS_KB_WF_FLOW_DETAILS,  status:VALID,  product: CS - Service ,  description: Solution flow details table ,  implementation_dba_data: CS.CS_KB_WF_FLOW_DETAILS , 

  • Table: CS_KB_SET_TYPES_B 12.2.2

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

  • Table: CS_KB_SET_ELES 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_ELES,  object_name:CS_KB_SET_ELES,  status:VALID,  product: CS - Service ,  description: Knowledge base set elements. This table implements the many to many relationship between sets and elements. ,  implementation_dba_data: CS.CS_KB_SET_ELES , 

  • 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_SET_CHG_HISTS 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_SET_CHG_HISTS,  object_name:CS_KB_SET_CHG_HISTS,  status:VALID,  product: CS - Service ,  description: Knowledge base set change histories. This table implements the many to many relationship between sets and histories. Not used since before 11.5.8 ,  implementation_dba_data: CS.CS_KB_SET_CHG_HISTS , 

  • View: CS_KB_SECURE_SOLUTIONS_VIEW 12.2.2

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

  • View: CS_KB_SECURE_SOLUTIONS_VIEW 12.1.1

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

  • View: CS_KB_SETS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_SETS_V,  object_name:CS_KB_SETS_V,  status:VALID,  product: CS - Service ,  description: A view on top of CS_KB_SETS_VL and CS_KB_SET_TYPES_VL. ,  implementation_dba_data: APPS.CS_KB_SETS_V , 

  • View: CS_KB_SETS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_SETS_V,  object_name:CS_KB_SETS_V,  status:VALID,  product: CS - Service ,  description: A view on top of CS_KB_SETS_VL and CS_KB_SET_TYPES_VL. ,  implementation_dba_data: APPS.CS_KB_SETS_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_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 ,