Search Results pa_projects_u2

Overview

APPS.GMS_PROJECTS_V is a reporting view in Oracle EBS Grants Management (GMS) that exposes a consolidated, project-oriented projection of Oracle Projects data. The view is owned by the APPS schema and functions as a lightweight, denormalized access point to project header information for downstream GMS reporting and integration. Its principal design objective is to present non-award projects—that is, projects that are not of type AWARD_PROJECT—with a stable set of descriptive attributes such as project number, name, dates, currency, operating unit, and project type classification.

The view is defined over PA_PROJECTS_EXPEND_V, a public expenditure view in Oracle Projects, and applies a GROUP BY across all selected columns. This grouping effectively deduplicates rows that may arise from the underlying expenditure view's join logic, producing one row per project. A fixed optimizer hint, /*+ INDEX PA_PROJECTS_U2 */, is embedded in the view text to steer the execution plan toward the PA_PROJECTS_U2 unique index. This is consistent with the user's search term and indicates that the view was tuned for indexed access paths on the project identifier.

Underlying Base Objects

The documented base objects referenced by GMS_PROJECTS_V are:

• PA_PROJECTS_EXPEND_V (VIEW) — the direct source of all selected columns.
• PA_PROJECT_UTILS (PACKAGE) — utility logic invoked indirectly through the expenditure view.
• PA_CROSS_BUSINESS_GRP (PACKAGE) — cross-business-group and operating unit security handling.
• FND_PROFILE (PACKAGE) — profile option retrieval, typically for org context and security.

Because PA_PROJECTS_EXPEND_V is itself a view, the apparent dependencies reflect the view hierarchy rather than direct base-table joins. The GROUP BY clause is applied at the outer level, so the filtering predicate A.PROJECT_TYPE <> 'AWARD_PROJECT' is evaluated before aggregation.

Key Columns

• PROJECT_ID — Primary internal identifier for the project.
• PROJECT_NUMBER — User-facing project number.
• PROJECT_NAME — Descriptive project name.
• START_DATE — Project start date.
• COMPLETION_DATE — Expected or actual completion date.
• PROJECT_CURRENCY_CODE — Project currency for financial reporting.
• PROJECT_OU — Operating unit to which the project belongs.
• PROJECT_TYPE_CLASS_CODE — Classification code for the project type.
• PROJECT_DESCRIPTION — Free-text description.
• PROJFUNC_CURRENCY_CODE — Project functional currency code.

Common Use Cases and Queries

This view is typically used for grants-facing project lookups, LOV queries, and reporting where award projects must be excluded. A representative query:

• SELECT project_id, project_number, project_name FROM apps.gms_projects_v WHERE project_number = :p_number;
• SELECT project_number, start_date, completion_date FROM apps.gms_projects_v WHERE project_ou = :p_org_id ORDER BY project_number;
• SELECT p.project_number, p.project_name FROM apps.gms_projects_v p WHERE p.project_type_class_code = :p_class;

Because the view is pre-grouped, callers avoid duplicate project rows and can join it directly to award, budget, or expenditure fact queries. In EBS 12.1.1 and 12.2.2 the view remains unchanged in definition, and the embedded optimizer hint continues to influence plan selection for indexed access on PA_PROJECTS_U2.