Results for “date_allocated”

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

Overview

The GMS_PROJECT_FUNDINGS table is a core data object within the Oracle EBS Grants Accounting (GMS) module. It stores the incremental amounts of allocated funds distributed from award installments to specific projects and tasks. In the grants management lifecycle, this table acts as the transactional bridge between sponsored award installment schedules (managed through IGS - Grants/Proposals) and the Projects (PA) funding structures. Each record represents a discrete allocation event, capturing how much funding from a given installment was assigned to a particular project or task on a specific date.

Under the heuristic Data Vault classification derived from its foreign key structure, GMS_PROJECT_FUNDINGS is modeled as a standalone object — meaning it does not participate as a hub or link in the mined relationship graph, but rather functions as an independent transaction entity. This classification suggests that, for Data Vault modeling purposes, the table could be treated as its own hub or as a satellite dependant on external references rather than as a connecting link between two hubs.

The table resides in the GMS schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. It contains 12 documented columns and is referenced by Grants Accounting processes that generate funding distributions during award activation, installment processing, and budget revisions.

Key Information Stored

The 12 documented columns support identification, relationship linkage, monetary value, and audit tracking. The most significant columns include:

• GMS_PROJECT_FUNDING_ID — The surrogate primary key and sole unique index candidate (GMS_PROJECT_FUNDINGS_U1). This system-generated identifier uniquely identifies each funding allocation record.
• PROJECT_FUNDING_ID — A foreign key to PA_PROJECT_FUNDINGS, linking the Grants Accounting allocation to the underlying Projects funding record. This is the principal business relationship anchoring the record.
• INSTALLMENT_ID — A foreign key to IGS_FI_PP_INSTLMNTS, identifying the award installment from which funds are being allocated. This drives the incremental nature of the table.
• PROJECT_ID — Identifies the project receiving the allocated funding.
• TASK_ID — Identifies the specific task within the project to which funds are distributed, enabling task-level funding granularity.
• FUNDING_AMOUNT — The monetary value of the incremental allocation, the primary quantitative attribute for reporting and reconciliation.
• DATE_ALLOCATED — The business date on which the allocation was made, supporting period-based reporting.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and modified each record and when.

Notably, the table does not carry a documented natural business key distinct from its surrogate; the unique index is on the surrogate PK alone.

Common Use Cases and Queries

Grants Accounting administrators and project accountants query this table to:

• Reconcile installment funding against project budgets — summing FUNDING_AMOUNT by PROJECT_ID and comparing to project funding totals.
• Audit task-level allocations — identifying which tasks received funds from which installments.
• Report incremental distributions over time — grouping by DATE_ALLOCATED for period analysis.

A representative query joining to the parent funding and installment tables:

SELECT gpf.PROJECT_ID, gpf.TASK_ID, gpf.FUNDING_AMOUNT, gpf.DATE_ALLOCATED, i.INSTALLMENT_NUM
FROM GMS.GMS_PROJECT_FUNDINGS gpf, IGS.IGS_FI_PP_INSTLMNTS i
WHERE gpf.INSTALLMENT_ID = i.INSTALLMENT_ID
AND gpf.PROJECT_ID = :project_id;

Another common pattern joins to PA_PROJECT_FUNDINGS to align Grants allocations with Projects funding records for cross-module reconciliation.

Related Objects

• PA_PROJECT_FUNDINGS — referenced via PROJECT_FUNDING_ID; the master Projects funding record for each allocation.
• IGS_FI_PP_INSTLMNTS — referenced via INSTALLMENT_ID; the installment schedule driving incremental allocations.
• PA_PROJECTS_ALL — indirectly related through PROJECT_ID for project name and organizational context.
• PA_TASKS — indirectly related through TASK_ID for task-level descriptions.
• GMS_AWARDS — the parent award underpinning installment and funding activity.
• GMS_AWARD_DISTRIBUTIONS — related distribution records in the Grants module.
• IGS_FI_PP_HEADERS — the installment header associated with each IGS_FI_PP_INSTLMNTS row.