Search Results ibe_search_pvt




Overview
Explore in AI Chat

Overview

IBE_SEARCH_PVT is the private PL/SQL package body within the Oracle iStore (IBE) schema that governs the maintenance of the search index used by the iStore storefront search engine. Its principal business function is to keep the searchable catalog synchronized with the underlying item master and category assignment data. When merchandise records change — items are created, updated, or deleted, translations are modified, or category assignments are inserted, updated, or removed — this package responds by flagging or refreshing the corresponding rows in the iStore search staging structures. Without this synchronization, storefront keyword and category searches would return stale, missing, or invalid results, degrading the customer buying experience and potentially exposing discontinued products.

The package is classified as PVT (private) in the ETRM metadata, indicating it is an internal implementation package not intended as a public integration API. It carries a VALID status in the APPS schema and is documented with eight procedures in the ETRM 12.2.2 repository. It is referenced by one other package, and depends in turn on IBE_SEARCH_SETUP_PVT, confirming its role as a subordinate component of the broader iStore search subsystem.

Key Procedures and Functions

The documented entry points are event-oriented procedures, each aligned to a DML operation on the item or category tables. They are commonly invoked from database triggers or from other iStore search packages in response to catalog changes.

  • ITEM_CATEGORY_INSERTED — Handles the addition of a category assignment to an item, ensuring the new categorization is reflected in the search index structures.
  • ITEM_CATEGORY_DELETED — Processes the removal of an item-to-category relationship, removing or invalidating the corresponding search entries.
  • ITEM_CATEGORY_UPDATED — Responds to changes in existing category assignments, reconciling the search index with the modified relationship.
  • ITEM_DELETED — Removes search index references for an item that has been deleted from the item master.
  • ITEM_UPDATED — Propagates changes to base item attributes (for example, description or status) into the search staging data.
  • ITEMTL_DELETED — Handles deletion of translated item descriptions, maintaining correctness across multiple languages.
  • ITEMTL_UPDATED — Reflects modifications to item translations in the searchable content.
  • ITEMTL_INSERTED — Captures newly inserted item translations so that multilingual search returns accurate results.

Parameter lists are not documented in the available metadata and are therefore not reproduced here. Functionally, each procedure performs an incremental maintenance action against the iStore search tables rather than a full index rebuild.

Tables Accessed

The package reads and writes the following documented objects (referenced through APPS synonyms):

The package also depends on FND_GLOBAL and FND_PROFILE for session and profile option context, and on IBE_SEARCH_SETUP_PVT for shared search configuration logic.

Usage Notes

IBE_SEARCH_PVT is an internal package; Oracle does not publish it as a supported integration API, and custom code should not call it directly. In standard EBS 12.1.1 and 12.2.2 environments it is invoked indirectly — typically from DML triggers on the item master and item category tables, or from higher-level iStore search administration and indexing routines that call the procedures as catalog events occur. The package is also referenced by one other package, which is expected in the normal iStore dependency chain.

Because it is private and event-driven, administrators should avoid disabling or modifying it. Where search indexes become inconsistent, the supported remedy is to run the standard iStore search index rebuild or related concurrent programs, which invoke this package's logic in a controlled sequence, rather than executing its procedures manually.