Results for “encumbrance_type_key”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GL_ENCUMBRANCE_TYPES is a General Ledger reference table that stores the definitions of encumbrance types used throughout Oracle E-Business Suite. An encumbrance type identifies a class of budgetary reservation — for example Commitment, Obligation, or a user-defined type — applied to journal entries so that pending expenditures and liabilities can be tracked against available funds. The table resides in the GL schema and is classified as VALID, functioning as a shared lookup for all subledger and reporting components that participate in budgetary control.
From a Data Vault modeling perspective, the mined foreign-key structure suggests this object behaves as a hub: it holds the durable, unique business concepts (encumbrance types) that many satellites and links reference. Encumbrance types are seeded during General Ledger setup and are referenced by dozens of transactional and summary tables across Purchasing, Payables, Projects, Receivables, and Cost Management.
Because encumbrance types are consumed by virtually every module that posts budgetary entries, the table is a foundational control point. If a type is disabled, new encumbrances cannot be created with it, though historical references remain intact.
Key Information Stored
The table contains 11 documented columns. The most significant are:
- ENCUMBRANCE_TYPE_ID — Surrogate primary key. Defined by
GL_ENCUMBRANCE_TYPES_PK. This is the value propagated to all foreign-key references across the EBS schema. - ENCUMBRANCE_TYPE — The user-facing name of the type (for example, Commitment). A business-key candidate via
GL_ENCUMBRANCE_TYPES_U2, unique together withZD_EDITION_NAME. - ENCUMBRANCE_TYPE_KEY — An internal key value; a business-key candidate via
GL_ENCUMBRANCE_TYPES_U3, unique withZD_EDITION_NAME. - ENABLED_FLAG — Indicates whether the encumbrance type is active and selectable on transactions. Only enabled types appear in List of Values prompts.
- DESCRIPTION — Free-text description explaining the intended purpose of the type.
- ZD_EDITION_NAME — Edition column supporting the Edition-Based Redefinition (EBR) architecture introduced in 12.2, used to scope unique keys by edition.
- LAST_UPDATE_DATE / LAST_UPDATED_BY / CREATION_DATE / CREATED_BY / LAST_UPDATE_LOGIN — Standard WHO audit columns tracking creation and modification history.
Common Use Cases and Queries
Encumbrance types surface in fund-availability reporting, commitment and obligation aging reports, and reconciliation of budgetary balances to subledger activity. A frequent requirement is resolving an ENCUMBRANCE_TYPE_ID returned from a subledger query into a readable name. For example, joining Payables encumbrance lines to the type definition:
SELECT ael.encumbrance_type_id, get.encumbrance_type, get.enabled_flag
FROM ap_encumbrance_lines_all ael, gl_encumbrance_types get
WHERE ael.encumbrance_type_id = get.encumbrance_type_id;
Because the user searched for ap_encumbrance_lines_all, the most relevant pattern is this direct join: AP_ENCUMBRANCE_LINES_ALL.ENCUMBRANCE_TYPE_ID is the documented foreign key to GL_ENCUMBRANCE_TYPES. Analysts enumerating enabled types for a List of Values should filter with WHERE enabled_flag = 'Y'. Balance inquiries frequently join GL_BALANCES.ENCUMBRANCE_TYPE_ID to distinguish commitment balances from obligation balances in the same account.
Related Objects
- AP_ENCUMBRANCE_LINES_ALL — Join on
ENCUMBRANCE_TYPE_ID; holds Payables encumbrance detail lines. - GL_BALANCES and GL_BALANCES_DELTA — Join on
ENCUMBRANCE_TYPE_ID; store budgetary and encumbrance account balances. - GL_JE_HEADERS — Join on
ENCUMBRANCE_TYPE_ID; tags journal entries with their encumbrance type. - FINANCIALS_SYSTEM_PARAMS_ALL — Three foreign keys (
REQ_ENCUMBRANCE_TYPE_ID,PURCH_ENCUMBRANCE_TYPE_ID,INV_ENCUMBRANCE_TYPE_ID) designate default requisition, purchasing, and inventory encumbrance types. - CE_FORECAST_ROWS — Join on
ENCUMBRANCE_TYPE_IDfor cash forecasting. - XLA_AE_LINES and XLA_AE_HEADERS — Join on
ENCUMBRANCE_TYPE_ID; Subledger Accounting entries carrying encumbrance context. - PO_ENCUMBRANCE_GT, RCV_SUB_LEDGER_DETAILS, PA_GL_INTERFACE — Additional consumers across Purchasing, Receiving, and Projects.
-
Encumbrance type definitions
-
Encumbrance type definitions
-
Interface table for passing transactions to the commitment budgetary control submodule for funds checking and reservation
-
VIEW: IGC.IGC_CC_INTERFACE# 12.2.2
-
VIEW: IGC.IGC_CC_INTERFACE# 12.2.2
-
TABLE: IGC.IGC_CC_INTERFACE 12.2.2
-
PACKAGE BODY: APPS.CSTPAPBR 12.2.2
-
PACKAGE: APPS.CSTPAPBR 12.2.2
-
APPS.CSTPAPBR SQL Statements 12.2.2
-
APPS.CSTPACDP SQL Statements 12.2.2
-
PACKAGE BODY: APPS.CSTPAPBR 12.2.2
-
PACKAGE BODY: APPS.CSTPACDP 12.2.2
-
eTRM - IGC Tables and Views 12.2.2
System parameters for contracts
-
This table contains the tracking information that Golden Gate will use to launch Journal Import.
-
USSGL transaction codes