Search Results gms_award_distributions




Overview
Explore in AI Chat

Overview

The GMS_AWARD_DISTRIBUTIONS table is a core data object within the Oracle E-Business Suite Grants Accounting (GMS) module. It serves as the central repository for tracking the distribution of financial transactions against sponsored awards. Its primary role is to record and maintain the detailed linkage between individual expenditure or procurement distribution lines—such as those from requisitions, purchase orders, invoices, encumbrances, and project costs—and the specific award and funding source against which they are charged. This table is fundamental for ensuring accurate grant accounting, cost allocation, compliance, and the generation of sponsored project financial reports.

Key Information Stored

While the provided metadata does not list specific columns, based on its documented purpose and foreign key relationships, the table typically stores critical attributes for award-based financial tracking. Key information includes identifiers linking back to the source transaction distribution (e.g., DISTRIBUTION_ID, PO_DISTRIBUTION_ID), references to the award and its funding details (such as AWARD_ID, PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID), and the financial amounts charged. It also holds data necessary for fund checking, budgetary control, and determining the award's share of a cost, such as the distributed amount and potentially the burden cost and transaction date.

Common Use Cases and Queries

This table is central to queries that analyze award spending, facilitate audit trails, and support reconciliation. Common use cases include tracing all expenditures charged to a specific award, reconciling procurement or project accounting distributions with grant records, and preparing detailed expenditure reports for sponsors. A typical reporting query would join this table to award, project, and source transaction tables.

  • Expenditure Summary by Award: SELECT gad.award_id, SUM(gad.amount) FROM gms_award_distributions gad WHERE gad.award_id = :p_award_id GROUP BY gad.award_id;
  • Drill-down to Source Transactions: Queries frequently join to PO_DISTRIBUTIONS_ALL or PO_REQ_DISTRIBUTIONS_ALL via the documented foreign keys to retrieve purchase order or requisition details for award-charged items.
  • Audit and Compliance Reporting: Analyzing distributions by date, project task, or expenditure type to verify allowability and allocability under award terms.

Related Objects

The table has defined integration points with other EBS modules, as evidenced by its foreign keys. Key related objects include:

  • PO_REQ_DISTRIBUTIONS_ALL: Links requisition distribution lines to award funding.
  • PO_DISTRIBUTIONS_ALL: Links purchase order distribution lines to award funding.
  • GMS_AWARDS: The master award definition table, likely related via AWARD_ID.
  • PA_EXPENDITURE_ITEMS_ALL: For project-related costs charged to awards, though not explicitly listed in the provided metadata, this is a standard relationship in GMS.
  • Various GMS summary and reporting views which likely aggregate data from this granular distribution table.