Search Results gms_budget_versions




Overview
Explore in AI Chat

Overview

The GMS_BUDGET_VERSIONS table is a core data object within the Oracle E-Business Suite Grants Accounting (GMS) module. It serves as the central repository for storing and managing different versions of budgets associated with sponsored awards or grants. In the context of project financial management for grant-funded activities, this table enables organizations to create, maintain, and track multiple budget iterations for a single award. This functionality is critical for processes such as initial budget submission, rebudgeting, and comparative analysis of planned versus actual expenditures across different fiscal scenarios. Its role is integral to maintaining audit trails and ensuring compliance with sponsor-specific financial regulations.

Key Information Stored

While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal the essential data attributes. The table's primary key is BUDGET_VERSION_ID, which uniquely identifies each budget version record. Key foreign key columns link this table to other fundamental EBS entities, defining the budget's context and methodology. These include PROJECT_ID, which ties the budget version to a specific award or project in PA_PROJECTS_ALL. The BUDGET_TYPE_CODE and BUDGET_ENTRY_METHOD_CODE columns reference PA_BUDGET_TYPES and PA_BUDGET_ENTRY_METHODS, respectively, defining the budget's classification (e.g., original, current, baseline) and the method used for its creation (e.g., spreadsheets, templates). The RESOURCE_LIST_ID links to PA_RESOURCE_LISTS_ALL_BG, associating a predefined list of resources (labor, equipment) with the budget version.

Common Use Cases and Queries

A primary use case is generating reports that list all budget versions for a specific award, often for audit or management review. Another critical scenario involves querying to compare details between different versions, such as an original versus a revised budget. Technical consultants often reference this table when building custom budget validation or integration scripts. A common SQL pattern retrieves budget version headers for a project:

  • SELECT budget_version_id, budget_type_code, version_name, description FROM gms_budget_versions WHERE project_id = :p_project_id ORDER BY creation_date;

For a more comprehensive report joining related information, a query might join to PA_PROJECTS_ALL to get the project name and number, and to PA_BUDGET_TYPES for the budget type meaning.

Related Objects

The GMS_BUDGET_VERSIONS table is a central hub within the Grants Accounting schema. It is directly referenced by the GMS_RESOURCE_ASSIGNMENTS table via the BUDGET_VERSION_ID foreign key, where the detailed line-item budget amounts are stored. As indicated by its foreign keys, it depends on several Project Accounting (PA) tables for foundational data: PA_PROJECTS_ALL (award definition), PA_BUDGET_TYPES, PA_BUDGET_ENTRY_METHODS, and PA_RESOURCE_LISTS_ALL_BG. This structure ensures that budget versions are always created within the context of a valid project and adhere to defined entry methods and resource constraints. Custom reports and interfaces typically join these tables to present a complete budget picture.