Search Results ap_encumbrance_lines_all




Overview
Explore in AI Chat

Overview

The AP_ENCUMBRANCE_LINES_ALL table is a core transactional table within the Oracle E-Business Suite Payables (AP) module. It serves as the detailed repository for all encumbrance entries generated from the procurement and purchasing cycle. Encumbrances, also known as commitments or obligations, represent a reservation of funds for anticipated expenditures, such as purchase orders or requisitions, prior to the actual invoice and payment. This table is integral to budgetary control and funds checking processes, ensuring that financial commitments are tracked against available budgets. Its multi-org structure, indicated by the "_ALL" suffix, stores data for all operating units, with access typically controlled by a security profile.

Key Information Stored

The table stores the detailed line-level information for each encumbrance transaction. Its primary key is the ENCUMBRANCE_LINE_ID. Critical columns include AE_HEADER_ID, which links the line to its corresponding accounting entry header in the AP_AE_HEADERS_ALL table, establishing the tie to the general ledger. The CODE_COMBINATION_ID column stores the accounting flexfield (AFF) identifier for the encumbered account, linking to GL_CODE_COMBINATIONS. The ENCUMBRANCE_TYPE_ID links to GL_ENCUMBRANCE_TYPES to classify the nature of the commitment (e.g., Purchase Order, Requisition). Financial amounts, such as the encumbered and relieved amounts, are stored alongside document references like the SUBLEDGER_DOC_SEQUENCE_ID, which links to FND_DOCUMENT_SEQUENCES for audit trails.

Common Use Cases and Queries

This table is central to inquiries and reports on outstanding purchase commitments and budgetary availability. A common use case is reconciling the encumbrance balance for a specific account segment or cost center. A typical query would join to related tables to analyze un-relieved encumbrances.

Sample Query Pattern:

  • SELECT aela.encumbrance_line_id, gcc.segment1, aela.encumbered_amount - NVL(aela.relieved_amount,0) AS outstanding_encumbrance
  • FROM ap_encumbrance_lines_all aela,
  • gl_code_combinations gcc
  • WHERE aela.code_combination_id = gcc.code_combination_id
  • AND aela.encumbered_amount <> NVL(aela.relieved_amount,0);

This table is also critical for period-end closing procedures, where encumbrance balances are carried forward or closed, and for audit reports tracing the lifecycle of a commitment from creation through invoice matching and final relief.

Related Objects

AP_ENCUMBRANCE_LINES_ALL maintains defined foreign key relationships with several key EBS objects, as documented in the ETRM metadata:

  • GL_CODE_COMBINATIONS: Joined via CODE_COMBINATION_ID to retrieve the full accounting flexfield context for the encumbered account.
  • GL_ENCUMBRANCE_TYPES: Joined via ENCUMBRANCE_TYPE_ID to classify the encumbrance transaction type.
  • FND_DOCUMENT_SEQUENCES: Joined via SUBLEDGER_DOC_SEQUENCE_ID for document sequencing and audit information.
  • AP_AE_HEADERS_ALL: Joined via AE_HEADER_ID, which is the primary link between the encumbrance line and its corresponding subledger accounting entry, forming the bridge to the General Ledger.