Results for “ap_encumbrance_lines_all_efc”

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

Overview

The AP_ENCUMBRANCE_LINES_ALL_EFC table is a denormalized reporting and extract table within the Oracle Payables (AP) module. It is owned by the AP schema and holds the accounted (functional currency) debit and credit amounts associated with encumbrance lines. The "_EFC" suffix denotes an "Encumbrance Functional Currency" structure, engineered to provide pre-aggregated functional-currency balances that feed inquiry screens, fund checking, and standard encumbrance reporting without requiring runtime conversion from the transactional AP_ENCUMBRANCE_LINES_ALL table.

In the 12.1.1 and 12.2.2 releases the object is registered as VALID with a documented physical schema of four columns. Because it carries descriptive attributes keyed to a parent encumbrance line and does not itself act as a junction between two independent entities, its heuristic Data Vault classification is standalone; where a modeling exercise is performed, it is best treated as a satellite attached to the AP_ENCUMBRANCE_LINES_ALL hub, since it adds context (accounted amounts per set of books) to an existing business key.

Key Information Stored

The table is narrow and purpose-built. The documented columns are:

• ENCUMBRANCE_LINE_ID — The surrogate identifier for the encumbrance line. It is the primary key of this table and simultaneously a foreign key to AP_ENCUMBRANCE_LINES_ALL, establishing a strict one-to-one (or one-to-many per set of books) relationship with the parent line.
• SET_OF_BOOKS_ID — Identifies the ledger in which the accounted amounts were recorded. Because encumbrances can be represented in multiple ledgers, this column is a business-key candidate that qualifies the balance rows and allows multi-ledger reporting.
• ACCOUNTED_DR — The functional-currency debit amount posted for the encumbrance line.
• ACCOUNTED_CR — The functional-currency credit amount posted for the encumbrance line.

The combination of ENCUMBRANCE_LINE_ID and SET_OF_BOOKS_ID functions as the effective business key for retrieving a single accounted balance. No additional descriptive columns are documented in the ETRM 12.2.2 schema.

Common Use Cases and Queries

The primary use is encumbrance balance reporting and funds-available analysis at the ledger level. A typical pattern joins the table to its parent line to retrieve purchase-order or requisition context:

SELECT e.encumbrance_line_id,
       e.set_of_books_id,
       e.accounted_dr,
       e.accounted_cr,
       (e.accounted_dr - e.accounted_cr) AS net_encumbrance
FROM   ap_encumbrance_lines_all_efc e
WHERE  e.set_of_books_id = :ledger_id;

Common reporting scenarios include reconciling encumbrance balances to the GL for a given period, presenting functional-currency encumbrance detail on custom inquiry pages, and feeding budget-versus-actual extracts into a data warehouse. Developers frequently use the table to avoid repeated currency conversion logic, since the accounted amounts are already stored in functional currency.

Related Objects

• AP_ENCUMBRANCE_LINES_ALL — The parent transactional table; joined on AP_ENCUMBRANCE_LINES_ALL_EFC.ENCUMBRANCE_LINE_ID = AP_ENCUMBRANCE_LINES_ALL.ENCUMBRANCE_LINE_ID. This is the only documented foreign-key relationship.
• AP_ENCUMBRANCE_LINES — The transactional base table underlying the encumbrance line detail.
• AP_ENCUMBRANCES_ALL — The encumbrance header table, linked to lines via the encumbrance header identifier.
• GL_LEDGERS / GL_SETS_OF_BOOKS — Provide the ledger definition for SET_OF_BOOKS_ID.
• GL_JE_LINES / GL_BALANCES — Used for reconciliation of accounted encumbrance amounts to the general ledger.
• GL_CODE_COMBINATIONS — Supplies the accounting flexfield context when encumbrance lines are distributed to accounts.

Because the table is a dependent satellite, direct DML is discouraged; it is maintained through standard Payables encumbrance processing rather than through public APIs.