Search Results okl_txl_cntrct_lns_all

Overview

The table OKL_TXL_CNTRCT_LNS_ALL is a core transactional data store within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as the lease transactions line table, holding detailed line-level information for all financial transactions associated with lease contracts. This table is critical for the operational and accounting integrity of the leasing module, as it records the granular financial events—such as invoices, payments, adjustments, and accruals—that are posted against specific lease streams or billing lines. Its multi-org structure, denoted by the "_ALL" suffix, allows it to store data for multiple operating units, making it a foundational table for enterprise-wide lease portfolio management in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the ID column, which uniquely identifies each transaction line. Its structure is defined by a series of foreign key relationships that link each transaction line to other essential entities in the leasing system. Key columns, as indicated by the foreign key metadata, include KHR_ID, which links the line to its parent lease contract header in the OKL_K_HEADERS table. The STY_ID column associates the transaction line with a specific stream type (e.g., rent, interest, tax) defined in OKL_STRM_TYPE_B. For accounting integration, the AVL_ID column references the accounting template (OKL_AE_TEMPLATES_ALL) used to generate journal entries. Other significant columns include BTC_ID and RCT_ID for cash batch and receipt processing links, BKT_ID for associating transactions with defined buckets, and TCN_ID, which may establish a relationship to other transaction lines within the same table for hierarchical transaction structures.

Common Use Cases and Queries

This table is central to transaction inquiry, audit reporting, and reconciliation processes. A common use case involves generating a detailed transaction history for a specific lease contract to support customer service or financial analysis. A typical query would join OKL_TXL_CNTRCT_LNS_ALL to the contract header (OKL_K_HEADERS) and stream type (OKL_STRM_TYPE_B) to produce a readable report. Another critical scenario is supporting the period-end close process, where accountants query transaction lines posted within a specific date range and operating unit to verify accruals and revenue recognition. Developers customizing or extending the leasing module would interact with this table when building interfaces to downstream systems or creating custom dashboards that aggregate transactional lease data.

Related Objects

The functionality of OKL_TXL_CNTRCT_LNS_ALL is deeply interconnected with numerous other EBS objects. As per the provided metadata, its primary foreign key dependencies are:

• OKL_K_HEADERS: The master lease contract table.
• OKL_STRM_TYPE_B: The definition table for financial stream types.
• OKL_AE_TEMPLATES_ALL: Stores the accounting rules for transaction posting.
• OKL_TRX_CSH_BATCH_ALL_B & OKL_TRX_CSH_RCPT_ALL_B: For cash management integration.
• OKL_BUCKETS: For categorizing transactions into user-defined groups.
• OKL_TXL_CNTRCT_LNS_ALL (self-reference via TCN_ID): For modeling parent-child relationships between transaction lines.

In practice, this table is also heavily accessed by standard OKL APIs, seeded concurrent programs for transaction processing, and key base views that provide application-level access to the data.