Search Results cs_kb_search_pvt

Overview

CS_KB_SEARCH_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Knowledge Base / iSupport (CS) product family. In Oracle EBS 12.1.1 and 12.2.2, the CS_KB objects underpin the interaction-center and self-service knowledge management features used by service agents and end users to author, search, and consume knowledge articles. As its name implies, CS_KB_SEARCH_PVT encapsulates search-related logic, providing internal helper routines that higher-level knowledge base search APIs and user interfaces call to retrieve statistics about how frequently a given knowledge set has been used.

The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking session rather than as the definer, and the header identification (cskbschs.pls 120.0, dated 2005) indicates it is a long-standing internal utility carried forward across releases. It is classified as a PVT package, so it is intended strictly for internal consumption by other CS_KB routines and is not part of the public API surface.

Key Procedures and Functions

The documented package exposes a single function:

• GET_SET_USAGE_COUNT — Returns a numeric count reflecting how often a specified knowledge set has been used. It accepts a knowledge set identifier (p_set_id) and returns a NUMBER. The function is used internally to drive usage statistics or ranking logic within knowledge base search, allowing the search engine to weight or report sets by their historical utilization.

No other procedures or functions are documented in the ETRM metadata. As the routine names and the package title suggest, this is a narrowly scoped helper rather than a full search API.

Tables Accessed

The package reads from two documented tables via APPS synonyms:

• CS_KB_SET_USED_SUMS — Summary table holding aggregated usage counts per knowledge set; the primary source for the usage count returned by GET_SET_USAGE_COUNT.
• CS_KB_USED_SUM_DEFS_B — Definition/base table describing the usage summary configurations, providing the metadata that determines how sums are computed or grouped.

Both tables belong to the CS Knowledge Base schema. Because the function only returns a count, the operations are read-only; no DML is documented.

Usage Notes

CS_KB_SEARCH_PVT is a private package and is not intended for direct invocation by customers or extension developers. It is referenced by zero other packages per the ETRM metadata, which underscores its internal, leaf-level role — it is typically called from within CS_KB search components, forms, or concurrent aggregation logic that needs a usage statistic for ranking or display. In practice, it would be invoked from Oracle Forms-based agent UIs, self-service knowledge search pages, or background jobs that populate the CS_KB_SET_USED_SUMS summary table. Custom code generally should not call this package directly; instead, developers should rely on the public CS_KB search APIs or SQL views, and treat the summary tables as read-only reference data. Because it is a PVT package with AUTHID CURRENT_USER, any direct call requires the executing user to hold suitable privileges on the underlying CS objects.