Results for “ap_encumbrance_lines_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP.AP_ENCUMBRANCE_LINES_ALL is a transactional table owned by the Oracle Payables (AP) schema that stores all encumbrance entries created by Oracle Payables. It holds one row per encumbrance entry. An encumbrance line may be created to encumber a charge, a quantity variance (QV), an invoice price variance (IPV), or an exchange rate variance (ERV); to unencumber an entry originally created by Purchasing (PO); or to reverse an encumbrance entry once the underlying charge, QV, IPV, or ERV becomes an actual liability. The table is central to the Payables subledger accounting flow: it is the source that transfers encumbrance balances into Oracle General Ledger, and it also supports on-screen inquiry and reporting of encumbrance activity. The application does not permit direct updates to this table through the user interface.

The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. Under the ETRM 12.2.2 documented physical schema it contains 35 columns and a single unique index. The table carries a Data Vault style classification of link mined from its foreign-key structure, suggesting a modeling role as a connecting entity that associates invoice distributions, accounting headers, code combinations, and encumbrance types rather than acting as a standalone hub or descriptive satellite.

Key Information Stored

The surrogate primary key is ENCUMBRANCE_LINE_ID (NUMBER(15)), which also anchors the unique index AP_ENCUMBRANCE_LINES_U1. There is no separate documented business-key unique index beyond this identifier.

• ENCUMBRANCE_LINE_ID — surrogate primary key, unique per encumbrance line (AP_ENCUMBRANCE_LINES_U1).
• INVOICE_DISTRIBUTION_ID — links the encumbrance line to the AP invoice distribution it is associated with; indexed by AP_ENCUMBRANCE_LINES_N1.
• ENCUMBRANCE_LINE_TYPE — identifies the nature of the line; valid values are CHARGE, QV, IPV, or ERV.
• ACCOUNTING_DATE and PERIOD_NAME — the accounting date and accounting period in which the encumbrance is recognized.
• REVERSAL_FLAG — Y or N; indicates whether the line unencumbers an amount that has become an actual. Lines flagged Y are picked up by the Transfer to GL process.
• ENCUMBRANCE_TYPE_ID — foreign key to GL_ENCUMBRANCE_TYPES, identifying the encumbrance type (for example, commitment or obligation).
• CODE_COMBINATION_ID — Accounting Flexfield identifier for the account against which the encumbrance was created; FK to GL_CODE_COMBINATIONS.
• ACCOUNTED_DR and ACCOUNTED_CR — the debit and credit amounts encumbered on the line.
• AE_HEADER_ID — FK to AP_AE_HEADERS_ALL; indexed by AP_ENCUMBRANCE_LINES_N2.
• GL_SL_LINK_ID — subledger-to-GL link identifier used during transfer to GL; indexed by AP_ENCUMBRANCE_LINES_N3.
• STAT_AMOUNT — statistical amount carried on the line.
• SUBLEDGER_DOC_SEQUENCE_ID and SUBLEDGER_DOC_SEQUENCE_VALUE — FK to FND_DOCUMENT_SEQUENCES, supporting document sequencing.
• ORG_ID — multi-organization identifier supporting operating unit security.
• PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID — concurrent program audit context.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include reconciling Payables encumbrances against Purchasing commitments, diagnosing Transfer to GL discrepancies, and reporting encumbrance activity by account, period, or invoice. A common pattern joins the encumbrance line to the invoice distribution and, when tracing GL impact, to the AE header and GL link.

• Encumbrance detail by period and account: select ENCUMBRANCE_LINE_TYPE, ACCOUNTED_DR, ACCOUNTED_CR from AP_ENCUMBRANCE_LINES_ALL where PERIOD_NAME = :period and CODE_COMBINATION_ID = :ccid.
• Reversal and unencumbrance analysis: filter REVERSAL_FLAG = 'Y' to identify lines eligible for Transfer to GL.
• Invoice-level drill-down: join on INVOICE_DISTRIBUTION_ID to AP_INVOICE_DISTRIBUTIONS for source document context.
• GL transfer reconciliation: join ACCOUNTED_DR/ACCOUNTED_CR to GL_IMPORT_REFERENCES or use GL_SL_LINK_ID to confirm the Create Accounting and Transfer to GL payload.
• Type-based reporting: group by ENCUMBRANCE_LINE_TYPE (CHARGE, QV, IPV, ERV) and join ENCUMBRANCE_TYPE_ID to GL_ENCUMBRANCE_TYPES for descriptive labels.
• Multi-org reporting: partition queries by ORG_ID to satisfy operating unit security requirements.

Related Objects

• AP_AE_HEADERS_ALL — referenced via AE_HEADER_ID; supplies the subledger accounting header for the encumbrance line.
• GL_CODE_COMBINATIONS — referenced via CODE_COMBINATION_ID; provides the accounting account definition.
• GL_ENCUMBRANCE_TYPES — referenced via ENCUMBRANCE_TYPE_ID; supplies encumbrance type definitions.
• FND_DOCUMENT_SEQUENCES — referenced via SUBLEDGER_DOC_SEQUENCE_ID; supports document sequencing.
• AP_INVOICE_DISTRIBUTIONS_ALL — joinable via INVOICE_DISTRIBUTION_ID for invoice distribution detail.
• CST_ENCUMBRANCE_LINES — references AP_ENCUMBRANCE_LINES_ALL via ENCUMBRANCE_LINE_ID; links Cost Management encumbrance processing.
• AP_ENCUMBRANCE_LINES_ALL_EFC — the EFC (Offer of Payment) extension table referencing the same key.
• GL_SL_LINK_ID — links to the GL subledger accounting reconciliation structures used by Transfer to GL.