Search Results cs_kb_sets_pkg




Overview
Explore in AI Chat

Overview

CS_KB_SETS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the knowledge base solution set functionality within Oracle Service (Customer Support). Its primary responsibility is to provide the data manipulation and language-handling logic for knowledge base "sets," which are the grouping constructs used to organize knowledge base entries, articles, and solutions in the CS_KB_SETS_B and CS_KB_SETS_TL tables. In Oracle EBS 12.1.1 and 12.2.2, this package is a low-level utility and API component rather than an end-user facing module; it is invoked by the Knowledge Base forms and by related PL/SQL APIs (notably CS_KB_SOLUTION_PVT) to create, maintain, and translate set definitions. The package is documented with API classification OTHER, indicating it is a supporting package rather than a formally published public API. The dependency metadata confirms that CS_KB_SETS_PKG references only the SYS STANDARD package as a database-level dependency, while it is referenced by CS_KB_SETS_PKG itself (internal cross-reference) and by CS_KB_SOLUTION_PVT, the private package that manages knowledge base solutions.

Key Procedures and Functions

The documented package exposes seven procedures and functions. Each is described below by name and purpose; parameter lists are intentionally not enumerated because the ETRM metadata does not publish them.

  • INSERT_ROW — Inserts a new knowledge base set record, creating the base (non-translated) row in the CS_KB_SETS_B table.
  • LOCK_ROW — Acquires a row-level lock on an existing set record, typically used to serialize concurrent updates and prevent lost updates during maintenance.
  • UPDATE_ROW — Modifies an existing set record, applying changes to the base row in CS_KB_SETS_B.
  • DELETE_ROW — Removes a set record from the underlying tables, subject to any referential or business rules enforced by the Knowledge Base.
  • ADD_LANGUAGE — Creates the translated (TL) companion row for a set so that the same set can be described in additional installed languages.
  • TRANSLATE_ROW — Updates or populates a translated row in CS_KB_SETS_TL, allowing language-specific descriptions of the set to be maintained.
  • LOAD_ROW — Loads a set record from a source (for example, seed data or migration input), combining insert and translation logic as required by the loading context.

The procedures collectively implement a standard EBS base/translation table dml pattern: a base table (CS_KB_SETS_B) plus a translation table (CS_KB_SETS_TL) with the well-known TL APIs for adding and translating rows.

Tables Accessed

Per the documented metadata, the package accesses the following tables via APPS synonyms:

  • CS_KB_SETS_B — The base table storing the fundamental, language-independent attributes of each knowledge base set. Used by INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW, and LOAD_ROW.
  • CS_KB_SETS_TL — The translation table storing language-specific (translated) text attributes of sets. Used by ADD_LANGUAGE, TRANSLATE_ROW, and LOAD_ROW.
  • FND_LANGUAGES — The Oracle Application Object Library table that lists installed and licensed languages. Referenced by the language-handling procedures to validate and drive translation operations.

Usage Notes

CS_KB_SETS_PKG is typically invoked indirectly rather than by end users. In Oracle EBS 12.1.1 and 12.2.2, it is called by the Knowledge Base setup and maintenance forms within Oracle Service when administrators define or change knowledge base sets, and it is called programmatically by CS_KB_SOLUTION_PVT during solution maintenance, since that package is documented as a direct referencer. It is also invoked by concurrent programs, data-loading scripts, or migration utilities that need to seed or load set definitions using LOAD_ROW. Because the package is classified as OTHER and is not a published API, customizations should generally interact with the supported Knowledge Base APIs and forms rather than calling these procedures directly. Any custom code that does call them must operate in the APPS schema context, respect the base/translation table model (insert base rows first, then add language rows), and acquire locks through LOCK_ROW where concurrent maintenance is possible. Developers extending knowledge base set functionality should also verify dependencies against CS_KB_SOLUTION_PVT, as changes to this package can affect solution-level operations.