Search Results log_line

Overview

APPS.EAM_TEXT_INDEX_PVT is a private PL/SQL package body in Oracle E-Business Suite Enterprise Asset Management (EAM). It encapsulates the internal logic for building and maintaining Oracle Text (CTXSYS) indexes that support keyword and full-text searching against EAM maintenance work order, asset, and related descriptive text. Because the package is classified as PVT (private), it is not exposed as a public API; it exists to be called from within the EAM module's own code and concurrent processing framework. The header block declares the standard EBS API contract (p_api_version, p_init_msg_list, p_commit, p_validation_level, x_return_status, x_msg_count, x_msg_data), but the actual implementation is oriented toward index administration rather than transactional DML.

The package maintains several private globals that reveal its operational scope: a hard-coded context schema (CTXSYS), dynamically determined product, index owner, and preference owner schemas, plus installation status and industry flags. A dedicated logging subsystem is defined through g_Log_Mode, g_Conc_Req_flag, g_Log_Sqlplus_Flag, g_Log_File_Flag, and g_Log_Dbdrv_Flag, together with log file names (eam_text_index.log, eam_text_index.out) and log/dump directory parameters sourced from V$PARAMETER. This logging infrastructure explains why a search for log_line resolves to this object.

Key Procedures and Functions

• BUILD_TEXT_INDEX — Constructs or rebuilds the Oracle Text index used by EAM full-text search. This is the primary entry point for populating the CTXSYS-managed index structures.
• OPTIMIZE_INDEX — Optimizes the existing text index, consolidating index fragments and improving query performance without a full rebuild.
• SET_LOG_MODE — Establishes the logging behavior for the package, controlling which of the SQL*Plus, file, and DBDRV logging channels are active.
• LOG_LINE — Writes an individual log entry using the logging flags and file handles configured by SET_LOG_MODE. This is the procedure most directly associated with the log_line search term.

The documentation notes that these are the five documented routines total; parameter signatures are intentionally not reproduced here, as the metadata does not enumerate them.

Tables Accessed

The package operates against Oracle Text data dictionary and control views through APPS synonyms. AD_CTX_DDL and CTX_OUTPUT are Oracle Text DDL and output-buffer interfaces used during index creation and logging. CTX_PARAMETERS supplies context index configuration values. ALL_INDEXES and ALL_TABLES are queried to locate and validate the target index and its base table. V$PARAMETER is read to derive log and dump directory paths. These accesses confirm the package's role as an administrative utility layered over Oracle Text.

Usage Notes

EAM_TEXT_INDEX_PVT is invoked from EAM concurrent programs and internal EAM package logic, typically during setups, patching, or scheduled index maintenance rather than from end-user forms directly. In 12.1.1 and 12.2.2, database administrators or EAM implementers may encounter it when diagnosing full-text search failures or reviewing log output from index build and optimize jobs. Because referenced-by count is zero, no other documented package depends on it as a published API; customizations should not call it directly and should instead rely on supported EAM interfaces.