Results for “gms_encumbrance_u1”

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

Overview

GMS.GMS_ENCUMBRANCES_ALL is a transaction table in the Oracle E-Business Suite Grants Management (GMS) schema. It stores the header-level group of encumbrance items incurred by employees or organizations within an encumbrance batch. Encumbrance transactions captured here can originate as manual encumbrances or as encumbrances interfaced from Oracle Labor Distribution. The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and in the documented 12.2.2 schema it carries 47 columns. Its FND Design Data registration confirms it as a standard, seeded application object with a VALID status across the 12.1.1 and 12.2.2 code lines.

Based on the foreign key topology, the table exhibits a satellite-leaning Data Vault classification: it acts primarily as a descriptive satellite hanging off a parent encumbrance group entity, with the primary key GMS_ENCUMBRANCE_GROUPS_PK defined on ENCUMBRANCE_ID. This classification is a heuristic modeling suggestion rather than an enforced constraint; the authoritative master relationship is expressed through the PK/FK definitions in the ETRM metadata.

Key Information Stored

The table is anchored by its surrogate primary key and distinguished by a single unique business-key candidate index, GMS_ENCUMBRANCE_U1, defined on ENCUMBRANCE_ID in the APPS_TS_TX_IDX tablespace. Two additional non-unique indexes support retrieval: GMS_ENCUMBRANCES_ALL_N2 on INCURRED_BY_ORGANIZATION_ID and GMS_ENCUMBRANCE_N1 on ENCUMBRANCE_GROUP.

• ENCUMBRANCE_ID — System-generated number uniquely identifying the encumbrance; the documented primary key and unique index column.
• ENCUMBRANCE_STATUS_CODE — Status of the encumbrance as it is entered and approved.
• ENCUMBRANCE_ENDING_DATE — Last day of the encumbrance week period; all encumbrance items and timecard items must fall within this period.
• ENCUMBRANCE_CLASS_CODE — Classifies the encumbrance, indicating the type of items grouped into it.
• INCURRED_BY_PERSON_ID — Employee who incurred the charges; always populated for labor and expense report charges, not populated for supplier invoices, optional for usages.
• INCURRED_BY_ORGANIZATION_ID — Organization that incurred the charges; populated for all charges except supplier invoices, where the organization is held at the expenditure level.
• ENCUMBRANCE_GROUP — Grouping attribute used to organize related encumbrances; indexed for query performance.
• VENDOR_ID — Foreign key to PO_VENDORS, associating supplier-invoice-originated encumbrances with a vendor.
• CONTROL_TOTAL_AMOUNT — Control total amount for the encumbrance batch.
• DENOM_CURRENCY_CODE / ACCT_CURRENCY_CODE — Documented and accounting currency codes, accompanied by ACCT_RATE_DATE, ACCT_RATE_TYPE, and ACCT_EXCHANGE_RATE for currency conversion.
• WF_STATUS_CODE / TRANSFER_STATUS_CODE — Workflow and transfer state indicators governing downstream processing.
• ORG_ID — Operating unit identifier supporting multi-org (MOAC) access.

Standard Who columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN), concurrent program columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE), and the DFF attribute segment group (ATTRIBUTE_CATEGORY through ATTRIBUTE10) round out the row-level audit footprint.

Common Use Cases and Queries

Typical reporting patterns retrieve approved or transferred encumbrances for a given period or organization. A representative query joins the header to its item lines:

SELECT e.encumbrance_id, e.encumbrance_group,
       e.encumbrance_status_code, e.encumbrance_ending_date,
       e.control_total_amount, i.encumbrance_item_id
FROM   gms.gms_encumbrances_all e,
       gms.gms_encumbrance_items_all i
WHERE  e.encumbrance_id = i.encumbrance_id
AND    e.encumbrance_ending_date BETWEEN :p_start AND :p_end
AND    e.org_id = :p_org_id;

Common scenarios include reconciling interfaced Labor Distribution encumbrances against timecard charges, validating that all items fall on or before ENCUMBRANCE_ENDING_DATE, monitoring WF_STATUS_CODE and TRANSFER_STATUS_CODE for stalled batches, and aggregating CONTROL_TOTAL_AMOUNT by ENCUMBRANCE_CLASS_CODE. The indexed INCURRED_BY_ORGANIZATION_ID and ENCUMBRANCE_GROUP columns are the preferred predicates for period and grouping reports to avoid full scans of the APPS_TS_TX_DATA tablespace.

Related Objects

• GMS.GMS_ENCUMBRANCE_ITEMS_ALL — Child table joined on ENCUMBRANCE_ID; each row references a single header in GMS_ENCUMBRANCES_ALL.
• PO_VENDORS — Referenced by VENDOR_ID; supplies supplier-invoice vendor context.
• GMS_ENCUMBRANCE_GROUPS_PK — Primary key constraint on ENCUMBRANCE_ID, enforcing header uniqueness.
• GMS_ENCUMBRANCE_U1 — Unique index on ENCUMBRANCE_ID, the business-key candidate searched by users seeking this object.
• GMS_ENCUMBRANCES_ALL_N2 — Non-unique index on INCURRED_BY_ORGANIZATION_ID.
• GMS_ENCUMBRANCE_N1 — Non-unique index on ENCUMBRANCE_GROUP.