Search Results igf_aw_coa_grp_item




Overview
Explore in AI Chat

Overview

IGF_AW_COA_GRP_ITEM is a reporting and integration view within the Oracle E-Business Suite Financial Aid (IGF) module. In the ETRM metadata for release 12.1.1 and 12.2.2, the product is explicitly flagged as "IGF - Financial Aid (Obsolete)" and the implementation note states "Not implemented in this database," indicating the object is a legacy component retained for documentation and upgrade compatibility rather than active use in current installations.

The view presents configuration data that links a Chart of Accounts (COA) grouping to specific financial aid item codes, together with default values, fixed cost indicators, Pell grant amounts, and an item distribution flag. Its role in EBS reporting is to expose a multitenant-aware, secured projection of the underlying IGF_AW_COA_GRP_ITEM_ALL table through a row-level organization filter, allowing downstream reports and integration programs to retrieve only the records relevant to the current operating unit. The user search term "item_dist" corresponds directly to the ITEM_DIST column surfaced by this view.

Underlying Base Objects

According to the documented view text, the view is defined over a single base object:

  • IGF_AW_COA_GRP_ITEM_ALL — aliased as COAGI — which holds the full, unrestricted set of COA group item records, including the ORG_ID discriminator required for multi-organization partitioning.

No other referenced base objects are documented in the ETRM metadata. The view applies a security predicate on ORG_ID derived from USERENV('CLIENT_INFO'), converting the first ten characters of the client information string to a number and comparing it against the row's ORG_ID. When the client information is blank or unavailable, the predicate resolves to -99, effectively restricting the result set in the absence of a valid organization context. This pattern is consistent with Oracle's multi-org views (the "_ALL" table paired with a non-suffixed view), ensuring that queries against IGF_AW_COA_GRP_ITEM return only organization-scoped rows.

Key Columns

  • ROW_ID — The physical row identifier from the base table, exposed as the first selected column.
  • COA_CODE — The chart of accounts code identifying the grouping to which the item belongs.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Calendar type and sequence number defining the academic or award period context.
  • ITEM_CODE — The financial aid item identifier associated with the COA group.
  • DEFAULT_VALUE — The default monetary or numeric value applied to the item.
  • FIXED_COST — Indicator of whether the item is treated as a fixed cost.
  • ACTIVE — Flag controlling whether the configuration row is currently enabled.
  • ORG_ID — The operating unit discriminator used by the view's security predicate.
  • PELL_AMOUNT / PELL_ALTERNATE_AMT — Standard and alternate Pell grant amounts associated with the item.
  • ITEM_DIST — The item distribution indicator, mapping to the search term of interest.
  • LOCK_FLAG — A concurrency control indicator preventing conflicting updates.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS who-column auditing.

Common Use Cases and Queries

The view is typically queried to validate COA group item configuration, to reconcile Pell amounts against item definitions, or to feed integration extracts that populate downstream financial aid disbursement logic. Because the view enforces ORG_ID security automatically, no explicit organization predicate is required when the client information context is correctly initialized.

A representative query retrieving active items for a chart of accounts group is:

SELECT coa_code, item_code, default_value, pell_amount, item_dist, active FROM igf_aw_coa_grp_item WHERE active = 'Y' AND item_dist IS NOT NULL ORDER BY coa_code, item_code;

A second pattern inspects fixed-cost and lock behavior prior to maintenance:

SELECT item_code, fixed_cost, lock_flag, last_updated_by, last_update_date FROM igf_aw_coa_grp_item WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq AND org_id = :org_id;

Given the obsolete status of the IGF Financial Aid module, these queries should be treated as historical reference material and validated against the target instance before use in production reporting.