Search Results ibe_searchupdate_pvt




Overview
Explore in AI Chat

Overview

IBE_SEARCHUPDATE_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle iStore (IBE) module, specifically the infrastructure that maintains searchable content for the iStore merchant and customer-facing storefront. The package name, together with its documented procedure, indicates that its core responsibility is to refresh and populate the tables that index store section items so that end users can execute search queries against the online catalog.

The API classification recorded in ETRM is "PVT," denoting a private package. Private packages are internal implementation units and are not intended to be called directly from customer extension code. The package body is documented as VALID in the APPS schema, and the ETRM metadata lists a single public procedure. The dependency listing shows the package references only SYS.STANDARD and that no other APPS packages reference it, confirming that it is a low-level helper rather than a broadly shared utility.

Key Procedures and Functions

ETRM documents one procedure for this package:

  • LOADMSITESSECTIONITEMSTABLE — This procedure loads the table that stores the association between merchant site sections and the catalog items contained within them. It is the mechanism by which iStore section content is materialized into the structures used for section-level search. The name follows the iStore convention of "MSite" (merchant site) plus "Section Items" plus "Table," indicating the procedure is responsible for staging or refreshing the IBE_DSP_MSITE_SCT_ITEMS data set.

No parameter lists are exposed in the available documentation, so the exact signature cannot be reproduced here. The procedure is invoked internally by the iStore search maintenance flow rather than by external callers.

Tables Accessed

The documented table references, resolved through APPS synonyms, describe an indexing and search pipeline:

Usage Notes

Because IBE_SEARCHUPDATE_PVT is a private package, it is not exposed as a supported public API and should not be called directly from custom code. In release 12.1.1 and 12.2.2, it is invoked internally by the iStore search-update flow, typically as part of the process that regenerates section-based search content when catalog structure or item assignments change. Administrators generally trigger this behavior indirectly through iStore administration functions or the relevant concurrent program responsible for refreshing search indexes. Any debugging or tracing should be performed at the calling level rather than by executing this package directly, and the package should be treated as subject to change in future patches.