Results for “gms_project_fundings_u1”

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

Overview

GMS.GMS_PROJECT_FUNDINGS is a transactional table in the Oracle Grants Accounting (GMS) schema. It stores installment-funded projects together with the funding amounts allocated to them, acting as the bridge between an awarded or budgeted project structure in Oracle Projects and the individual payment installments tracked through Oracle iGrants Financials. In the Oracle EBS 12.1.1 and 12.2.2 releases, this table supports the Grants Accounting funding workflow, where sponsored project funding is recognized not as a single lump sum but as a series of scheduled or actual installments.

The table is classified as VALID within the ETRM repository and resides in the APPS_TS_TX_DATA tablespace with PCT Free of 10. From a Data Vault modeling perspective, the heuristic classification for this object is standalone, since the mined foreign key structure does not present it as a dependent satellite of a single parent hub. A practitioner may reasonably model GMS_PROJECT_FUNDINGS as a link table resolving associations among project funding, project/task, and installment entities, or, given its FUNDING_AMOUNT and DATE_ALLOCATED attributes, as a link with descriptive satellite characteristics.

Key Information Stored

The table contains twelve documented columns. The most significant are listed below, distinguishing the surrogate key from business-key candidates and descriptive attributes:

• GMS_PROJECT_FUNDING_ID — Surrogate primary key for the Grants Accounting funding record. This column is the single column of unique index GMS_PROJECT_FUNDINGS_U1, making it the definitive business-key candidate for uniquely identifying a row.
• PROJECT_FUNDING_ID — Identifier linking the record to Oracle Projects funding (foreign key to PA_PROJECT_FUNDINGS). This is the cross-product integration point between Grants and Projects.
• PROJECT_ID — Identifier of the funded project.
• TASK_ID — Identifier of the funded task within the project, allowing funding to be tracked at task granularity.
• INSTALLMENT_ID — Identifier of the installment (foreign key to IGS_FI_PP_INSTLMNTS) against which funding is recognized.
• FUNDING_AMOUNT — The monetary amount of funding associated with the project, task, and installment combination.
• DATE_ALLOCATED — The date on which the funding amount was allocated.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns capturing audit and concurrency information for each row.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include verifying that total funding allocated to a project matches the sum of installment amounts, tracing Grants funding back to Oracle Projects funding records, and producing award-level funding summaries. A non-unique index, GMS_PROJECT_FUNDINGS_N1, on INSTALLMENT_ID supports installment-centric lookups.

To retrieve all funding rows for a project:

• SELECT gms_project_funding_id, project_funding_id, project_id, task_id, installment_id, funding_amount, date_allocated FROM gms.gms_project_fundings WHERE project_id = :project_id ORDER BY date_allocated;

To summarize funding by installment:

• SELECT installment_id, SUM(funding_amount) total_funded FROM gms.gms_project_fundings GROUP BY installment_id;

Because the table is standalone with no self-referencing relationships, joins to PA_PROJECT_FUNDINGS and IGS_FI_PP_INSTLMNTS are performed explicitly on PROJECT_FUNDING_ID and INSTALLMENT_ID respectively.

Related Objects

• PA_PROJECT_FUNDINGS — Parent of PROJECT_FUNDING_ID; provides the Oracle Projects funding context.
• IGS_FI_PP_INSTLMNTS — Parent of INSTALLMENT_ID; supplies installment schedule details.
• PA_PROJECTS_ALL — Referenced via PROJECT_ID for project names, numbers, and status.
• PA_TASKS — Referenced via TASK_ID for task-level reporting.
• GMS_PROJECT_FUNDINGS (APPS synonym/view) — The APPS-layer object exposing the GMS table to application code and reports.

These objects form the core join path for Grants Accounting funding analysis and reconciliation against Oracle Projects.