Search Results amv_search_grp




Overview
Explore in AI Chat

Overview

AMV_SEARCH_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite and classified as a Group (GRP) type API. It forms part of the Oracle Knowledge Management and Information Discovery infrastructure, providing the top-level entry points through which forms, concurrent requests, and dependent packages initiate content searches against repositories and their constituent areas. The package itself acts as a thin coordination layer: the documented dependency metadata shows that it delegates substantive processing to AMV_SEARCH_PVT, the private implementation package, while relying on FND_API for the standard EBS API programming constructs such as the global API return status, message handling, and exception framework.

In practical terms, AMV_SEARCH_GRP exposes the search facade used by Oracle iSupport, Oracle iStore knowledge features, and the broader Interaction Center knowledge toolset. Its status of VALID in the 12.2.2 ETRM repository confirms the object is present and compiled successfully in a supported EBS environment.

Key Procedures and Functions

  • FIND_REPOSITORIES — Identifies and returns the set of repositories that are visible to the calling user and eligible for searching. This procedure drives repository-level selection lists in the knowledge search user interface.
  • FIND_REPOSITORY_AREAS — Retrieves the areas, categories, or zones that belong to a given repository. This supports hierarchical narrowing of a search scope from repository down to a more specific content area.
  • CONTENT_SEARCH — Executes the actual content search across the selected repositories or areas and returns the matching results to the caller. It is the primary functional entry point for retrieving knowledge documents and related content.

The ETRM metadata documents three procedures in total and does not publish parameter signatures. Callers should therefore obtain signatures from the package specification in the database rather than assuming argument order or datatypes.

Tables Accessed

The documented metadata does not list direct table references through APPS synonyms. All data access is routed through AMV_SEARCH_PVT, which encapsulates the base repository and knowledge tables. No direct DML against application tables should be assumed at the AMV_SEARCH_GRP level; the package is read-oriented and returns result sets for display rather than persisting transaction data.

Usage Notes

AMV_SEARCH_GRP is referenced by three other packages, namely AMV_SEARCH_GRP_W, CS_KNOWLEDGE_GRP, and IBU_KNOWLEDGE_GRP. The _W variant typically indicates a wrapper or web-facing variant, while CS_KNOWLEDGE_GRP and IBU_KNOWLEDGE_GRP belong to the Service and iStore/IBU knowledge generations respectively, demonstrating that AMV_SEARCH_GRP is a shared, cross-application search utility.

Because of this layered design, customizations should call AMV_SEARCH_GRP rather than AMV_SEARCH_PVT, preserving the supported interface boundary. Typical invocation is from knowledge search forms and from concurrent or custom programs that need to enumerate repositories or run a content search. Developers extending the search UI should treat FIND_REPOSITORIES, FIND_REPOSITORY_AREAS, and CONTENT_SEARCH as the supported public surface and validate all calls against the package specification shipped with the specific EBS patch level, since parameter lists are not part of the documented metadata.