Results for “sys_il0000099427c00082”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGW.IGW_PROPOSALS_ALL is the core transactional table in the Oracle E-Business Suite Grants Management (Oracle Grants / OGM) module. It stores the master record for every proposal submitted to a sponsor, capturing identification, classification, financial, organizational, and lifecycle information. The table is registered as FND Design Data IGW.IGW_PROPOSALS_ALL with status VALID in releases 12.1.1 and 12.2.2, and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. The documented schema exposes 83 columns, a primary key constraint IGW_PROPOSALS_PK on PROPOSAL_ID, two unique indexes, two non-unique indexes, and one LOB index covering an XML LOB column.

From a dimensional modeling perspective, the foreign key structure suggests IGW_PROPOSALS_ALL functions as a hub. It carries a single-column surrogate primary key (PROPOSAL_ID) that is referenced by a broad set of downstream child tables, while its own outbound foreign keys point to HR_ALL_ORGANIZATION_UNITS, making it a natural anchor for proposal-centric subject areas.

Key Information Stored

The most consequential columns are summarized below. PROPOSAL_ID is the mandatory surrogate primary key, enforced by unique index IGW_PROPOSALS_ALL_U1. PROPOSAL_NUMBER is the second business-key candidate, enforced by unique index IGW_PROPOSALS_ALL_U2, and may be user-entered or system-generated according to implementation options.

• PROPOSAL_NUMBER — human-readable business identifier of the proposal.
• PROPOSAL_TITLE — detailed descriptive title (up to 250 characters).
• PROPOSAL_STATUS — lifecycle state: P (In Progress), I (Approval In-Progress), A (Approved), R (Rejected).
• PROPOSAL_START_DATE / PROPOSAL_END_DATE — the proposal period.
• PROPOSAL_TYPE_CODE — classification drawn from the IGW_PROPOSAL_TYPES lookup.
• LEAD_ORGANIZATION_ID — applicant unit, foreign key to HR_ALL_ORGANIZATION_UNITS.
• SUBMITTING_ORGANIZATION_ID — submitting unit, also a foreign key to HR_ALL_ORGANIZATION_UNITS.
• ORG_ID — operating unit identifier for multi-organization deployments.
• SPONSOR_ID and FUNDING_SPONSOR_UNIT — the funding source.
• AWARD_NUMBER / AWARD_AMOUNT — sponsor-assigned award identifier and awarded value.
• ORIGINAL_PROPOSAL_ID / PARENT_PROPOSAL_ID — lineage for continuations, renewals, and revisions.
• TOTAL_AMOUNT / FUNDED_DIRECT_COST / FUNDED_INDIRECT_COST — proposal cost figures.
• PROPOSAL_MANAGER_ID / PROGRAM_MANAGER_ID — responsible personnel.
• DEADLINE_DATE and GRANTOR_APPROVAL_STATUS — submission timing and grantor disposition.
• XML_CLOB — externally exchanged proposal payload, indexed by SYS_IL0000099427C00082$$.

Common Use Cases and Queries

Typical queries drive the proposal workbench, status dashboards, and award conversion. A common pattern filters active proposals by operating unit and status:

• SELECT proposal_number, proposal_title, proposal_status FROM igw.igw_proposals_all WHERE org_id = :p_org AND proposal_status IN ('P','I') ORDER BY proposal_start_date;
• Joining to HR_ALL_ORGANIZATION_UNITS on LEAD_ORGANIZATION_ID or SUBMITTING_ORGANIZATION_ID to report by applicant unit.
• Traversing ORIGINAL_PROPOSAL_ID and PARENT_PROPOSAL_ID to build continuation and renewal lineage reports.
• Aggregating AWARD_AMOUNT and TOTAL_AMOUNT by sponsor or proposal type for funding analytics.
• Driving approval engine processing via IGW_PROP_APPROVAL_RUNS joined on PROPOSAL_ID.

Related Objects

A large family of IGW tables references IGW_PROPOSALS_ALL via PROPOSAL_ID, confirming its hub role. The following are the most significant join points:

• IGW_AWARDS.PROPOSAL_ID — links a funded proposal to its award record.
• IGW_BUDGETS.PROPOSAL_ID — budget lines associated with the proposal.
• IGW_PROP_PERSONS.PROPOSAL_ID — personnel and investigator assignments.
• IGW_PROP_APPROVAL_RUNS.PROPOSAL_ID — approval workflow executions.
• IGW_PROP_NARRATIVES.PROPOSAL_ID — narrative attachments and sections.
• IGW_PROP_COMMENTS.PROPOSAL_ID — reviewer and administrative comments.
• IGW_PROP_CHECKLIST.PROPOSAL_ID — submission checklist state.
• HR_ALL_ORGANIZATION_UNITS — referenced on LEAD_ORGANIZATION_ID and SUBMITTING_ORGANIZATION_ID.