Search Results gms_balances




Overview
Explore in AI Chat

Overview

The GMS_BALANCES table is a core data repository within the Oracle E-Business Suite Grants Accounting (GMS) module for releases 12.1.1 and 12.2.2. It serves as the central ledger for tracking the financial position of awarded grants, contracts, and other sponsored projects. Its primary role is to store the cumulative balance of budgets, actual costs incurred, and encumbrance costs at a detailed level of granularity. This table is fundamental for ensuring compliance with funding agency regulations by providing real-time visibility into project financials, enabling budget versus actual reporting, and supporting critical processes like award closeout and financial reconciliation.

Key Information Stored

The table's structure is designed to store balances keyed by essential project and financial dimensions. While the full column list is not detailed in the provided metadata, the foreign key relationships explicitly identify its critical components. These include the PROJECT_ID and TASK_ID linking to the Project Accounting (PA) structures, the RESOURCE_LIST_MEMBER_ID for the specific expenditure item or resource, and the SET_OF_BOOKS_ID for the associated ledger. The BUDGET_VERSION_ID indicates which approved budget the balances are measured against. The table's core data columns store aggregated amounts for budgeted, actual, and encumbered costs, typically segmented by period and potentially by other accounting flexfields like expenditure type or award.

Common Use Cases and Queries

This table is directly queried for financial reporting and audit trails. Common use cases include generating detailed award balance summaries, preparing certified financial reports for sponsors, and analyzing budget utilization. A typical query pattern involves joining GMS_BALANCES to its related dimension tables to produce a human-readable report.

  • Budget vs. Actual Report for a Project: A SQL query would join GMS_BALANCES to PA_PROJECTS_ALL and PA_TASKS, filtering by a specific PROJECT_ID and BUDGET_VERSION_ID, to list tasks with their budgeted amounts, actual costs, and remaining balances.
  • Encumbrance Analysis: To review outstanding commitments, queries sum the encumbrance columns grouped by award or resource type.
  • Period Close Reconciliation: Balances are rolled forward by period, making this table essential for verifying that period-end actuals from subledgers like Payables match the aggregated totals in the grants ledger.

Related Objects

As defined by its foreign keys, GMS_BALANCES has integral dependencies on several key Project Accounting and General Ledger tables. Its primary relationships are with:

  • PA_PROJECTS_ALL: Provides the master project definition.
  • PA_TASKS: Provides the task-level detail within a project.
  • PA_RESOURCE_LIST_MEMBERS: Links to the detailed resource or expenditure item (and its parent via PARENT_MEMBER_ID) used for budgeting and costing.
  • PA_BUDGET_VERSIONS: Identifies the specific budget version against which financial performance is measured.
  • GL_SETS_OF_BOOKS_11I: Associates the balances with the correct financial ledger and chart of accounts.

This table is also a primary source for numerous GMS inquiry forms and standard reports within the application.