Search Results gms_encumbrances




Overview
Explore in AI Chat

Overview

GMS_ENCUMBRANCES is a reporting and inquiry view in the Oracle E-Business Suite Grants Accounting (GMS) module. It exposes encumbrance records associated with sponsored projects, awards, and grant-funded transactions, presenting a denormalized, business-friendly projection of the underlying encumbrance base table. In Oracle EBS 12.1.1 and 12.2.2, the view is used primarily for inquiry, reporting, and integration scenarios where grant encumbrance data must be retrieved without directly accessing the transactional base table.

The view is defined with a row-level security predicate based on the ORG_ID column. The WHERE clause compares ORG_ID against the operating unit derived from the USERENV('CLIENT_INFO') session context, using the standard multi-org pattern seen throughout EBS. This ensures that a query executed in the context of a given operating unit returns only encumbrances belonging to that organization, consistent with Multi-Org Access Control (MOAC) behavior. Notably, the ETRM metadata states that the view is not implemented in the reference database, meaning the definition is documented but the object may not exist in every environment; its presence depends on whether Grants Accounting encumbrance functionality has been deployed.

Underlying Base Objects

The view is defined over a single documented base object: GMS_ENCUMBRANCES_ALL. The view text selects a specific list of columns from GMS_ENCUMBRANCES_ALL and applies the ORG_ID security filter, but does not perform joins to any other tables. GMS_ENCUMBRANCES_ALL is the multi-org base table that stores encumbrance header records for grants, and GMS_ENCUMBRANCES acts as the secured, operating-unit-filtered synonym-like view over it. Because the ETRM metadata documents no additional referenced base objects, all columns exposed by the view originate from GMS_ENCUMBRANCES_ALL. Related detail lines, if required, would typically be obtained from separate encumbrance line tables rather than through this view.

Key Columns

The view exposes a broad set of columns that describe each encumbrance and its lifecycle. The most frequently referenced columns include:

Common Use Cases and Queries

The view is commonly queried to report encumbrances by incurring organization, to reconcile grant commitments, and to feed downstream integrations. A typical query filtering on the incurred-by organization is:

  • SELECT encumbrance_id, incurred_by_organization_id, incurred_by_person_id, control_total_amount, encumbrance_status_code FROM gms_encumbrances WHERE incurred_by_organization_id = :org_id;
  • SELECT encumbrance_status_code, COUNT(*), SUM(control_total_amount) FROM gms_encumbrances GROUP BY encumbrance_status_code;
  • SELECT encumbrance_id, encumbrance_ending_date FROM gms_encumbrances WHERE encumbrance_ending_date BETWEEN :start_date AND :end_date;

Because the view enforces ORG_ID security automatically, no additional organization predicate is required when the correct operating unit context is set. Reports that join this view to award or project tables should still be validated against GMS_ENCUMBRANCES_ALL to confirm column-level lineage, as the view is documented as not implemented in the reference database.