Search Results sync_soln_cat_index

Overview

CS_KB_CONC_PROG_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Knowledge Base (Knowledge Management) module within the Service (CS) product family. Its primary business function is to manage the concurrent indexing infrastructure that underpins Oracle Text search across Knowledge Base content. The package orchestrates the creation, synchronization, and removal of Oracle Text indexes on Knowledge Base entities — solutions, sets, elements, solution categories, and forums — so that end users can perform fast, full-text searching of knowledge articles through the Knowledge Base user interface.

Based on the ETRM metadata, this package is classified as API type OTHER and is registered as VALID in release 12.1.1 and 12.2.2. It exposes a substantial public surface of nineteen documented procedures, indicating it is intended primarily for internal invocation by concurrent programs rather than direct end-user interaction. The package depends on Oracle Text (CTX_DDL, CONTAINS) and on the Application Object Library context utility AD_CTX_DDL.

Key Procedures and Functions

The documented procedures fall into several functional groups:

• Index creation: CREATE_SET_INDEX, CREATE_ELEMENT_INDEX, CREATE_SOLN_CAT_INDEX, and CREATE_FORUM_INDEX build Oracle Text indexes for the set, element, solution category, and forum content types respectively.
• Index synchronization: SYNC_ALL_INDEX, SYNC_SET_INDEX, SYNC_ELEMENT_INDEX, SYNC_SOLN_CAT_INDEX, SYNC_FORUM_INDEX, and the generic SYNC_INDEX refresh index contents at either the individual entity level or across all Knowledge Base indexes.
• Index maintenance: DROP_INDEX removes an index, and MARK_IDX_ON_SEC_CHANGE flags an index as requiring re-indexing when a security-relevant change occurs.
• Aggregation and scoring: UPDATE_SET_COUNT_SUM and UPDATE_USAGE_SCORE recalculate usage statistics, while UPDATE_MAGIC_WORD manages internal control keywords used by the indexing logic.
• Cache management: REBUILD_SOLN_CONTENT_CACHE refreshes the cached solution content used for retrieval.
• Utility and control: DEL_SYNC_PROG removes a synchronization concurrent program registration, GET_MAX_PARALLEL_WORKER returns the maximum parallelism for worker allocation, and IS_VALIDATE_MODE indicates whether the package is running in validation mode.

Tables Accessed

The package reads and writes Knowledge Base and Oracle Text metadata tables, accessed through APPS synonyms. Solution, set, and element text is stored in CS_KB_ELEMENTS_B/TL, CS_KB_SETS_B/TL, and CS_KB_SOLN_CATEGORIES_TL; forum text resides in CS_FORUM_MESSAGES_TL. Usage and history tracking rely on CS_KB_HISTORIES_B, CS_KB_SET_USED_HISTS, CS_KB_SET_USED_SUMS, and CS_KB_USED_SUM_DEFS_B. Operational control tables include AD_CTX_DDL for text DDL operations, CTX_DDL for the Oracle Text index API, DBA_INDEXES for index introspection, CONTAINS for text queries, and DBMS_RANDOM for internal randomization or sampling.

Usage Notes

CS_KB_CONC_PROG_PKG is referenced by zero other packages according to the dependency listing, so it is not a general-purpose callable API. It is intended to be driven by concurrent programs and scheduled jobs in the Knowledge Base module, most notably the index synchronization programs that periodically refresh Oracle Text indexes. Administrators typically trigger index creation or synchronization after bulk knowledge article loads, category or set changes, or security reconfiguration. The DEL_SYNC_PROG procedure supports lifecycle management by removing stale concurrent program registrations.

Custom extensions should not call this package directly unless replicating Knowledge Base indexing behavior; modifications to its procedures risk invalidating Oracle Text indexes. Because it operates on indexed Knowledge Base content, the package has a material performance impact and should be scheduled during periods of low user activity. In both 12.1.1 and 12.2.2 the package remains valid and unchanged in ownership, and no Oracle-recommended direct invocation path exists outside the standard concurrent program framework.