Search Results igi_igilutil2_exp




Overview
Explore in AI Chat

Overview

IGI_GEN_VERT is a general-purpose utility package body owned by APPS within the Oracle E-Business Suite. Its central business function is to determine whether specific Oracle EBS products and features have been installed and enabled for a given operating unit, and to expose that installation state to the rest of the IGI (Financials/Public Sector) product family. The package is heavily oriented toward option and installation verification: it reads installation flags from the IGI GCC installed-options tables and the PSA Enterprise Financials Configuration options table, then answers simple yes/no questions about product availability.

The package is significant in multi-organization access control (MOAC) environments. The header commentary reflects the MOAC changes introduced by the original developer, and the source confirms that the same logical checks are offered both with and without an explicit organization identifier. This dual interface allows callers to work either in a single operating unit context or across all accessible organizations.

Key Procedures and Functions

The documented API surface comprises thirteen program units. The following describes their purposes based on the ETRM metadata:

  • IS_REQ_INSTALLED — Core installation predicate. The source excerpt shows two overloads: one accepting an option name and an organization ID, and one accepting only the option name. Each checks whether the named option is installed and returns a flag (or boolean) indicating availability. When the option is not found in the organization-scoped table, the routine falls back to the GL/FA installed-options table, a behavior introduced to resolve a specific defect.
  • GET_OPTION_STATUS — Returns the stored status flag for a requested product option.
  • DEBUG — Diagnostic routine used to emit debug output during troubleshooting and development.
  • GET_LOOKUP_MEANING — Resolves an Oracle Applications lookup code to its display meaning, providing consistent user-facing descriptions.
  • IGI_EFC_CHECK_OPTIONS — Evaluates Enterprise Financials Configuration (EFC) option settings relevant to IGI processing.
  • GET_AP_SOB_ID — Retrieves the set of books identifier associated with Payables system parameters.
  • GET_AR_SOB_ID — Retrieves the set of books identifier associated with Receivables system parameters.
  • GET_PO_SOB_ID — Retrieves the set of books identifier associated with Purchasing system parameters.
  • IGIINSTALLED — Determines whether the IGI product itself is installed, acting as a general gating check.
  • CACHEPRODUCTOPTIONS — Caches product option settings in session state to reduce repeated queries.
  • PRODUCTENABLED — Tests whether a specific product is enabled.
  • PRODUCTS_ENABLED — Plural form; evaluates enablement across a set of products.

Tables Accessed

The package reads installation and configuration state from several core EBS tables through APPS synonyms. IGI_GCC_INSTALLED_OPTIONS and IGI_GCC_GL_FA_INST_OPTS hold the per-organization and GL/FA installation status flags used by IS_REQ_INSTALLED. AP_SYSTEM_PARAMETERS, AR_SYSTEM_PARAMETERS, and FINANCIALS_SYSTEM_PARAMETERS supply the Payables, Receivables, and Financials set of books identifiers retrieved by the GET_AP_SOB_ID, GET_AR_SOB_ID, and GET_PO_SOB_ID routines. PSA_EFC_OPTIONS supports the IGI_EFC_CHECK_OPTIONS and related option-status logic. All access is read-only; the package writes no application data.

Usage Notes

IGI_GEN_VERT functions as a shared utility rather than a business transaction API; ETRM records no other packages referencing it. It is typically invoked from IGI forms and concurrent programs, and from custom code that must conditionally enable functionality based on product installation state. Callers should note the MOAC-aware overloads and the fallback to the GL/FA installed-options table, and should account for the fact that the organization-scoped overload returns 'N' whenever an unexpected error occurs.