Search Results cs_kb_result_obj_type




Overview
Explore in AI Chat

Overview

IBU_KNOWLEDGE_GRP is a public PL/SQL package body in the APPS schema that forms part of the Oracle iSupport and knowledge-management search infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name follows Oracle's naming convention for "grouped" packages (suffix _GRP), which typically expose a stable, high-level entry point that hides the complexity of lower-level private APIs from callers. In this case the package acts as a facade over the shared search engine objects AMV_SEARCH_GRP and AMV_SEARCH_PVT, allowing knowledge-base modules to invoke search logic without binding directly to the internal search implementation.

The package is valid in both releases and, per published dependency data, is not referenced by any other database object; it is instead consumed directly by forms, JSP pages, and custom code in the iSupport knowledge base and related self-service applications. The user search term "cs_kb_varchar100_tbl_type" corresponds to one of the collection types declared in the CS_KB (Customer Support / knowledge base) schema that this package depends upon.

Key Procedures and Functions

The documented API classification of this package is GRP, and ETRM lists a single documented routine, SPECIFIC_SEARCH. No parameter lists are published in the metadata, so only its purpose is described here.

  • SPECIFIC_SEARCH — The primary entry point of the package. It performs a targeted knowledge-base search, delegating to the AMV search layer (AMV_SEARCH_GRP, AMV_SEARCH_PVT) to execute the query and return matching knowledge articles. It is the routine that callers invoke when they need results for a particular search specification rather than a broad or cached browse.

Supporting logic inside the package body manipulates the CS_KB collection types, including CS_KB_VARCHAR100_TBL_TYPE, CS_KB_NUMBER_TBL_TYPE (numeric identifiers), CS_KB_RESULT_OBJ_TYPE (individual result records), and CS_KB_RESULT_VARRAY_TYPE (the result set returned to the caller). The package also routes error handling through FND_API, FND_MSG_PUB, and FND_MESSAGE, so that search failures raise standard Oracle Application Object Library messages.

Tables Accessed

The only documented table referenced through APPS synonyms is PLITBLM, the PL/SQL integer table used for passing collections of numeric values. It is used as a scratch/parameter structure for the search call rather than as a persistent knowledge-base table. The substantive knowledge data resides in the CS_KB objects and AMV search views that the package reaches through its dependencies; the package itself does not write directly to a knowledge table, it reads results through the shared search API. JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_400, and JTF_VARCHAR2_TABLE_4000 are used as additional collection types for passing search criteria and receiving result attributes.

Usage Notes

IBU_KNOWLEDGE_GRP is typically invoked from the Oracle iSupport and knowledge-management user interfaces, from concurrent or batch jobs that refresh or execute knowledge searches, and from custom PL/SQL that needs programmatic access to knowledge-base results. Because the package is a GRP-style wrapper, custom code should call SPECIFIC_SEARCH with parameters populated from the CS_KB and JTF collection types rather than reproducing the underlying AMV_SEARCH_PVT calls.

In 12.1.1 and 12.2.2 the package remains valid and unchanged in its dependency set. Callers should note that the package is not referenced by any other database object, so its contract is maintained for external consumers only; any upgrade or patch that alters AMV_SEARCH_PVT or the CS_KB types can affect this package's behavior without a visible dependency chain in the data dictionary.