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:
ENCUMBRANCE_ID— foreign key toGMS_ENCUMBRANCES_ALL, the parent encumbrance header.PROJECT_IDandTASK_ID— the sponsored project and task to which the encumbrance is charged.PEL_EXPENDITURE_ITEM_ID— FK toPA_EXPENDITURE_ITEMS_ALL, linking the encumbrance to an expenditure item.PET_PROJECT_IDandPET_EVENT_NUM— FK toPA_EVENTS, linking to a project event.ENCUMBRANCE_ITEM_DATEandENCUMBRANCE_TYPE— when the item was recorded and its classification.AMOUNT— the encumbered amount, withDENOM_CURRENCY_CODE,ACCT_CURRENCY_CODE, andPROJECT_CURRENCY_CODEproviding the associated currency context.ACCT_RATE_DATE,ACCT_RATE_TYPE,ACCT_EXCHANGE_RATE,PROJECT_RATE_DATE,PROJECT_RATE_TYPE, andPROJECT_EXCHANGE_RATE— conversion details for accounting and project currency amounts.ADJUSTED_ENCUMBRANCE_ITEM_IDandADJUSTMENT_TYPE— support for adjustments and reversals.ORG_ID— the operating unit, and the standard EBS audit columns (CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY).
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_ALLtoGMS_ENCUMBRANCES_ALLonENCUMBRANCE_ID, filtered byPROJECT_IDandORG_ID. - Expenditure linkage: join to
PA_EXPENDITURE_ITEMS_ALLonPEL_EXPENDITURE_ITEM_IDto relate commitments to actual costs. - Event-based reporting: join to
PA_EVENTSonPET_PROJECT_IDandPET_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 viaENCUMBRANCE_ID.PA_EXPENDITURE_ITEMS_ALL— committed-to-actual linkage viaPEL_EXPENDITURE_ITEM_ID.PA_EVENTS— event linkage viaPET_PROJECT_IDandPET_EVENT_NUM.PA_PROJECTS_ALL/PA_TASKS— project and task detail referenced throughPROJECT_IDandTASK_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.
-
Manual encumbrance charged to sponsored projects
-
APPS.GMS_ENCUMBRANCE_ITEMS_V·↳ GMS_ENCUMBRANCES·↳ GMS_ENCUMBRANCE_ITEMS_ALL·↳ PA_EXPENDITURE_TYPES·Explore GMS module →
-
Manual encumbrance charged to sponsored projects
-
APPS.GMS_ENCUMBRANCE_ITEMS_V·↳ GMS_ENCUMBRANCES·↳ GMS_ENCUMBRANCE_ITEMS_ALL·↳ PA_EXPENDITURE_TYPES·Explore GMS module →
-
View: GMS_ENCUMBRANCE_ITEMS 12.1.1
Not implemented in this database·Explore GMS module →
-
View: GMS_ENCUMBRANCE_ITEMS 12.2.2
Not implemented in this database·Explore GMS module →
-
eTRM - GMS Tables and Views 12.1.1
Versions of award and budget workflows. There can be many workflows for an award or budget.
-
eTRM - GMS Tables and Views 12.2.2
Versions of award and budget workflows. There can be many workflows for an award or budget.