Search Results proposal_installment_id

Overview

The IGW_PROJECT_FUNDINGS table is a core data object within the Oracle E-Business Suite Grants Accounting module (IGW). It serves as the central repository for recording and managing the allocation of funding amounts to specific projects and tasks from defined award installments. Its primary role is to establish the financial link between a funding source—represented by a proposal installment from the IGW_INSTALLMENTS table—and the project or task being funded. This table enables detailed tracking of how funds are distributed, supporting critical financial management, budgeting, and reporting processes for sponsored projects and grants within Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores transactional funding allocation details. Key columns include the surrogate primary key PROPOSAL_FUNDING_ID and the critical foreign key PROPOSAL_INSTALLMENT_ID, which links to the source installment in IGW_INSTALLMENTS. The PROJECT_ID and TASK_ID columns identify the specific project and optional task receiving the funds. The FUNDING_AMOUNT column holds the monetary value allocated for this specific combination, and DATE_ALLOCATED records when the allocation occurred. The table also includes standard Oracle EBS "Who" columns (CREATED_BY, LAST_UPDATED_BY, etc.) for auditing and a RECORD_VERSION_NUMBER for optimistic locking control to manage concurrent data updates.

Common Use Cases and Queries

A primary use case is generating reports to analyze funding distributions against awards and projects. Financial analysts may query this table to reconcile total awarded amounts against allocated funds. A common query pattern involves joining to IGW_INSTALLMENTS to get installment details and to project/task tables for descriptive information. For example, to find all funding allocations for a specific proposal installment (as indicated by the user's search for "proposal_installment_id"):

• SELECT pf.PROJECT_ID, pf.TASK_ID, pf.FUNDING_AMOUNT, pf.DATE_ALLOCATED, i.INSTALLMENT_NUMBER FROM IGW_PROJECT_FUNDINGS pf, IGW_INSTALLMENTS i WHERE pf.PROPOSAL_INSTALLMENT_ID = i.INSTALLMENT_ID AND pf.PROPOSAL_INSTALLMENT_ID = :p_installment_id;

Another routine operation is aggregating the total FUNDING_AMOUNT by PROJECT_ID to understand the financial commitment at the project level, which is essential for project budgeting and expenditure tracking.

Related Objects

The table's structure defines clear relationships with other key Grants Accounting entities. Its primary key is enforced by the IGW_PROJECT_FUNDINGS_PK constraint on PROPOSAL_FUNDING_ID. The most significant documented relationship is a foreign key constraint where the PROPOSAL_INSTALLMENT_ID column references the IGW_INSTALLMENTS table. This establishes that every funding record must be tied to a valid, pre-existing award installment. While the ETRM excerpt indicates no objects are referenced by IGW_PROJECT_FUNDINGS, it is itself referenced by the APPS schema synonym IGW_PROJECT_FUNDINGS, which is the standard access point for all application code and queries. In a full implementation, it would also relate to project definition tables (e.g., PA_PROJECTS_ALL) via the PROJECT_ID and TASK_ID columns, though these specific foreign keys are not detailed in the provided metadata.