Search Results at_risk




Overview
Explore in AI Chat

Overview

GMS_SSA_AWARDS_V is an Oracle EBS Grants Management (GMS) reporting view owned by the APPS schema. It presents a consolidated result set of award header information joined to sponsored project and task funding structures, filtered to a specific operational subset of awards. The name "SSA" refers to the Sponsored Systems Application / awards service layer used by GMS, and the view is intended to expose awards in a state suitable for downstream reporting, funding inquiry, and integration processing in Oracle EBS 12.1.1 and 12.2.2.

The defining characteristic of the view is its restrictive filter predicate, which is also the origin of the frequently searched term at_risk. The view only returns awards whose AW.STATUS value is either 'AT_RISK' or 'ACTIVE', combined with the additional conditions that AW.AWARD_TEMPLATE_FLAG = 'DEFERRED' and a corresponding baseline budget version exists. In practice, this view answers the question: which active or at-risk deferred-template awards have a baseline budget and chargeable tasks established against a sponsored project.

Because the view resolves award, project, task, and organization data in a single flat structure, it is commonly consumed by concurrent programs, OAF pages, and custom reports that need award-to-project context without traversing the normalized GMS and PA base tables individually.

Underlying Base Objects

Per the documented metadata for ETRM 12.2.2, the view is defined over the following objects, most of which are referenced as APPS synonyms:

  • GMS_AWARDS (synonym) — the driving table, supplying award identifiers, names, status, dates, template flag, and organization ID.
  • GMS_INSTALLMENTS (synonym) — links awards to funded installments.
  • GMS_SUMMARY_PROJECT_FUNDINGS (synonym) — bridges awards/installments to sponsored projects and tasks.
  • GMS_BUDGET_VERSIONS (synonym) — referenced via an EXISTS subquery to confirm a baseline budget version (BUDGET_STATUS_CODE = 'B').
  • PA_PROJECTS_ALL (synonym) — provides project number (SEGMENT1).
  • PA_TASKS (synonym) — provides task number and chargeable flag; joined on direct task, NULL task, or top task logic.
  • HR_ORGANIZATION_UNITS (view) — supplies the award organization name.
  • HR_GENERAL and HR_SECURITY (packages) — provide organization security and validation behavior for HR organization data.

The joins enforce project/task consistency across funding and task records, and the EXISTS clause on GMS_BUDGET_VERSIONS ensures only awards with a baseline budget for the matching project are returned. The view produces a DISTINCT result set to collapse duplicate rows arising from the multi-table join.

Key Columns

Common Use Cases and Queries

Typical usage centers on identifying at-risk deferred awards and their associated sponsored projects and tasks, often within an operating unit context.

  • Reporting all active or at-risk awards with baseline budgets for a given organization.
  • Driving validation or notification concurrent programs that alert administrators to at-risk awards.
  • Supporting funding inquiry pages that need award-to-project-task navigation.

Sample query:

SELECT award_number,
       award_short_name,
       award_organization_name,
       start_date,
       end_date,
       project_number,
       task_number
FROM   apps.gms_ssa_awards_v
WHERE  org_id = :p_org_id
ORDER  BY award_number, project_number;

Because the view already restricts results to AT_RISK and ACTIVE awards with deferred templates and baseline budgets, consumers should not attempt to widen the status set by filtering; the predicate is intrinsic to the view definition. Queries against it should instead narrow by organization, project, or date range.