Search Results okl_trns_acc_dstrs

Overview

The OKL_TRNS_ACC_DSTRS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It serves as the primary repository for detailed accounting distribution records generated from transactional events. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the subledger accounting architecture for leasing operations, capturing the debit and credit entries that constitute the journal postings for contracts, invoices, and other financial activities. Its role is to store the final, accounted distributions that are subsequently transferred to the General Ledger (GL), ensuring accurate financial reporting and compliance.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the foreign keys, the table's description as "Accounting distributions" implies it holds critical accounting attributes. Based on standard EBS accounting distribution models, key information stored would typically include a unique distribution identifier (the ID column, serving as the primary key), the accounted amounts (both functional and transactional currency), the accounting date, and the specific General Ledger code combination identifiers (CCIDs) for the debits and credits. Crucially, it stores foreign key references to link each distribution to its source accounting event (AET_ID) and its originating accounting template (TEMPLATE_ID), which defines the accounting rules.

Common Use Cases and Queries

This table is central to accounting inquiry, reconciliation, and audit processes. A common use case is tracing the detailed journal entries for a specific lease transaction or accounting event. For instance, to retrieve all accounting distributions for a particular accounting event, one would query using the AET_ID foreign key. Sample reporting queries often join this table to OKL_ACCOUNTING_EVENTS to get event-level context and to GL_CODE_COMBINATIONS to resolve the actual account segments. Analysts may also query distributions generated from a specific accounting template (TEMPLATE_ID) to validate the application of accounting rules. Given the metadata note "Not implemented in this database," direct queries in a given environment may require validation of actual deployment.

Related Objects

The OKL_TRNS_ACC_DSTRS table has documented foreign key relationships with two primary parent tables in the OKL accounting schema, as per the provided metadata:

• OKL_ACCOUNTING_EVENTS: Linked via the column OKL_TRNS_ACC_DSTRS.AET_ID. This relationship ties each detailed accounting distribution line to the higher-level accounting event that triggered it, such as an invoice creation or a revenue recognition batch.
• OKL_AE_TEMPLATES: Linked via the column OKL_TRNS_ACC_DSTRS.TEMPLATE_ID. This relationship connects the distribution to the specific accounting template (rule set) that determined the accounts (CCIDs) and accounting logic used to create it.

These relationships are essential for navigating from a high-level transaction to its detailed accounted journal lines and for understanding the provenance of the accounting entries.