Search Results gl_encumbrance_types

Overview

The GL_ENCUMBRANCE_TYPES table is a core reference table within the Oracle E-Business Suite General Ledger (GL) module, specifically for release 12.1.1 and 12.2.2. It serves as the master repository for defining and storing all encumbrance types used across the financial system. Encumbrance accounting is a budgetary control mechanism that reserves funds for anticipated future expenditures, such as purchase requisitions or purchase orders, ensuring that budgets are not overspent. This table provides the foundational definitions that enable the system to track, post, and report on these commitments separately from actual expenses. Its central role is evidenced by its extensive foreign key relationships with numerous transactional and balance tables across GL and other financial modules.

Key Information Stored

While the provided metadata does not list specific columns, the primary and foreign key relationships define its critical structure. The table's primary key is ENCUMBRANCE_TYPE_ID, a unique identifier for each encumbrance type definition. Typical columns in this reference table, based on standard EBS design, would include fields such as NAME, DESCRIPTION, ENABLED_FLAG, and potentially attributes controlling the encumbrance's behavior (e.g., whether it is used for commitments or obligations). The ENCUMBRANCE_TYPE_ID column is the central point of reference, linked to a vast array of downstream tables that store encumbrance-related transactions and balances.

Common Use Cases and Queries

This table is primarily referenced for reporting, setup validation, and data integrity checks. Common operational scenarios include generating reports that summarize activity by encumbrance type, validating the setup of encumbrance types used in Subledger Accounting rules, and troubleshooting data issues in encumbrance journals. A fundamental query retrieves all active encumbrance types: SELECT encumbrance_type_id, name FROM gl_encumbrance_types WHERE enabled_flag = 'Y';. Another critical use case is joining to balance tables (like GL_BALANCES) to analyze encumbered amounts: SELECT get.name, SUM(gb.period_net_dr - gb.period_net_cr) FROM gl_balances gb, gl_encumbrance_types get WHERE gb.encumbrance_type_id = get.encumbrance_type_id GROUP BY get.name;. System administrators may also query it to identify which encumbrance types are configured in Financials System Parameters for Requisitions, Purchasing, and Inventory.

Related Objects

The GL_ENCUMBRANCE_TYPES table has a foundational relationship with a significant portion of the General Ledger's core transactional architecture, as documented by its foreign keys. Key related objects include:

• GL_BALANCES and GL_BC_PACKETS: Store actual and budget/encumbrance balance information keyed by ENCUMBRANCE_TYPE_ID.
• GL_JE_HEADERS, GL_INTERFACE, and GL_POSTING_INTERIM: Journal entry processing tables that reference the encumbrance type.
• AP_ENCUMBRANCE_LINES_ALL: Links Payables encumbrance transactions to their GL type definition.
• FINANCIALS_SYSTEM_PARAMS_ALL: Critical setup table where system-wide default encumbrance types for Requisitions (REQ_ENCUMBRANCE_TYPE_ID), Purchasing (PURCH_ENCUMBRANCE_TYPE_ID), and Inventory (INV_ENCUMBRANCE_TYPE_ID) are stored.
• CE_FORECAST_ROWS and IGC_CBC_JE_LINES: Used in Cash Management and Public Budgetary Control for forecasting and budgetary accounting.
• Archive and History tables (GL_ARCHIVE_BALANCES, GL_INTERFACE_HISTORY): Maintain historical data tied to encumbrance types.