Search Results user_full_name

Overview

APPS.GMS_NOTIFICATIONS_V is a supplementary database view in the Oracle E-Business Suite Grants Management (GMS) module, owned by the APPS schema and flagged VALID in ETRM 12.1.1 and 12.2.2. Its FND Design Data identifier is GMS.GMS_NOTIFICATIONS_V. As a supplementary view, it exists primarily to simplify coding within the Oracle Forms-based Grants user interface rather than to serve as a stable public data source. Oracle explicitly warns that the view may change dramatically in subsequent minor or major releases, and the documented guidance advises against querying or altering data through it in production integrations. Despite this caveat, the view is widely encountered by developers and report authors because it exposes de-normalized notification and recipient information — including user identity fields such as USER_FULL_NAME — that would otherwise require joins across person, user, and award tables. The presence of USER_FULL_NAME among its columns is directly relevant to users searching for full-name data, as this view resolves the person name through HR-based name resolution logic rather than storing it raw.

Underlying Base Objects

The view is defined over a mixture of base tables, synonyms, and PL/SQL packages. Documented dependencies include the synonyms FND_USER, GMS_AWARDS_ALL, and GMS_NOTIFICATIONS, the packages HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, and the view PER_PEOPLE_X. In practical terms, GMS_NOTIFICATIONS supplies the notification event records; GMS_AWARDS_ALL supplies award context (number and short name); FND_USER maps the recipient USER_ID to an application user; and PER_PEOPLE_X combined with the HR_PERSON_NAME and HR_GENERAL packages resolves the human-readable full name. HR_SECURITY enforces row-level access restrictions on person data, which means the USER_FULL_NAME values returned are subject to the querying user's security profile. The view is referenced by GMS_CLIENT_EXTN_BUDGET_WF and GMS_WF_PKG, confirming its role in Grants workflow notification processing.

Key Columns

• ROW_ID (ROWID) — unique row identifier.
• AWARD_ID (NUMBER) — internal award identifier linking to GMS_AWARDS_ALL.
• AWARD_NUMBER / AWARD_SHORT_NAME — user-facing award identifiers.
• EVENT_TYPE — category of the notification event.
• USER_ID — FND_USER identifier of the notification recipient.
• USER_FULL_NAME (VARCHAR2, 240) — resolved full name of the recipient, derived via HR name logic.
• USER_NAME (VARCHAR2, 100) — the FND_USER login name.

Common Use Cases and Queries

Typical scenarios include enumerating notification recipients for an award, building workflow troubleshooting reports, and mapping USER_ID values to readable names. A representative query follows:

SELECT award_number, award_short_name, event_type, user_name, user_full_name FROM apps.gms_notifications_v WHERE award_id = :award_id ORDER BY user_full_name;

Because HR_SECURITY governs person visibility, USER_FULL_NAME may return null when the querying responsibility lacks person access. For stable reporting, joining PER_PEOPLE_X or FND_USER directly is preferable to relying on this supplementary view.