Search Results igi_exp_utils




Overview
Explore in AI Chat

Overview

The APPS.IGI_EXP_UTILS package body is a shared utility library within the Oracle E-Business Suite ETRM (Expense Report / Expense Processing, delivered by the IGI/Public Sector or ETRM product family) schema. Its primary business function is to encapsulate reusable processing logic supporting expense transaction handling across both Payables and Receivables flows. The package provides low-level services — document numbering, fiscal period resolution, validation of General Ledger dates, and completion of expense documentation units — that are consumed by other ETRM packages rather than by end-user screens directly. Because IGI_EXP_UTILS is itself documented as not referenced by any database object but as referenced by other packages, it behaves as an internal helper module. It is classified under the API classification OTHER, indicating it is not a formally published public API but an internal utility package that other ETRM components call. The package is dependent on standard Oracle subledger and setup tables, confirming its role as a bridge between ETRM-specific expense objects and the core Financials data model.

Key Procedures and Functions

ETRM 12.2.2 documents four callable units within the package body:

  • GENERATE_NUMBER — Produces document numbers for ETRM expense transactions, drawing on the numbering scheme definitions held in the IGI_EXP_NUM_SCHEMES and IGI_EXP_NUM_SCHEMES_ALL tables. This centralises number generation so that the same scheme logic applies consistently across transaction types.
  • GET_FISCAL_YEAR — Determines the fiscal year associated with a given accounting period by resolving periods and period statuses through GL_PERIODS, GL_PERIOD_STATUSES, and GL_SETS_OF_BOOKS. This supports date-to-period mapping required for accounting and reporting purposes.
  • VALIDATEGLDATE — Validates whether a supplied General Ledger date is valid, typically by checking it against open or defined accounting periods. This guards downstream accounting activity against entries in closed or undefined periods.
  • COMPLETE_DU — Completes an expense documentation unit (DU), updating records in IGI_EXP_DUS and IGI_EXP_DUS_ALL and coordinating with trans and hold tables to finalise processing status.

Tables Accessed

The package reads and writes a documented set of tables through APPS synonyms. Payables integration is served by AP_INVOICES and AP_INVOICES_ALL (invoice headers) and AP_INVOICE_DISTRIBUTIONS (invoice lines/distributions). Receivables integration is served by IGI_EXP_AR_TRANS and IGI_EXP_AR_TRANS_ALL. Core ETRM expense tables include IGI_EXP_DUS and IGI_EXP_DUS_ALL (documentation units), IGI_EXP_DU_TYPE_HEADERS (DU type definitions), IGI_EXP_AP_TRANS, and IGI_EXP_NUM_SCHEMES / IGI_EXP_NUM_SCHEMES_ALL (numbering schemes). Setup and reference lookups include FINANCIALS_SYSTEM_PARAMETERS, FND_PRODUCT_INSTALLATIONS, GL_PERIODS, GL_PERIOD_STATUSES, GL_SETS_OF_BOOKS, HR_OPERATING_UNITS, and AR_LOOKUPS. These accesses confirm the package's role as the junction between ETRM expense objects and Oracle Financials period, ledger, and organisation setup.

Usage Notes

IGI_EXP_UTILS is normally invoked indirectly. ETRM forms and concurrent programs that process expense transactions call the utility procedures during data entry validation, document numbering, and completion of documentation units. Because the package touches both AP and AR tables plus GL period data, it is typically triggered within the transactional lifecycle of an expense DU, after a DU has been created and before its accounting is finalised. Custom code extending ETRM functionality may call GENERATE_NUMBER or VALIDATEGLDATE directly to reuse the standard numbering and date-checking logic, but such calls should pass values consistent with the active ledger and operating unit. As an internal helper, its interfaces may change across releases, so direct dependency from customisations is discouraged in favour of the documented public APIs of the ETRM product.