Search Results igf_aw_coa_calc




Overview
Explore in AI Chat

Overview

IGF_AW_COA_CALC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Grants Accounting subsystem within Oracle Grants Management (IGF). It is classified as an "OTHER" API object rather than a public concurrent-program interface. The package computes and derives the Chart of Accounts (COA) distribution logic associated with award-related transactions, working from award base records, fund category and fund master definitions, and personnel identifier group membership.

Its principal role is to determine how an award or award line should be mapped onto valid accounting flexfield combinations, particularly where personnel-based or group-based rules influence the resulting COA segments. This is significant in a grants context because awards frequently require account generation driven by sponsor, fund category, and personnel group rather than by a static account default. The package therefore bridges the Award Management data model (IGF_AW_*) with the Person/Group model (IGS_PE_*). The current ETRM status is VALID, and the package body exposes a single documented entry point, RUN.

Key Procedures and Functions

  • RUN — The sole documented procedure in the package. It serves as the driving entry point that executes the COA calculation logic for the award records under processing. Its exact parameter list is not documented in the ETRM extract, so only its purpose — orchestrating the account derivation and its supporting reads and writes — can be stated. RUN performs the work of reading base award records, resolving applicable fund category and fund master data, evaluating personnel identifier group membership, and applying the calculation against the COA items and item terms that govern the award.

No additional procedures or functions are recorded in the documented metadata; any further logic exists inside the package body and is invoked internally by RUN.

Tables Accessed

  • IGF_AP_FA_BASE_REC_ALL — Award base records supplying the award-level data that the COA calculation is derived from.
  • IGF_AW_AWARD_ALL — Award headers providing authoritative award attributes used during account derivation.
  • IGF_AW_COA_ITEMS — The configured COA items associated with awards that the calculation expands.
  • IGF_AW_COA_ITM_TERMS — Item term definitions that constrain or condition how COA items are applied.
  • IGF_AW_FUND_CAT_ALL and IGF_AW_FUND_MAST_ALL — Fund category and fund master reference data used to resolve accounting treatment.
  • IGF_AW_PROCESS_S — The processing control/setup record governing the run.
  • IGS_PE_PRSID_GRP_MEM_ALL and the dependent IGS_PE_PERSID_GROUP_ALL — Person identifier group and group membership data used where award COA derivation depends on personnel group assignment.
  • FND_NEW_MESSAGES — Used to raise validation or diagnostic messages during processing.
  • DUAL — Standard single-row select for PL/SQL expression evaluation.

Usage Notes

IGF_AW_COA_CALC is an internal grants accounting utility. It is typically invoked from other award processing logic rather than directly by end users, and the metadata records no other packages depending on it, indicating it sits at a leaf of the dependency tree. The package references IGF_AP_FA_BASE_REC_ALL and the IGS_PE_* views, while its own dependency listing shows it in turn depends on IGF_AW_COA_GRP_ITEM.

Customizations that call RUN should treat it as an unreleased interface: parameter signatures are not published, so direct invocation is discouraged. Validation errors surface through FND_NEW_MESSAGES, meaning callers should check the message stack after execution. Because the package depends on setup data in the fund, COA item, and personnel group tables, any diagnostic investigation should confirm those reference tables are populated and consistent before assuming a code defect. In both 12.1.1 and 12.2.2 the object remains APPS-owned and VALID; there is no functional difference between releases in the documented metadata.