Results for “gms_encumbrance_groups_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• ENCUMBRANCE_ID — The surrogate primary key, enforced by GMS_ENCUMBRANCE_GROUPS_PK. This is the value propagated to child records.
• ENCUMBRANCE_GROUP and USER_BATCH_NAME — Practical business identifiers for the batch or group being submitted.
• ENCUMBRANCE_STATUS_CODE, WF_STATUS_CODE, and TRANSFER_STATUS_CODE — Control the approval workflow, overall encumbrance state, and downstream transfer processing.
• ENCUMBRANCE_CLASS_CODE, ENCUMBRANCE_ENDING_DATE, and DESCRIPTION — Classify the encumbrance and describe its purpose and expected life.
• CONTROL_TOTAL_AMOUNT — The reconciling total for the group against which item lines are validated.
• INCURRED_BY_PERSON_ID, INCURRED_BY_ORGANIZATION_ID, and ENTERED_BY_PERSON_ID — Identify who incurred and entered the encumbrance.
• OVERRIDING_APPROVER_PERSON_ID and INITIAL_SUBMISSION_DATE — Support approval audit trails.
• VENDOR_ID — Foreign key to PO_VENDORS, identifying the supplier against whom the commitment is recorded.
• DENOM_CURRENCY_CODE, ACCT_CURRENCY_CODE, ACCT_RATE_DATE, ACCT_RATE_TYPE, and ACCT_EXCHANGE_RATE — Capture multi-currency and rate conversion details.
• ORG_ID — The operating unit owning the record, supporting Multi-Org access control.
• ORIG_ENC_TXN_REFERENCE1 through ORIG_ENC_TXN_REFERENCE3 and ORIG_USER_ENC_TXN_REFERENCE — Preserve the original source transaction references used to derive the encumbrance.
• PTE_REFERENCE — Links to prior-period adjustment or processing reference data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE — Standard WHO audit columns.

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.