Results for “cs_kb_visibilities_b”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CS_KB_VISIBILITIES_B is the base table that defines the visibility levels used throughout the Oracle E-Business Suite Knowledge Base, a component of the Service (CS) product family. Each row represents a distinct visibility level that governs which audiences may see a given knowledge solution, category, or set. The table resides in the CS schema and is flagged VALID in the documented environment, confirming availability in both Oracle EBS 12.1.1 and 12.2.2. In 12.2.2 the object is edition-enabled, evidenced by the presence of the ZD_EDITION_NAME column and the composite unique index CS_KB_VISIBILITIES_U1 built on (VISIBILITY_ID, ZD_EDITION_NAME).
From a Data Vault modeling perspective, the mined foreign-key structure suggests a hub-leaning classification. No foreign keys originate from this table; instead, four downstream tables reference it through VISIBILITY_ID. This pattern is characteristic of a hub: a stable, business-key-driven entity around which dependent satellites and links are organized. Treat this classification as a heuristic modeling suggestion rather than a documented architectural mandate.
Key Information Stored
The documented physical schema contains 26 columns. The most significant include:
- VISIBILITY_ID — the surrogate primary key, enforced by CS_KB_VISIBILITIES_B_PK, and also the column referenced by every downstream foreign key. It is additionally the leading column of the unique index CS_KB_VISIBILITIES_U1, making it the primary business-key candidate.
- ZD_EDITION_NAME — the edition discriminator introduced by the 12.2.2 edition-based redefinition architecture; combined with VISIBILITY_ID it forms the unique business key.
- POSITION — the ordinal sequence controlling how visibility levels are ordered for display or processing.
- START_DATE_ACTIVE and END_DATE_ACTIVE — the effective-date range governing when a visibility level is active.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns capturing who created and last modified each row and when.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard flexible descriptive flexfield (DFF) context and segment columns, available for customer-specific extensions.
The translated, user-facing names for these visibility levels are not held here; they are stored in the companion table CS_KB_VISIBILITIES_TL, which joins back on VISIBILITY_ID.
Common Use Cases and Queries
Typical usage centers on resolving the visibility level assigned to knowledge content and presenting its translated name. A common pattern joins the base table to its translation table to obtain display text:
- SELECT b.VISIBILITY_ID, t.NAME, b.POSITION, b.START_DATE_ACTIVE, b.END_DATE_ACTIVE FROM CS_KB_VISIBILITIES_B b, CS_KB_VISIBILITIES_TL t WHERE b.VISIBILITY_ID = t.VISIBILITY_ID AND t.LANGUAGE = USERENV('LANG') AND SYSDATE BETWEEN NVL(b.START_DATE_ACTIVE, SYSDATE) AND NVL(b.END_DATE_ACTIVE, SYSDATE);
- Reverse lookups enumerate which knowledge sets or solution categories are assigned to a given visibility level by querying CS_KB_SETS_B or CS_KB_SOLN_CATEGORIES_B on VISIBILITY_ID.
- Reporting use cases include auditing visibility configuration, ordering levels by POSITION, and generating listings of active visibility levels for administrative review.
- On 12.2.2 environments, queries should account for the edition column by filtering or joining on ZD_EDITION_NAME to isolate the correct edition.
Related Objects
The following objects depend on or reference CS_KB_VISIBILITIES_B through the documented foreign-key relationships:
- CS_KB_VISIBILITIES_TL — the translated table holding language-specific names and descriptions, joined on VISIBILITY_ID.
- CS_KB_SETS_B — knowledge sets that carry an assigned visibility level via VISIBILITY_ID.
- CS_KB_SOLN_CATEGORIES_B — solution categories governed by a visibility level via VISIBILITY_ID.
- CS_KB_CAT_GROUP_DENORM — the denormalized category group structure referencing VISIBILITY_ID.
Together these related tables form the visibility framework that controls access and presentation of Knowledge Base content, with CS_KB_VISIBILITIES_B acting as the central hub.
-
Knowledge Base Visibility Levels (Base Table)
-
Knowledge Base Visibility Levels (Base Table)
-
Secure Solutions View
APPS.CS_KB_SECURE_SOLUTIONS_VIEW·↳ CS_KB_CAT_GROUP_DENORM·↳ CS_KB_SECURITY_PVT·↳ CS_KB_SETS_B·Explore CS module →
-
Secure Solutions View
APPS.CS_KB_SECURE_SOLUTIONS_VIEW·↳ CS_KB_CAT_GROUP_DENORM·↳ CS_KB_SECURITY_PVT·↳ CS_KB_SETS_B·Explore CS module →
-
View: CS_KB_VISIBILITIES_VL 12.2.2
Knowledge Base Visibilities Multi Lingual View
APPS.CS_KB_VISIBILITIES_VL·↳ CS_KB_VISIBILITIES_B·↳ CS_KB_VISIBILITIES_TL·Explore CS module →
-
View: CS_KB_VISIBILITIES_VL 12.1.1
Knowledge Base Visibilities Multi Lingual View
APPS.CS_KB_VISIBILITIES_VL·↳ CS_KB_VISIBILITIES_B·↳ CS_KB_VISIBILITIES_TL·Explore CS module →