Search Results okl_xtd_sell_invs_b




Overview
Explore in AI Chat

Overview

The table OKL_OKL_XTD_SELL_INVS_B is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. As defined in the ETRM documentation, its primary purpose is to store accounting distributions for financial transactions. This table functions as the transactional accounting detail table, capturing the accounting entries generated from specific lease or finance operations, such as sales of investments. It is integral to ensuring accurate financial posting and reporting by maintaining a detailed, auditable record of the accounting impact of transactions processed within the OKL module.

Key Information Stored

The table's structure is designed to hold the essential components of an accounting distribution. While the full column list is not provided in the excerpt, the documented metadata highlights critical relational and key columns. The primary key column is ID, which uniquely identifies each accounting distribution record. A significant foreign key relationship is established via the column XLS_ID, which links back to the parent transaction header or line table, OKL_XTL_SELL_INVS_B. This link ensures traceability from the accounting entry to its source transaction. Typical columns in such a distribution table would also include accounting attributes like Code Combination ID (CCID) for the account, entered and accounted debit/credit amounts, currency, and a reference to the associated accounting event.

Common Use Cases and Queries

This table is primarily accessed for financial inquiry, reconciliation, and audit reporting. A common use case involves tracing the detailed accounting entries created for a specific transaction to verify correct account posting. For instance, an auditor or accountant may query the distributions for a given sales transaction to ensure compliance with accounting rules. A typical SQL pattern would join this table to its parent transaction table and the general ledger code combinations table.

  • Sample Query for Transaction Audit: SELECT d.* FROM okl_xtd_sell_invs_b d, okl_xtl_sell_invs_b t WHERE d.xls_id = t.id AND t.transaction_number = '<TRX_NUM>';
  • Reporting Use Case: Generating a report of all accounting distributions for a set of transactions within a specific period, summarizing debits and credits by general ledger account, often for month-end close reconciliation.

Related Objects

The table exists within a network of related OKL objects. As per the documented foreign key, its primary relationship is with the header/line table OKL_XTL_SELL_INVS_B, which holds the transactional data that sources the accounting entries. It is also intrinsically linked to the OKL accounting engine and its event model. The table's distributions are likely summarized and transferred to the General Ledger (GL) module via the GL interface tables (e.g., GL_JE_BATCHES, GL_JE_LINES). Furthermore, it may be referenced by OKL-specific views designed for financial reporting or by public APIs used for transaction processing and accounting reversal procedures.