Search Results ctx_section_group




Overview
Explore in AI Chat

Overview

ICX_POR_INTERMEDIA_INDEX is an Oracle E-Business Suite PL/SQL package that manages the Oracle Text (formerly interMedia) full-text indexes used by the iProcurement catalog search infrastructure. Its primary business function is to create, drop, and rebuild the CONTEXT indexes on the catalog text columns that allow shoppers to perform keyword and linguistic searches against supplier catalog content. The header comment within the package body ($Header: ICXCGITB.pls 120.0.12020000.2 2013/02/08) and the procedure description explicitly state that the index is created "with multi-lex for each installed language in FND_LANGUAGES, including the base language," confirming the package's role in multilingual catalog search.

The package is owned by APPS and classified as OTHER in the ETRM repository. It is referenced by two other packages and is intended for administrative rather than interactive use.

Key Procedures and Functions

  • CREATE_INDEX — Creates the interMedia/Oracle Text index over the iProcurement catalog content. The procedure iterates the installed languages cursor (installed_languages_csr, which selects from FND_LANGUAGES where installed_flag is B or I) and builds a multi-lexer index so that each installed language is indexed with its appropriate lexer. It relies on several initialization values, including the preference datastore ICX_CAT_DATASTORE and the section group ICX_CAT_SECTGRP — the latter being the ctx_section_group variable referenced in the source. The procedure resolves the APPS schema dynamically from FND_ORACLE_USERID (where read_only_flag = 'U') and the iProcurement schema via ICX_POR_EXT_UTL.getIcxSchema, rather than hardcoding schema names.
  • DROP_INDEX — Removes the existing interMedia index, typically executed before a rebuild or during catalog maintenance or patching operations.
  • REBUILD_INDEX — Recreates the index, ordinarily after drop, to refresh the text index against current catalog data or following configuration changes.

No parameter lists are documented for these procedures, and none should be assumed.

Tables Accessed

  • FND_LANGUAGES — Read to enumerate installed languages (installed_flag IN ('B','I')), driving the multi-lexer index construction so that each installed language receives appropriate linguistic treatment.
  • FND_ORACLE_USERID — Read to derive the APPS (or base) schema name dynamically, avoiding hardcoded schema references.
  • CTX_DDL and AD_CTX_DDL — Oracle Text DDL APIs used to define preferences and perform index creation, section group assignment, and related DDL operations. The AD_CTX_DDL reference reflects the use of the Application DBA (AD) API layer, introduced via Bug 3175547, to obtain tablespace information consistently.

Usage Notes

ICX_POR_INTERMEDIA_INDEX is an administrative utility rather than an end-user API. It is typically invoked during iProcurement setup, catalog index maintenance, and patching or upgrade cycles, either directly from SQL*Plus as the APPS user or indirectly through concurrent programs or setup scripts that manage catalog search indexes. Because it depends on ICX_POR_EXT_UTL.getIcxSchema and on installed-language metadata, it must be run in an environment where iProcurement is fully installed and FND_LANGUAGES is populated. The ctx_section_group value ICX_CAT_SECTGRP is central to how catalog content is sectioned for search, and any customization of search behavior should preserve this preference group. The package is referenced by two other packages, indicating it is called programmatically as part of larger catalog maintenance flows.