Search Results igf_aw_fund_unit_all




Overview
Explore in AI Chat

Overview

The table IGF_AW_FUND_UNIT_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves a critical configuration and control function by defining the specific organizational unit, or "pays only unit," against which a given financial aid fund can be disbursed. This table enforces a key business rule, ensuring that disbursements from a fund are correctly aligned with the appropriate organizational hierarchy, which is essential for accurate accounting, budgeting, and compliance reporting. As a multi-org enabled table, denoted by the "_ALL" suffix and the presence of the ORG_ID column, it stores data for multiple operating units within a single installation.

Key Information Stored

The table's structure is designed to maintain the unique relationship between a fund and its designated disbursement unit. The primary columns include FUNIT_ID, which is the system-generated unique primary key. The FUND_ID is a foreign key that links directly to the master fund definition in the IGF_AW_FUND_MAST_ALL table. The UNIT_CD holds the code identifying the specific organizational unit authorized for disbursement. The ORG_ID specifies the operating unit context, and the VERSION_NUMBER is used to manage concurrent updates and maintain data integrity. The uniqueness constraint (IGF_AW_FUND_UNIT_UK) on the combination of FUND_ID, ORG_ID, and UNIT_CD prevents the assignment of duplicate disbursement units for the same fund within an operating unit.

Common Use Cases and Queries

This table is primarily accessed during the fund setup and disbursement processes. A common operational query is to validate or list all permissible disbursement units for a specific fund, which is crucial for configuring award packages. For reporting, it is frequently joined to fund master tables to produce compliance reports showing fund-to-unit mappings. Administrators may query it to audit disbursement rules or troubleshoot issues where a disbursement is failing due to an incorrect unit assignment.

  • Retrieve all disbursement units for a specific fund ID: SELECT unit_cd FROM igf_aw_fund_unit_all WHERE fund_id = &fund_id AND org_id = &org_id;
  • List fund details with their assigned disbursement unit: SELECT f.fund_code, fu.unit_cd FROM igf_aw_fund_mast_all f, igf_aw_fund_unit_all fu WHERE f.fund_id = fu.fund_id AND f.org_id = fu.org_id;

Related Objects

The table has a direct and essential relationship with the fund master table, as defined in the provided metadata. The primary documented foreign key relationship is:

  • IGF_AW_FUND_MAST_ALL: The FUND_ID column in IGF_AW_FUND_UNIT_ALL references the FUND_ID in IGF_AW_FUND_MAST_ALL. This join is fundamental, as every disbursement unit record must be associated with a valid, existing fund definition. This relationship ensures referential integrity, meaning a fund unit cannot exist without a corresponding parent fund.