Search Results okl_trns_acc_dstrs_all




Overview
Explore in AI Chat

Overview

The OKL_TRNS_ACC_DSTRS_ALL table is a core transactional data object within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the OKL (Lease and Finance Management) product module. As indicated by its description, this table stores accounting distributions. Its primary role is to record the detailed accounting entries generated from financial transactions processed by the Oracle Lease Management system. These distributions represent the debit and credit postings that will ultimately be transferred to the Oracle General Ledger. The table is designed to support multi-organization architectures, as denoted by the "_ALL" suffix, meaning it stores data for all operating units accessible to a user, with data partitioned by the ORG_ID column.

Key Information Stored

The table's structure is designed to capture the essential attributes of an accounting distribution. While the full column list is not provided in the metadata, the foreign key relationships and primary key reveal critical data points. The primary key column, ID, uniquely identifies each distribution record. Two significant foreign keys define the distribution's context: AET_ID links to the OKL_ACC_EVENTS_ALL table, associating the distribution with a specific accounting event (e.g., invoice creation, payment application, depreciation). TEMPLATE_ID links to the OKL_AE_TEMPLATES_ALL table, indicating the accounting template or rule set used to generate the distribution. Other typical columns in such a table would include amounts (e.g., accounted amount, entered amount), currency codes, accounting date, ledger ID, code combination IDs (CCIDs) for the specific debit or credit account, and the ORG_ID for multi-org partitioning.

Common Use Cases and Queries

This table is central to financial reporting and reconciliation within Oracle Lease Management. Common use cases include tracing the complete accounting impact of a lease contract event, auditing journal entry sources, and troubleshooting accounting generation errors. A frequent query pattern involves joining to related transaction and event tables to retrieve a full accounting audit trail. For example, to review distributions for a specific accounting event, one might use a SQL pattern such as:

  • SELECT dstr.* FROM okl_trns_acc_dstrs_all dstr WHERE dstr.aet_id = <event_id>;

For reporting, analysts often aggregate data from this table by account, event type, or period, joining with OKL_ACC_EVENTS_ALL for event details and GL_CODE_COMBINATIONS for account segment information, to produce detailed subledger journals.

Related Objects

The OKL_TRNS_ACC_DSTRS_ALL table is a key junction within the OKL accounting schema. As documented, it has direct foreign key dependencies on two primary tables:

  • OKL_ACC_EVENTS_ALL: The parent table for accounting events. Each distribution record is a child of a specific event in this table via the AET_ID column.
  • OKL_AE_TEMPLATES_ALL: The source of the accounting rules. The TEMPLATE_ID links the distribution to the template that defined its accounting attributes.

This table is also a likely source for key public interfaces and views that consolidate accounting data for reporting and integration, such as the OKL Accounting Engine's transfer to General Ledger. Direct queries or custom reports on this table should always respect the multi-org security model by including a condition on the ORG_ID column.