Search Results get_category_group_id

Overview

CS_KB_SECURITY_PVT is a private PL/SQL package in the APPS schema that implements the security and visibility model for Oracle E-Business Suite Knowledge Management (Knowledge Base) solutions. Knowledge Base articles must be segmented so that only authorized audiences — whether internal support agents, external customers, or restricted groups — can retrieve and view a given solution. This package encapsulates that segmentation logic by managing category groups, the flow ordering that determines how category filters are presented, and the denormalized visibility tables that the Knowledge Base search and query views rely upon at runtime.

The package is classified as a Private (PVT) API, meaning it is not intended for direct customer invocation; it is consumed internally by the Knowledge Base UI and by other public Knowledge Base packages. It is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its object definition references only SYS.STANDARD, confirming a self-contained dependency footprint within the APPS schema.

Key Procedures and Functions

The package exposes 23 documented procedures and functions, organized into functional groupings:

• Visibility maintenance — CREATE_VISIBILITY, UPDATE_VISIBILITY, and DELETE_VISIBILITY manage individual visibility records that control who may see a solution.
• Category group maintenance — CREATE_CATEGORY_GROUP, UPDATE_CATEGORY_GROUP, and DELETE_CATEGORY_GROUP manage the parent category-group definitions used to organize categories for security filtering.
• Denormalization processing — POPULATE_CAT_GRP_DENORM and REPOPULATE_CAT_GRP_DENORM build and rebuild the denormalized category-group table that accelerates Knowledge Base queries; UPDATE_DENORM_VIS_POSITION refreshes positional ordering within that denormalized structure.
• Category group membership — CREATE_CATEGORY_GROUP_MEMBER and DELETE_CATEGORY_GROUP_MEMBER add or remove members from a category group. ADD_CAT_GRP_MEMBER_TO_DENORM, ADD_CATEGORY_TO_DENORM, REMOVE_CG_MEMBER_FROM_DENORM, UPDATE_CATEGORY_TO_DENORM, and REMOVE_CATEGORY_FROM_CAT_GROUP keep the denormalized structures synchronized with membership changes.
• Category group flows — CREATE_CATEGORY_GROUP_FLOW defines the flow relationship between category groups, governing presentation order of category selections.
• Lookup functions — GET_CATEGORY_GROUP_ID, GET_SOLN_VISIBILITY_POSITION, and GET_STMT_VISIBILITY_POSITION return identifiers and positional values used by callers to resolve group membership and ordering.

The procedures operate as a coordinated set: changes to category groups or memberships are paired with denormalization calls so that query performance remains consistent with the underlying security configuration.

Tables Accessed

The package reads and writes the Knowledge Base security and category schema, accessed through APPS synonyms:

• CS_KB_CATEGORY_GROUPS_B and its _S sequence-backed column — base category group definitions.
• CS_KB_CAT_GROUP_MEMBERS and CS_KB_CAT_GROUP_DENORM — membership records and the denormalized representation used for high-volume queries.
• CS_KB_CAT_GROUP_FLOWS — flow ordering data between category groups.
• CS_KB_VISIBILITIES_B and _S — visibility definitions for solutions and statements.
• CS_KB_SETS_B, CS_KB_SET_CATEGORIES, and CS_KB_SET_ELES — category sets and their elements used to scope categories.
• CS_KB_SOLN_CATEGORIES_B and CS_KB_ELEMENTS_B — solution-to-category and element mappings.
• FND_USER — used to resolve user context for visibility and ownership determination.
• DUAL and PLITBLM — standard utility references for scalar evaluation and bulk processing.

Usage Notes

CS_KB_SECURITY_PVT is invoked indirectly rather than from end-user code. The documented dependency list shows it is referenced by twelve objects, including the Knowledge Base public packages CS_KB_SOLUTION_PVT, CS_KB_SOLN_CATEGORIES_PVT, CS_KB_SOLN_IN_PROGRESS_PKG, CS_KB_ELEMENTS_AUDIT_PKG, CS_KB_KWIC_UTIL, CS_KB_WF_PKG, and CS_KNOWLEDGE_PVT, as well as the security-filtered views CS_KB_SECURE_SOLUTIONS_VIEW, CS_KB_LINKED_SOLUTIONS_VIEW, CSD_RO_SOLNS_V, CSD_RO_SERVICE_CODES_V, and CS_SR_KB_SOLUTION_LINKS_V.

Practically, the package executes whenever an agent or administrator creates or edits a solution's visibility, maintains a category group, or reorders category-group flow, most commonly through the Knowledge Base authoring forms within Oracle iSupport, Oracle TeleService, or the Service Request Knowledge tab. It also executes when concurrent denormalization processing rebuilds the category-group structures, and whenever the security-filtered solution views are queried during Knowledge Base search and solution retrieval. Because it is a PVT API, customizations should call the supported public Knowledge Base packages and views rather than CS_KB_SECURITY_PVT directly, preserving upgrade safety across 12.1.1 and 12.2.2.