Results for “gms_awards_all”

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

Overview

GMS_AWARDS_ALL is the primary transactional table in the Oracle E-Business Suite Grants Accounting (GMS) module. It stores the master record for each award — the funding agreement between an institution and a sponsoring agency — and serves as the anchor point for award budgeting, billing, revenue recognition, indirect cost calculation, and compliance tracking across the grants lifecycle.

In Oracle EBS 12.1.1 and 12.2.2, the table resides in the GMS schema and contains 85 documented columns. GMS_AWARDS_ALL links each award to a corresponding Oracle Projects project (through AWARD_PROJECT_ID), enabling award-funded expenditures and invoices to flow through the standard Projects costing and billing engines. The "ALL" suffix indicates a multi-organization (multi-org) table partitioned by ORG_ID, so queries must respect the operating unit context.

Applying Data Vault modeling heuristics to the documented foreign-key structure, GMS_AWARDS_ALL behaves as a link entity: it records associations between an award, a project, an indirect cost rate schedule, a funding source, and an external award record. This classification is a heuristic suggestion rather than a delivered Oracle model, but it accurately reflects the table's role as a junction between independently mastered business entities.

Key Information Stored

The surrogate primary key is AWARD_ID, enforced by the unique index GMS_AWARDS_U1. Two business-key candidates are documented: AWARD_NUMBER (unique index GMS_AWARDS_U2) and AWARD_ID itself, which is also the FK to IGF_AW_AWARD_ALL.

• AWARD_NUMBER — the user-visible identifier for the award; the natural business key.
• AWARD_SHORT_NAME / AWARD_FULL_NAME — display and descriptive names used throughout inquiry and reporting.
• AWARD_PROJECT_ID — FK to PA_PROJECTS_ALL; the Oracle Projects project that carries the award's costs and billing.
• FUNDING_SOURCE_ID — FK to OKE_K_FUNDING_SOURCES; identifies the sponsoring agency or funding entity.
• IDC_SCHEDULE_ID — FK to PA_IND_RATE_SCHEDULES_ALL_BG; the indirect cost rate schedule applied to the award.
• STATUS — lifecycle state of the award (active, closed, pre-award).
• START_DATE_ACTIVE / END_DATE_ACTIVE / CLOSE_DATE — the award's effective and closing dates.
• AWARD_MANAGER_ID — the internal owner accountable for the award.
• BILL_TO_CUSTOMER_ID, BILL_TO_ADDRESS_ID, SHIP_TO_ADDRESS_ID — billing party and address references.
• BILLING_FREQUENCY, BILLING_CYCLE_ID, BILLING_FORMAT, BILLING_TERM — invoice generation parameters.
• HARD_LIMIT_FLAG, INVOICE_LIMIT_FLAG — controls that prevent billing beyond the funded amount.
• AMOUNT_TYPE, BOUNDARY_CODE, FUND_CONTROL_LEVEL_* — funding and budgetary control attributes at award, task, resource group, and resource level.
• ORG_ID — the multi-org operating unit discriminator.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE25 — the standard EBS DFF (descriptive flexfield) columns for customer-specific extension.

Common Use Cases and Queries

Typical reporting includes award listings by funding source, award-to-project reconciliation, and billing parameter audits. A representative query joining the award to its project and funding source follows:

• SELECT a.award_number, a.award_full_name, p.segment1 project_number, a.status FROM gms_awards_all a, pa_projects_all p WHERE a.award_project_id = p.project_id AND a.org_id = :org_id;
• Award manager workload: join AWARD_MANAGER_ID to PER_ALL_PEOPLE_F.
• Indirect cost review: join IDC_SCHEDULE_ID to PA_IND_RATE_SCHEDULES_ALL_BG.
• Multi-org filtering: always constrain by ORG_ID to return the correct operating unit's awards.

Related Objects

• PA_PROJECTS_ALL — joined via GMS_AWARDS_ALL.AWARD_PROJECT_ID = PA_PROJECTS_ALL.PROJECT_ID.
• IGF_AW_AWARD_ALL — joined via GMS_AWARDS_ALL.AWARD_ID = IGF_AW_AWARD_ALL.AWARD_ID.
• PA_IND_RATE_SCHEDULES_ALL_BG — joined via IDC_SCHEDULE_ID for indirect cost rates.
• OKE_K_FUNDING_SOURCES — joined via FUNDING_SOURCE_ID for the funding agency.
• GMS_AWARD_BUDGETS and GMS_AWARD_TASKS — child tables that depend on AWARD_ID.
• AR_CUSTOMERS — referenced through BILL_TO_CUSTOMER_ID for invoicing.