Search Results okl_accounting_events

Overview

The OKL_ACCOUNTING_EVENTS table is a core reference table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master definition table for accounting event types. These event types are critical triggers within the leasing lifecycle that initiate the creation of accounting entries. The table's primary role is to provide a controlled list of valid accounting events, such as lease inception, periodic billing, asset depreciation, or termination, which are then referenced by transactional data to ensure consistent and rule-based accounting.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the table's primary key and its relationships define its essential structure. The central column is ACCOUNTING_EVENT_ID, a unique identifier for each type of accounting event. Based on standard EBS design patterns for such reference tables, other typical columns would include a user-facing CODE and a NAME or DESCRIPTION for the event (e.g., 'LEASE_INCEPTION', 'BILLING'). The table likely also contains control columns such as ENABLED_FLAG, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to manage its master data.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and troubleshooting within the accounting flow of lease contracts. Common scenarios include identifying all accounting events processed for a specific contract or during a period, and validating the existence of an event type. A frequent query pattern joins this table to its related transactional headers to report on accounting activity.

• Listing All Defined Accounting Events: SELECT accounting_event_id, code, name FROM okl_accounting_events WHERE enabled_flag = 'Y' ORDER BY code;
• Finding Transaction Headers for a Specific Event Type: SELECT aeh.header_id, aeh.transaction_date FROM okl_ae_headers aeh, okl_accounting_events aev WHERE aeh.accounting_event_id = aev.accounting_event_id AND aev.code = 'BILLING';

Related Objects

The OKL_ACCOUNTING_EVENTS table has documented foreign key relationships with two key transactional tables, establishing it as a parent reference entity.

• OKL_AE_HEADERS: This table stores the header information for accounting entries. Its ACCOUNTING_EVENT_ID column references OKL_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID, linking every accounting header to its originating event type.
• OKL_TRNS_ACC_DSTRS: This table holds transaction accounting distributions. Its AET_ID column references OKL_ACCOUNTING_EVENTS.ACCOUNTING_EVENT_ID, ensuring each distribution line can be traced back to the core accounting event that triggered it.