Search Results igi_gen




Overview
Explore in AI Chat

Overview

IGI_GEN is a shared utility package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER-type API. Its principal business role is to serve as a general-purpose infrastructure layer for the Oracle Financials for EMEA / Global Accounting Engine (IGI) product family, and more broadly for functionality that depends on the IGI Global Consolidation Center (GCC) installed options. The package centralises frequently repeated logic: verifying whether a given IGI requirement or option is installed, resolving the current status of an installed option, retrieving lookup meanings, resolving the Set of Books identifier associated with a specific subledger, and returning standardised prompt and window title strings for the user interface.

Because IGI_GEN is not referenced by any database object yet itself references the IGI Global Consolidation Center views and the Financials, Payables and Receivables system parameter tables, it functions as a leaf-level foundation library. The ETRM notes that it is referenced by 62 other packages, confirming its role as a widely reused dependency inside the IGI and related application code.

Key Procedures and Functions

The documented public interface exposes eleven procedures and functions:

  • IS_REQ_INSTALLED — determines whether a specific IGI requirement or functional component is installed in the current environment.
  • GET_OPTION_STATUS — returns the current status of a given IGI option, allowing callers to branch on installed versus uninstalled behaviour.
  • DEBUG — emits diagnostic information, typically gated by a debug flag, to assist during testing and troubleshooting.
  • GET_LOOKUP_MEANING — resolves a lookup code into its descriptive meaning using Oracle lookup infrastructure.
  • IGI_EFC_CHECK_OPTIONS — validates the EFC (Enterprise Financial Consolidation) option configuration against the installed IGI options.
  • GET_AP_SOB_ID — returns the Set of Books identifier associated with Payables system parameters.
  • GET_AR_SOB_ID — returns the Set of Books identifier associated with Receivables system parameters.
  • GET_PO_SOB_ID — returns the Set of Books identifier associated with Purchasing system parameters.
  • GET_IGI_PROMPT — supplies standardised prompt text for IGI screens and messages.
  • GET_IGI_WINDOW_TITLE — supplies standardised window title text for IGI forms.

Tables Accessed

The package reads the following APPS-synonym tables:

Additional dependencies include IGI_GCC_GL_FA_INST_OPS, IGI_GCC_INSTALLED_OPTIONS and IGI_LOOKUPS, plus the standard FND_MESSAGE, APP_EXCEPTION, DBMS_STANDARD and STANDARD libraries for messaging and error handling.

Usage Notes

IGI_GEN is invoked indirectly rather than through a standalone concurrent program or form. Any of the 62 packages that reference it may call its procedures during setup validation, option checking, or UI rendering. Typical call sites include IGI setup forms that need to display correct window titles and prompts, and consolidation or financial consolidation routines that must confirm the installed option configuration before proceeding.

Because the package resolves Set of Books identifiers through the AP, AR and Financials system parameter tables, it should only be relied upon in environments where those subledger parameters are correctly configured. Customisations that call IGI_GEN should treat its functions as read-only queries and handle the standard exception behaviour raised through APP_EXCEPTION and FND_MESSAGE.