Search Results gms_encumbrances_all




Overview
Explore in AI Chat

Overview

GMS_ENCUMBRANCES_ALL is the header-level table within the Oracle Grants Accounting (GMS) module that stores groups of encumbrance items incurred by employees or organizations in a single encumbrance batch. Each row represents an encumbrance group, functioning as the transactional parent for individual encumbrance lines held in the GMS_ENCUMBRANCE_ITEMS_ALL child table. In Oracle E-Business Suite 12.1.1 and 12.2.2, this table serves as the central registry for grant-funded commitments, capturing control totals, approval workflow state, currency and exchange rate information, transfer status, and audit metadata.

From a heuristic Data Vault modeling perspective, the mined relationship structure classifies GMS_ENCUMBRANCES_ALL as satellite-leaning. Its primary key is a surrogate identifier with limited natural business attributes of its own, while its descriptive and status columns extend context around transactional events. The table also carries hub-like characteristics because it is referenced by dependent child records through a foreign key. Data modelers should treat this classification as a suggestion rather than a prescriptive design.

Key Information Stored

The table contains 47 documented columns in the 12.2.2 physical schema. The most significant are:

A unique index, GMS_ENCUMBRANCE_U1, exists on ENCUMBRANCE_ID, reinforcing it as the sole business-key candidate.

Common Use Cases and Queries

Reporting and integration scenarios typically aggregate encumbrance amounts by organization, vendor, or status to validate grant commitments against budgets. Reconciliation queries compare CONTROL_TOTAL_AMOUNT against the sum of child lines:

  • Status dashboards filtering on ENCUMBRANCE_STATUS_CODE and WF_STATUS_CODE to identify unapproved or pending batches.
  • Vendor commitment reports joining to PO_VENDORS on VENDOR_ID.
  • Currency exposure analysis using DENOM_CURRENCY_CODE and ACCT_EXCHANGE_RATE.
  • Operating unit reporting constrained by ORG_ID through Multi-Org views.
  • Transfer tracking using TRANSFER_STATUS_CODE to find encumbrances not yet posted to General Ledger.

A representative query joins the child table to total item lines and compares them with the control total.

Related Objects

The most significant relationships for this object are:

  • GMS_ENCUMBRANCE_ITEMS_ALL — Child table referencing GMS_ENCUMBRANCES_ALL.ENCUMBRANCE_ID; holds individual encumbrance lines.
  • PO_VENDORS — Parent table joined on GMS_ENCUMBRANCES_ALL.VENDOR_ID.
  • GMS_ENCUMBRANCE_GROUPS_PK — Primary key constraint on ENCUMBRANCE_ID.
  • GMS_ENCUMBRANCE_U1 — Unique index on ENCUMBRANCE_ID.
  • HR_EMPLOYEES / PER_ALL_PEOPLE_F — Resolves INCURRED_BY_PERSON_ID, ENTERED_BY_PERSON_ID, and OVERRIDING_APPROVER_PERSON_ID.
  • HR_ORGANIZATION_UNITS — Resolves INCURRED_BY_ORGANIZATION_ID.
  • GL_DAILY_CONVERSION_TYPES and GL_CURRENCIES — Support currency and rate interpretation.
  • FND_CURRENCIES — Validates currency code values.