Results for “funding_source_id”

50+ results




Overview
Explore in AI Chat

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

Overview

GMS_STATUS_AWARD_ACCUM_V is an Oracle EBS APPS schema view that belongs to the GMS (Grants Accounting) product family. It presents aggregated award-level financial status information, consolidating revenue, budget, cost, and commitment balances for each award managed within Oracle Grants Accounting. The view is designed to support award status inquiry screens, funding source analysis, and downstream reporting or integration extracts where a summarized, one-row-per-award-and-funding-source perspective is required.

Rather than storing data itself, the view derives its content by aggregating the rows of an underlying base view and grouping the results across award identity, status, award type, funding source, and award organization. This makes it a convenient, pre-summarized access point for reporting tools, concurrent programs, and custom SQL that need commitment and budget consumption figures without re-implementing the aggregation logic.

Underlying Base Objects

According to the documented 12.2.2 metadata, GMS_STATUS_AWARD_ACCUM_V is defined over a single referenced base object: GMS_STATUS_AWARD_ACCUM_BASE_V (itself a VIEW owned by APPS). The view selects from that base and applies a GROUP BY to roll up the detailed rows. The documented view text confirms this relationship:

Because the base object is itself a view, the ultimate physical data resides in the Grants Accounting award, budget, expenditure, and encumbrance tables that the base view resolves to. From a DBA and tuning standpoint, this layered design means the aggregation cost is incurred at query time, so performance depends on the indexes present on the underlying GMS tables.

Key Columns

The view exposes the following documented columns. Identity and grouping columns are returned directly; financial measures are summed:

  • AWARD_ID – Primary key of the award; groups the output.
  • AWARD_NUMBER, AWARD_SHORT_NAME – User-facing award identifiers.
  • STATUS – Award status; part of the grouping key.
  • TOTAL_REVENUE – Summed revenue recognized against the award.
  • BUDGET_AMOUNT – Summed budgeted amount.
  • ACTUAL_COST – Summed actual costs incurred.
  • REQUISITION_AMOUNT, PURCHASE_ORDER_AMOUNT, SUPPLIER_INVOICE_AMOUNT, MANUAL_ENCUMBRANCE_AMOUNT – The individual encumbrance components.
  • COMMITMENT_AMOUNT – Computed as the sum of the four encumbrance components above; it is not a stored column but a derived expression in the view text.
  • AWARD_TYPE – The award type attribute (referenced as TYPE in the grouping clause).
  • FUNDING_SOURCE_ID – The funding source identifier associated with the award; this is a grouping column, meaning results are produced at funding-source granularity.
  • AWARD_ORGANIZATION_ID – The owning organization of the award; also a grouping column.

Common Use Cases and Queries

This view is typically queried for award status dashboards, budget-versus-commitment variance reporting, and funding-source-level analysis. Because the user searched for funding_source_id, the most common query pattern filters or groups by that column:

  • Retrieve all accumulated balances for a specific funding source: SELECT * FROM APPS.GMS_STATUS_AWARD_ACCUM_V WHERE funding_source_id = :p_funding_source_id;
  • Report budget versus commitment by award: SELECT award_number, SUM(budget_amount), SUM(commitment_amount) FROM APPS.GMS_STATUS_AWARD_ACCUM_V GROUP BY award_number;
  • List funding sources for a given award: SELECT DISTINCT funding_source_id FROM APPS.GMS_STATUS_AWARD_ACCUM_V WHERE award_id = :p_award_id;

In each case, callers should remember the results are already aggregated at the award, type, funding source, and organization level, so additional grouping may be redundant.