Search Results igf_aw_coa_update




Overview
Explore in AI Chat

Overview

IGF_AW_COA_UPDATE is an APPS-owned PL/SQL package within the Oracle E-Business Suite Grants and Awards Management (formerly Oracle Grants Accounting / OGA) product family. Its name reflects its role: it maintains the Chart of Accounts (COA) distribution records that link award funding sources to general ledger accounting flexfield combinations. In the standard Award Management flow, award budgets, award lines, and award items must be mapped to valid accounting combinations before encumbrances, actuals, and budgetary transactions can be posted. IGF_AW_COA_UPDATE supports that mapping process by recalculating, regenerating, and validating COA records in response to changes in award attributes, organization, or account structure.

The package is classified under the ETRM metadata as an "OTHER" API type, meaning it is intended primarily for internal product use rather than as a published external interface. Its status is VALID in the APPS schema, and it forms part of the dependency chain centered on IGF_AW_COA_CALC and IGF_AW_COA_GEN.

Key Procedures and Functions

The package exposes two documented program units:

  • MAIN — The principal driver procedure. It orchestrates the COA update cycle: reading the current award and award item data, evaluating the applicable account generation rules, and applying the resulting changes to the award's Chart of Accounts records. It is the entry point invoked by callers such as IGF_AW_COA_CALC.
  • IS_ATTRIB_MATCHING — A validation routine that determines whether the attributes of a given award or award item satisfy the matching criteria required for a particular COA generation or update action. It is used internally by MAIN to decide which records qualify for update or regeneration.

Parameter lists are not enumerated in the ETRM metadata; the procedures are identified by name and purpose only.

Tables Accessed

The package reads and writes across award, grants, institutional, and trading-partner data through APPS synonyms:

Usage Notes

IGF_AW_COA_UPDATE is invoked indirectly rather than directly by end users. The dependency metadata shows it is referenced by APPS.IGF_AW_COA_CALC (and self-referenced within the package itself), indicating that the COA calculation logic calls this package when account combinations must be refreshed. It in turn depends on IGF_AW_COA_GEN and the award base record structures.

Typical invocation paths include award maintenance forms where changes to award attributes trigger account re-derivation, concurrent processes in the Grants Accounting responsibility that recalculate award COA distributions, and customization or extension code that calls MAIN to force regeneration across a set of awards. Because the package is marked OTHER, implementers should treat it as an internal module: direct calls are possible from custom PL/SQL, but Oracle does not warrant the signature across patches. Extraction and reporting integrations are better served through the award COA interface tables or standard award APIs. When troubleshooting COA discrepancies, tracing calls from IGF_AW_COA_CALC into IGF_AW_COA_UPDATE is the standard diagnostic route.