Results for “enc_distributed_flag”

46 results




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

Overview

GMS_ENCUMBRANCE_ITEMS_ALL is a table owned by the GMS schema within the Oracle E-Business Suite Grants Accounting (GMS) module. It stores manual encumbrance lines that are charged to sponsored projects. In grant-funded operations, encumbrances represent committed but unspent funds — salaries, purchase commitments, subcontracts, or other obligations — and this table captures the item-level detail of those commitments so that available budget on an award can be derived accurately.

Each row is a single encumbrance item belonging to a parent encumbrance header (GMS_ENCUMBRANCES_ALL). The table records the project, task, amount, currencies, exchange rate information, expenditure linkage, and audit columns necessary for costing, commitment reporting, and integration with Project Accounting. The TETRM metadata identifies a foreign-key relationship to PA_EXPENDITURE_ITEMS_ALL and PA_EVENTS, reflecting that encumbrance items can be linked to actual expenditures and to project events. Based on the mined foreign-key structure, the heuristic Data Vault classification is link — the table behaves as an associative entity connecting encumbrance headers, expenditure items, project events, and project/task dimensions. This classification is a modeling suggestion rather than a documented fact.

Key Information Stored

The primary key is the surrogate identifier ENCUMBRANCE_ITEM_ID, enforced by GMS_ENCUMBRANCE_ITEMS_ALL_PK and backed by unique index GMS_ENCUMBRANCE_ITEMS_ALL_U1. It is a system-generated key with no business meaning. The most significant business columns are:

Common Use Cases and Queries

Typical usage includes tracing encumbrances against sponsored projects for commitment reporting, reconciling encumbrance items to expenditure items, and validating conversion rates applied to commitments. A representative join query is:

  • Encumbrances by project: join GMS_ENCUMBRANCE_ITEMS_ALL to GMS_ENCUMBRANCES_ALL on ENCUMBRANCE_ID, filtered by PROJECT_ID and ORG_ID.
  • Expenditure linkage: join to PA_EXPENDITURE_ITEMS_ALL on PEL_EXPENDITURE_ITEM_ID to relate commitments to actual costs.
  • Event-based reporting: join to PA_EVENTS on PET_PROJECT_ID and PET_EVENT_NUM.

Reports commonly sum AMOUNT grouped by PROJECT_ID, TASK_ID, or ENCUMBRANCE_TYPE, and compare against award budgets to determine available funds.

Related Objects

  • GMS_ENCUMBRANCES_ALL — parent header; joined via ENCUMBRANCE_ID.
  • PA_EXPENDITURE_ITEMS_ALL — committed-to-actual linkage via PEL_EXPENDITURE_ITEM_ID.
  • PA_EVENTS — event linkage via PET_PROJECT_ID and PET_EVENT_NUM.
  • PA_PROJECTS_ALL / PA_TASKS — project and task detail referenced through PROJECT_ID and TASK_ID.
  • GMS_AWARD_PROJECTS — associates grants/awards to the sponsored projects carrying these encumbrances.
  • Project Accounting costing and commitment APIs — consume this table's rows when generating accounting distributions.