Search Results igw_installments_n1

Overview

The IGW.IGW_INSTALLMENTS table is a core data object within the Oracle Grants Proposal (IGW) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the transactional repository for installment data associated with funded proposals. Its primary role is to store detailed financial and temporal information for individual installments that can be subsequently transferred to the Grants Accounting module. This structure allows a single funded proposal to be managed as multiple awards and, within those awards, multiple installments, providing granular control over funding schedules, cost distributions, and billing cycles throughout the award's lifecycle.

Key Information Stored

The table captures a comprehensive set of attributes for each proposal installment. The primary key is PROPOSAL_INSTALLMENT_ID. A critical foreign key relationship is established via the PROPOSAL_AWARD_ID column, which links the installment to its parent award record. Essential financial data includes DIRECT_COST and INDIRECT_COST amounts. Temporal control is managed through ISSUE_DATE, CLOSE_DATE, START_DATE, and END_DATE columns. The INSTALLMENT_TYPE_CODE categorizes the installment as an 'Award', 'Amendment', or 'Supplement'. Operational flags like BILLABLE_FLAG ('Y'/'N') determine if the installment amount is available for billing processes. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and a RECORD_VERSION_NUMBER for optimistic locking are also maintained.

Common Use Cases and Queries

Common operational scenarios include generating reports on funding schedules, validating costs before transfer to Grants Accounting, and identifying billable installments. Technical consultants often query this table to troubleshoot data issues or build custom integrations. A fundamental query to retrieve all installments for a specific proposal award, a direct application of the user's search term, would be:

• SELECT INSTALLMENT_NUMBER, START_DATE, END_DATE, DIRECT_COST, INDIRECT_COST, BILLABLE_FLAG FROM IGW.IGW_INSTALLMENTS WHERE PROPOSAL_AWARD_ID = :p_award_id ORDER BY INSTALLMENT_NUMBER;

Another frequent pattern is to aggregate costs by award or identify active installments within a date range for financial forecasting and reconciliation purposes between the proposal and accounting systems.

Related Objects

IGW_INSTALLMENTS has defined relationships with other key tables in the Grants Proposal schema. The most direct relationship is via the PROPOSAL_AWARD_ID column, which is indexed (IGW_INSTALLMENTS_N1) and is a foreign key to a parent awards table, typically IGW.IGW_PROPOSAL_AWARDS. The table's unique index (IGW_INSTALLMENTS_U1) is on PROPOSAL_INSTALLMENT_ID. The INSTALLMENT_ID column suggests a linkage to a corresponding award installment identifier in the Grants Accounting module (e.g., in the GMS schema) after a successful transfer. The table is central to the process of creating and managing installments before they are exported to the financials stack.