Search Results gms_awards_all

Overview

The GMS_AWARDS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Grants Accounting (GMS) module. It serves as the master repository for storing fundamental information about awards. In the context of grant and contract management, an award is the formal funding agreement from a sponsor. This table is central to the GMS architecture, enabling the tracking, management, and financial accounting of all sponsored project funds throughout their lifecycle. As a multi-organization table (indicated by the "_ALL" suffix), it stores data across all operating units, allowing for a consolidated yet partitioned view of awards within an enterprise deployment of Oracle EBS versions 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns, based on its role as the primary award table, it typically contains critical attributes that define the award. Common columns include a unique identifier (AWARD_ID), the award number and title, the associated sponsor, effective and expiration dates, total awarded amount, and financial terms. It also stores key reference IDs that link to other EBS entities, such as AWARD_PROJECT_ID to connect the award to a specific project in Oracle Projects (PA) and IDC_SCHEDULE_ID to define the indirect cost (overhead) rate schedule applicable to the award. The table will also contain standard Oracle columns for auditing (CREATION_DATE, LAST_UPDATE_DATE) and multi-org setup (ORG_ID).

Common Use Cases and Queries

This table is fundamental for award inquiry, reporting, and integration. Common operational use cases include generating award summaries for principal investigators, validating award setup for transaction processing (like expenditure batches), and creating funding reports for sponsors. A typical query would join this table to related project and organization tables to produce a comprehensive award listing. For example:

• Listing active awards with their associated project numbers: SELECT a.award_number, a.award_title, p.segment1 project_number FROM gms_awards_all a, pa_projects_all p WHERE a.award_project_id = p.project_id AND sysdate BETWEEN a.start_date AND nvl(a.end_date, sysdate+1);
• Identifying awards using a specific indirect cost rate schedule for a compliance review.
• Serving as the primary source for data extracts to external reporting or business intelligence systems.

Related Objects

The GMS_AWARDS_ALL table maintains critical foreign key relationships with other EBS tables, as documented in the provided metadata. These relationships are essential for data integrity and joined reporting.

• PA_PROJECTS_ALL: This is a primary relationship. The AWARD_PROJECT_ID column in GMS_AWARDS_ALL references a PROJECT_ID in PA_PROJECTS_ALL. This links each award to its corresponding master project definition within Oracle Projects.
• PA_IND_RATE_SCHEDULES_ALL_BG: The IDC_SCHEDULE_ID column in GMS_AWARDS_ALL references a rate schedule in this table. This defines the set of indirect cost rates applied to the award's expenditures for recovery calculations.

Additionally, numerous other GMS tables (such as GMS_BUDGETS, GMS_SUB_AWARDS) will reference the GMS_AWARDS_ALL.AWARD_ID as a foreign key to store detailed, child records associated with the master award.