Results for “gl_encumbrance_types”

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:

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