Search Results cs_kb_visibilities_b




Overview
Explore in AI Chat

Overview

The CS_KB_VISIBILITIES_B table is a core data dictionary table within the Oracle E-Business Suite Service (CS) module, specifically for the Knowledge Base (KB) functionality. It serves as the base table for defining and storing distinct visibility levels or access tiers that can be assigned to knowledge artifacts. Its primary role is to act as a master reference, enabling controlled access to knowledge solutions, categories, and sets based on user privileges or organizational roles. By centralizing visibility definitions, it provides a scalable mechanism for content security and information segmentation across the service knowledge repository in both EBS 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure can be inferred from its relationships and standard Oracle EBS conventions. The central column is VISIBILITY_ID, which is the unique numeric identifier (Primary Key) for each visibility level. Typically, a base table like this would also contain columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and START_DATE_ACTIVE/END_DATE_ACTIVE for lifecycle management. The descriptive name for each visibility level is stored in the corresponding translation table, CS_KB_VISIBILITIES_TL, which is linked via the VISIBILITY_ID foreign key.

Common Use Cases and Queries

This table is fundamental for administering and reporting on knowledge access controls. Common use cases include auditing which visibility levels are in use, determining the visibility setting of a specific solution category, or creating reports on content distribution across access tiers. A typical query would join the base table with its translation table to retrieve meaningful names. For example, to list all active visibility levels, one might use:

  • SELECT b.VISIBILITY_ID, tl.NAME FROM CS_KB_VISIBILITIES_B b, CS_KB_VISIBILITIES_TL tl WHERE b.VISIBILITY_ID = tl.VISIBILITY_ID AND tl.LANGUAGE = USERENV('LANG');

Another critical pattern involves joining to related entities to find all solution categories assigned a specific visibility level, using the foreign key in CS_KB_SOLN_CATEGORIES_B.

Related Objects

The CS_KB_VISIBILITIES_B table is a key reference point within the Knowledge Base schema. As documented, its primary key (VISIBILITY_ID) is referenced by the following objects:

  • CS_KB_CAT_GROUP_DENORM: Joined via CS_KB_CAT_GROUP_DENORM.VISIBILITY_ID. This links visibility levels to category group denormalized data.
  • CS_KB_SETS_B: Joined via CS_KB_SETS_B.VISIBILITY_ID. This assigns a visibility level to entire knowledge sets.
  • CS_KB_SOLN_CATEGORIES_B: Joined via CS_KB_SOLN_CATEGORIES_B.VISIBILITY_ID. This controls the visibility for individual solution categories.
  • CS_KB_VISIBILITIES_TL: Joined via CS_KB_VISIBILITIES_TL.VISIBILITY_ID. This is the translation table that provides language-specific names for each visibility level.
  • 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_CAT_GROUP_DENORM 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CAT_GROUP_DENORM,  object_name:CS_KB_CAT_GROUP_DENORM,  status:VALID,  product: CS - Service ,  description: Knowledge Base Category Group Denormalized Information ,  implementation_dba_data: CS.CS_KB_CAT_GROUP_DENORM , 

  • Table: CS_KB_VISIBILITIES_TL 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_VISIBILITIES_TL,  object_name:CS_KB_VISIBILITIES_TL,  status:VALID,  product: CS - Service ,  description: Knowledge Base Visibilities (Translation Table) ,  implementation_dba_data: CS.CS_KB_VISIBILITIES_TL , 

  • Table: CS_KB_VISIBILITIES_TL 12.1.1

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_VISIBILITIES_TL,  object_name:CS_KB_VISIBILITIES_TL,  status:VALID,  product: CS - Service ,  description: Knowledge Base Visibilities (Translation Table) ,  implementation_dba_data: CS.CS_KB_VISIBILITIES_TL , 

  • Table: CS_KB_CAT_GROUP_DENORM 12.2.2

    owner:CS,  object_type:TABLE,  fnd_design_data:CS.CS_KB_CAT_GROUP_DENORM,  object_name:CS_KB_CAT_GROUP_DENORM,  status:VALID,  product: CS - Service ,  description: Knowledge Base Category Group Denormalized Information ,  implementation_dba_data: CS.CS_KB_CAT_GROUP_DENORM , 

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

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

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

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

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

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_VISIBILITIES_VL,  object_name:CS_KB_VISIBILITIES_VL,  status:VALID,  product: CS - Service ,  description: Knowledge Base Visibilities Multi Lingual View ,  implementation_dba_data: APPS.CS_KB_VISIBILITIES_VL , 

  • View: CS_KB_VISIBILITIES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CS.CS_KB_VISIBILITIES_VL,  object_name:CS_KB_VISIBILITIES_VL,  status:VALID,  product: CS - Service ,  description: Knowledge Base Visibilities Multi Lingual View ,  implementation_dba_data: APPS.CS_KB_VISIBILITIES_VL ,