Results for “subledger_doc_sequence_value”

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

Overview

AP_ENCUMBRANCE_LINES_ALL is a Payables (AP) module table in the Oracle E-Business Suite 12.1.1 / 12.2.2 data model, owned by the AP schema. As its documentation states, it is the Encumbrance lines table, storing the individual encumbrance accounting lines generated when invoices and their distributions create, adjust, or reverse commitments against budgetary funds. Encumbrance accounting is the mechanism by which Oracle Purchasing and Payables reserve budget for commitments — requisitions, purchase orders, and unpaid invoices — and this table persists each resulting encumbrance entry at the line level, tagged with its General Ledger accounting distribution.

Functionally, AP_ENCUMBRANCE_LINES_ALL acts as the AP-side repository that feeds GL interface processing: lines written here are picked up by the Subledger Accounting (SLA) engine and transferred to General Ledger as encumbrance journal entries. The heuristic Data Vault classification mined from the foreign-key structure is link, suggesting the table is best modeled as a relationship/associative construct that connects an encumbrance event (via AE_HEADER_ID to AP_AE_HEADERS_ALL) to a chart-of-accounts distribution (CODE_COMBINATION_ID to GL_CODE_COMBINATIONS) and an encumbrance category (ENCUMBRANCE_TYPE_ID to GL_ENCUMBRANCE_TYPES).

Key Information Stored

The documented physical schema comprises 35 columns. The most significant of these are:

• ENCUMBRANCE_LINE_ID — the surrogate primary key, enforced by unique index AP_ENCUMBRANCE_LINES_U1 and constraint AP_ENCUMBRANCE_LINES_PK. This is the single documented unique/business-key candidate.
• AE_HEADER_ID — foreign key to AP_AE_HEADERS_ALL, the parent subledger accounting header that groups the encumbrance entry.
• INVOICE_DISTRIBUTION_ID — links the encumbrance line to the originating invoice distribution.
• ENCUMBRANCE_LINE_TYPE — categorizes the nature of the line (for example, creation, adjustment, or reversal of an encumbrance).
• ENCUMBRANCE_TYPE_ID — foreign key to GL_ENCUMBRANCE_TYPES, identifying the commitment type (e.g., purchase order encumbrance).
• CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, the accounting flexfield distribution.
• ACCOUNTING_DATE and PERIOD_NAME — the accounting date and GL period to which the encumbrance is posted.
• REVERSAL_FLAG — indicates whether the line reverses a prior encumbrance.
• ACCOUNTED_DR and ACCOUNTED_CR — the accounted debit and credit amounts, the core monetary values.
• STAT_AMOUNT — the statistical amount associated with the line.
• GL_SL_LINK_ID — the link identifier tying the AP subledger entry to its GL counterpart.
• SUBLEDGER_DOC_SEQUENCE_ID and SUBLEDGER_DOC_SEQUENCE_VALUE — foreign key to FND_DOCUMENT_SEQUENCES plus the assigned sequence value, providing the auditable document number.
• ORG_ID — the operating unit, supporting multi-org partitioning.
• REFERENCE1 through REFERENCE10 — flexible descriptive columns for transaction context.
• Standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and concurrent-program columns (PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) are also present.

Common Use Cases and Queries

The table is queried principally for encumbrance reconciliation, budget-versus-commitment reporting, and GL interface troubleshooting. A typical join reconciles encumbrance lines to their accounting flexfield and encumbrance type:

• Reporting total encumbered amounts by code combination and period: join AP_ENCUMBRANCE_LINES_ALL.CODE_COMBINATION_ID to GL_CODE_COMBINATIONS and filter on PERIOD_NAME.
• Auditing a specific encumbrance document via SUBLEDGER_DOC_SEQUENCE_VALUE.
• Tracing encumbrance entries back to their parent accounting event through AE_HEADER_ID to AP_AE_HEADERS_ALL.
• Investigating reversals by filtering on REVERSAL_FLAG and ENCUMBRANCE_LINE_TYPE.
• Operating-unit–scoped reporting via ORG_ID.

Related Objects

• AP_AE_HEADERS_ALL — joined on AE_HEADER_ID; the parent accounting header.
• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID; the accounting flexfield.
• GL_ENCUMBRANCE_TYPES — joined on ENCUMBRANCE_TYPE_ID; the commitment classification.
• FND_DOCUMENT_SEQUENCES — joined on SUBLEDGER_DOC_SEQUENCE_ID; the document numbering source.
• CST_ENCUMBRANCE_LINES — references this table via ENCUMBRANCE_LINE_ID; Cost Management encumbrance detail.
• AP_ENCUMBRANCE_LINES_ALL_EFC — the EFC (multinational/archival) companion referencing ENCUMBRANCE_LINE_ID.

Together these relationships confirm the table's role as the central AP encumbrance line repository feeding General Ledger and cost accounting processes.